PREVIEW / etf_1hour / 2010-03-25

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-25.parquet
  size:    163 KB
  rows:    4,997

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
2010-03-25 04:00:00	SPY	ETF	117.09	117.09	117.09	117.09	100.0
2010-03-25 05:00:00	SPY	ETF	117.11	117.31	117.11	117.29	10117.0
2010-03-25 06:00:00	SPY	ETF	117.31	117.36	117.3	117.3	650.0
2010-03-25 07:00:00	SPY	ETF	117.29	117.5	117.29	117.46	356640.0
2010-03-25 08:00:00	SPY	ETF	117.45	117.52	117.2	117.47	3175215.0
2010-03-25 09:00:00	SPY	ETF	117.48	117.73	117.39	117.48	22017751.0
2010-03-25 10:00:00	SPY	ETF	117.48	117.65	117.24	117.535	27550002.0
2010-03-25 11:00:00	SPY	ETF	117.53	118.04	117.53	117.9699	27128723.0
2010-03-25 12:00:00	SPY	ETF	117.97	118.1666	117.77	117.9701	19063944.0
2010-03-25 13:00:00	SPY	ETF	117.97	118.06	116.7812	117.48	31917256.0
2010-03-25 14:00:00	SPY	ETF	117.47	117.6	117.05	117.27	28471274.0
2010-03-25 15:00:00	SPY	ETF	117.28	117.56	116.51	116.64	50863210.0
2010-03-25 16:00:00	SPY	ETF	116.63	117.92	116.46	116.53	11648896.0
2010-03-25 17:00:00	SPY	ETF	116.53	116.5797	116.4	116.45	946428.0
2010-03-25 18:00:00	SPY	ETF	116.48	116.53	116.43	116.43	104461.0
2010-03-25 19:00:00	SPY	ETF	116.46	116.49	116.29	116.45	104569.0
2010-03-25 04:00:00	QQQ	ETF	48.13	48.13	48.13	48.13	211.0
2010-03-25 05:00:00	QQQ	ETF	48.19	48.19	48.19	48.19	300.0
2010-03-25 06:00:00	QQQ	ETF	48.22	48.22	48.2	48.2	950.0
2010-03-25 07:00:00	QQQ	ETF	48.22	48.26	48.22	48.23	40683.0
2010-03-25 08:00:00	QQQ	ETF	48.24	48.28	48.22	48.27	638304.0
2010-03-25 09:00:00	QQQ	ETF	48.27	48.45	48.27	48.329	11989763.0
2010-03-25 10:00:00	QQQ	ETF	48.3299	48.43	48.2	48.35	10629392.0
2010-03-25 11:00:00	QQQ	ETF	48.35	48.6	48.34	48.551	10274822.0
2010-03-25 12:00:00	QQQ	ETF	48.5599	48.56	48.43	48.4705	4318449.0
2010-03-25 13:00:00	QQQ	ETF	48.4785	48.54	48.27	48.31	7919224.0
2010-03-25 14:00:00	QQQ	ETF	48.3119	48.35	48.08	48.18	9268835.0
2010-03-25 15:00:00	QQQ	ETF	48.1701	48.34	47.9	47.94	13708001.0
2010-03-25 16:00:00	QQQ	ETF	47.93	48.35	47.9	47.92	5846569.0
2010-03-25 17:00:00	QQQ	ETF	47.92	47.92	47.87	47.89	77769.0
2010-03-25 18:00:00	QQQ	ETF	47.9	47.92	47.88	47.89	16300.0
2010-03-25 19:00:00	QQQ	ETF	47.9	47.9	47.84	47.87	46433.0
2010-03-25 07:00:00	IWM	ETF	68.7	68.8	68.7	68.75	72500.0
2010-03-25 08:00:00	IWM	ETF	68.75	68.82	68.33	68.75	267081.0
2010-03-25 09:00:00	IWM	ETF	68.74	68.98	68.58	68.775	6675932.0
2010-03-25 10:00:00	IWM	ETF	68.77	68.83	68.5	68.72	5631917.0
2010-03-25 11:00:00	IWM	ETF	68.72	69.34	68.71	69.23	9083997.0
2010-03-25 12:00:00	IWM	ETF	69.221	69.36	69.04	69.24	5480735.0
2010-03-25 13:00:00	IWM	ETF	69.24	69.33	68.8	68.86	9358830.0
2010-03-25 14:00:00	IWM	ETF	68.87	68.93	68.45	68.52	8433766.0
2010-03-25 15:00:00	IWM	ETF	68.52	68.81	67.79	67.84	16565530.0
2010-03-25 16:00:00	IWM	ETF	67.84	69.22	67.8	67.82	1899090.0
2010-03-25 17:00:00	IWM	ETF	67.8	67.84	67.74	67.74	16469.0
2010-03-25 18:00:00	IWM	ETF	67.77	67.85	67.72	67.74	7704.0
2010-03-25 19:00:00	IWM	ETF	67.73	67.79	67.67	67.74	10700.0
2010-03-25 07:00:00	DIA	ETF	108.77	108.88	108.77	108.88	5600.0
2010-03-25 08:00:00	DIA	ETF	108.84	108.9	108.73	108.82	29650.0
2010-03-25 09:00:00	DIA	ETF	108.9	109.08	108.86	109.0	1142199.0
2010-03-25 10:00:00	DIA	ETF	109.0	109.13	108.8	108.9795	1453943.0
2010-03-25 11:00:00	DIA	ETF	108.98	109.39	108.97	109.321	1496125.0

> showing 50 of 4,997 rows — these rows as CSV

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