PREVIEW / etf_30min / 2009-07-10

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-10.parquet
  size:    207 KB
  rows:    6,927

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-07-10 04:00:00	SPY	ETF	88.19	88.19	88.13	88.13	1000.0
2009-07-10 04:30:00	SPY	ETF	88.2	88.2	88.2	88.2	500.0
2009-07-10 05:00:00	SPY	ETF	87.96	87.96	87.96	87.96	2000.0
2009-07-10 05:30:00	SPY	ETF	87.91	87.91	87.88	87.88	2200.0
2009-07-10 06:00:00	SPY	ETF	87.78	87.78	87.7	87.74	6500.0
2009-07-10 06:30:00	SPY	ETF	87.84	87.84	87.64	87.71	6500.0
2009-07-10 07:00:00	SPY	ETF	87.66	87.78	87.6	87.67	281440.0
2009-07-10 07:30:00	SPY	ETF	87.68	87.76	87.56	87.62	182080.0
2009-07-10 08:00:00	SPY	ETF	87.62	87.78	87.52	87.57	1804245.0
2009-07-10 08:30:00	SPY	ETF	87.58	87.8	87.58	87.7	531316.0
2009-07-10 09:00:00	SPY	ETF	87.7	88.2	87.61	87.71	721736.0
2009-07-10 09:30:00	SPY	ETF	87.7	88.49	87.65	88.0	29527642.0
2009-07-10 10:00:00	SPY	ETF	87.99	88.35	87.64	88.26	18545625.0
2009-07-10 10:30:00	SPY	ETF	88.26	88.28	87.89	88.01	10179922.0
2009-07-10 11:00:00	SPY	ETF	88.0	88.01	87.3683	87.48	14442616.0
2009-07-10 11:30:00	SPY	ETF	87.47	87.64	87.35	87.54	8756912.0
2009-07-10 12:00:00	SPY	ETF	87.54	88.3532	87.5	87.7401	9216038.0
2009-07-10 12:30:00	SPY	ETF	87.75	88.04	87.66	87.86	8871644.0
2009-07-10 13:00:00	SPY	ETF	87.8699	88.05	87.81	87.83	7377975.0
2009-07-10 13:30:00	SPY	ETF	87.82	88.3532	87.82	88.0502	7640954.0
2009-07-10 14:00:00	SPY	ETF	88.06	88.06	87.67	87.81	7114366.0
2009-07-10 14:30:00	SPY	ETF	87.8101	87.95	87.73	87.74	8285380.0
2009-07-10 15:00:00	SPY	ETF	87.74	88.02	87.7	87.79	10225456.0
2009-07-10 15:30:00	SPY	ETF	87.78	88.22	87.71	87.94	19477788.0
2009-07-10 16:00:00	SPY	ETF	87.92	88.3532	87.81	87.96	8786774.0
2009-07-10 16:30:00	SPY	ETF	87.96	88.0	87.76	87.82	727797.0
2009-07-10 17:00:00	SPY	ETF	87.83	87.87	87.79	87.82	51196.0
2009-07-10 17:30:00	SPY	ETF	87.82	88.0	87.82	87.85	92309.0
2009-07-10 18:00:00	SPY	ETF	87.85	87.88	87.85	87.87	19075.0
2009-07-10 18:30:00	SPY	ETF	87.87	87.88	87.6422	87.87	13720.0
2009-07-10 19:00:00	SPY	ETF	87.86	87.88	87.85	87.85	6000.0
2009-07-10 19:30:00	SPY	ETF	87.86	87.88	87.8	87.86	25058.0
2009-07-10 05:00:00	QQQ	ETF	34.68	34.68	34.68	34.68	200.0
2009-07-10 05:30:00	QQQ	ETF	34.66	34.66	34.65	34.65	2100.0
2009-07-10 06:00:00	QQQ	ETF	34.63	34.63	34.63	34.63	100.0
2009-07-10 06:30:00	QQQ	ETF	34.65	34.65	34.6	34.6	2000.0
2009-07-10 07:00:00	QQQ	ETF	34.61	34.66	34.61	34.66	659250.0
2009-07-10 07:30:00	QQQ	ETF	34.67	34.68	34.6	34.62	60579.0
2009-07-10 08:00:00	QQQ	ETF	34.61	34.65	34.6	34.62	697147.0
2009-07-10 08:30:00	QQQ	ETF	34.63	34.67	34.5	34.65	141463.0
2009-07-10 09:00:00	QQQ	ETF	34.65	34.7	34.62	34.67	546235.0
2009-07-10 09:30:00	QQQ	ETF	34.66	35.14	34.63	35.0	21947572.0
2009-07-10 10:00:00	QQQ	ETF	35.0	35.1	34.85	35.04	12486268.0
2009-07-10 10:30:00	QQQ	ETF	35.04	35.0499	34.87	34.94	6169904.0
2009-07-10 11:00:00	QQQ	ETF	34.95	34.95	34.59	34.639	8866984.0
2009-07-10 11:30:00	QQQ	ETF	34.6399	34.8	34.5626	34.75	7410809.0
2009-07-10 12:00:00	QQQ	ETF	34.74	34.84	34.65	34.8	4390415.0
2009-07-10 12:30:00	QQQ	ETF	34.8	34.9	34.76	34.84	3361879.0
2009-07-10 13:00:00	QQQ	ETF	34.84	34.91	34.819	34.819	3091057.0
2009-07-10 13:30:00	QQQ	ETF	34.82	34.98	34.8	34.92	6933070.0

> showing 50 of 6,927 rows — these rows as CSV

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