PREVIEW / etf_30min / 2009-08-11

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-11.parquet
  size:    227 KB
  rows:    7,411

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2009-08-11 04:00:00	SPY	ETF	101.44	101.48	101.44	101.48	2081.0
2009-08-11 05:00:00	SPY	ETF	101.4	101.4	101.3	101.3	2600.0
2009-08-11 05:30:00	SPY	ETF	101.28	101.28	101.2	101.2	1200.0
2009-08-11 06:00:00	SPY	ETF	101.2	101.2	100.95	100.95	10300.0
2009-08-11 06:30:00	SPY	ETF	100.98	101.05	100.93	101.05	18900.0
2009-08-11 07:00:00	SPY	ETF	101.02	101.14	100.98	100.99	119409.0
2009-08-11 07:30:00	SPY	ETF	101.0	101.0	100.8	100.84	503043.0
2009-08-11 08:00:00	SPY	ETF	100.83	101.08	100.83	101.08	907041.0
2009-08-11 08:30:00	SPY	ETF	101.1	101.16	100.7	100.76	1970184.0
2009-08-11 09:00:00	SPY	ETF	100.75	100.75	100.48	100.53	1726497.0
2009-08-11 09:30:00	SPY	ETF	100.54	100.61	100.07	100.26	20762151.0
2009-08-11 10:00:00	SPY	ETF	100.25	100.46	99.74	99.77	14982742.0
2009-08-11 10:30:00	SPY	ETF	99.7617	99.91	99.69	99.8717	11142161.0
2009-08-11 11:00:00	SPY	ETF	99.87	100.42	99.46	99.7	12639920.0
2009-08-11 11:30:00	SPY	ETF	99.69	99.75	99.55	99.67	6821972.0
2009-08-11 12:00:00	SPY	ETF	99.67	99.82	99.61	99.68	5179008.0
2009-08-11 12:30:00	SPY	ETF	99.68	99.76	99.46	99.5	5191744.0
2009-08-11 13:00:00	SPY	ETF	99.49	100.475	99.47	99.51	7102531.0
2009-08-11 13:30:00	SPY	ETF	99.51	99.82	99.5	99.7201	4456574.0
2009-08-11 14:00:00	SPY	ETF	99.72	100.02	99.72	99.89	13227980.0
2009-08-11 14:30:00	SPY	ETF	99.88	100.0	99.73	99.99	8671907.0
2009-08-11 15:00:00	SPY	ETF	99.99	100.12	99.87	100.0	10958624.0
2009-08-11 15:30:00	SPY	ETF	99.99	100.11	99.63	99.66	16987611.0
2009-08-11 16:00:00	SPY	ETF	99.66	99.8	99.55	99.71	9915548.0
2009-08-11 16:30:00	SPY	ETF	99.71	99.75	99.63	99.75	2189583.0
2009-08-11 17:00:00	SPY	ETF	99.75	100.928	99.68	99.7	1037328.0
2009-08-11 17:30:00	SPY	ETF	99.64	99.69	99.63	99.67	37200.0
2009-08-11 18:00:00	SPY	ETF	99.69	99.75	99.66	99.72	30000.0
2009-08-11 18:30:00	SPY	ETF	99.72	99.75	99.7	99.72	9709.0
2009-08-11 19:00:00	SPY	ETF	99.72	99.74	99.7	99.71	1600.0
2009-08-11 19:30:00	SPY	ETF	99.74	99.75	99.72	99.74	6338.0
2009-08-11 04:00:00	QQQ	ETF	39.8	39.8	39.79	39.79	1567.0
2009-08-11 05:00:00	QQQ	ETF	39.8	39.8	39.8	39.8	5000.0
2009-08-11 06:00:00	QQQ	ETF	39.68	39.68	39.62	39.62	600.0
2009-08-11 07:00:00	QQQ	ETF	39.67	39.7	39.67	39.7	7400.0
2009-08-11 07:30:00	QQQ	ETF	39.67	39.67	39.6	39.61	207911.0
2009-08-11 08:00:00	QQQ	ETF	39.61	39.74	39.59	39.73	613069.0
2009-08-11 08:30:00	QQQ	ETF	39.73	39.77	39.51	39.52	1135182.0
2009-08-11 09:00:00	QQQ	ETF	39.51	39.51	39.4	39.41	2042427.0
2009-08-11 09:30:00	QQQ	ETF	39.41	39.5	39.26	39.36	15934518.0
2009-08-11 10:00:00	QQQ	ETF	39.36	39.365	39.17	39.19	10642640.0
2009-08-11 10:30:00	QQQ	ETF	39.2	39.2301	39.07	39.13	9659233.0
2009-08-11 11:00:00	QQQ	ETF	39.12	39.15	39.05	39.13	5109015.0
2009-08-11 11:30:00	QQQ	ETF	39.13	39.18	39.08	39.1499	2715885.0
2009-08-11 12:00:00	QQQ	ETF	39.14	39.2	39.11	39.15	4193879.0
2009-08-11 12:30:00	QQQ	ETF	39.15	39.2	39.08	39.081	1874573.0
2009-08-11 13:00:00	QQQ	ETF	39.08	39.15	39.07	39.08	1903652.0
2009-08-11 13:30:00	QQQ	ETF	39.08	39.2	39.075	39.1622	2821104.0
2009-08-11 14:00:00	QQQ	ETF	39.17	39.31	39.165	39.28	6527520.0
2009-08-11 14:30:00	QQQ	ETF	39.28	39.33	39.2211	39.33	5192178.0

> showing 50 of 7,411 rows — these rows as CSV

> unlock the full archive -- $79 one-time