PREVIEW / etf_1hour / 2010-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-22.parquet
  size:    165 KB
  rows:    4,961

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-04-22 04:00:00	SPY	ETF	120.73	120.86	120.7	120.75	9100.0
2010-04-22 05:00:00	SPY	ETF	120.66	120.66	119.95	120.07	15766.0
2010-04-22 06:00:00	SPY	ETF	119.93	120.08	119.73	119.89	159600.0
2010-04-22 07:00:00	SPY	ETF	119.89	120.02	119.76	119.98	437093.0
2010-04-22 08:00:00	SPY	ETF	119.98	120.06	119.83	119.86	2509384.0
2010-04-22 09:00:00	SPY	ETF	119.86	120.19	119.13	119.46	35423371.0
2010-04-22 10:00:00	SPY	ETF	119.46	120.01	119.32	119.78	54764930.0
2010-04-22 11:00:00	SPY	ETF	119.78	119.91	119.42	119.65	26205649.0
2010-04-22 12:00:00	SPY	ETF	119.65	119.94	119.56	119.87	17827629.0
2010-04-22 13:00:00	SPY	ETF	119.87	120.63	119.12	120.62	31409669.0
2010-04-22 14:00:00	SPY	ETF	120.63	120.83	120.45	120.65	22599755.0
2010-04-22 15:00:00	SPY	ETF	120.64	121.17	120.58	121.0	33347417.0
2010-04-22 16:00:00	SPY	ETF	121.0	121.05	119.4	120.74	13059211.0
2010-04-22 17:00:00	SPY	ETF	120.75	121.02	120.67	120.7	198915.0
2010-04-22 18:00:00	SPY	ETF	120.72	120.73	120.59	120.62	47189.0
2010-04-22 19:00:00	SPY	ETF	120.65	120.65	120.57	120.57	36503.0
2010-04-22 04:00:00	QQQ	ETF	49.95	49.95	49.95	49.95	100.0
2010-04-22 05:00:00	QQQ	ETF	49.76	49.76	49.74	49.74	1500.0
2010-04-22 06:00:00	QQQ	ETF	49.67	49.67	49.54	49.54	13139.0
2010-04-22 07:00:00	QQQ	ETF	49.57	49.62	49.55	49.6	450471.0
2010-04-22 08:00:00	QQQ	ETF	49.75	49.75	49.5	49.56	4253133.0
2010-04-22 09:00:00	QQQ	ETF	49.56	49.59	49.26	49.439	16089507.0
2010-04-22 10:00:00	QQQ	ETF	49.44	49.82	49.41	49.71	23286398.0
2010-04-22 11:00:00	QQQ	ETF	49.71	49.75	49.49	49.53	9793701.0
2010-04-22 12:00:00	QQQ	ETF	49.535	49.72	49.5	49.679	9896949.0
2010-04-22 13:00:00	QQQ	ETF	49.67	50.084	49.6575	50.08	11447692.0
2010-04-22 14:00:00	QQQ	ETF	50.085	50.21	50.01	50.1	9246645.0
2010-04-22 15:00:00	QQQ	ETF	50.1	50.36	50.091	50.29	15005098.0
2010-04-22 16:00:00	QQQ	ETF	50.3	50.32	49.66	50.08	7747915.0
2010-04-22 17:00:00	QQQ	ETF	50.07	50.13	50.06	50.09	206220.0
2010-04-22 18:00:00	QQQ	ETF	50.08	50.3	50.06	50.07	74731.0
2010-04-22 19:00:00	QQQ	ETF	50.08	50.08	50.05	50.05	41056.0
2010-04-22 04:00:00	IWM	ETF	72.4	72.4	72.4	72.4	100.0
2010-04-22 05:00:00	IWM	ETF	72.34	72.34	72.34	72.34	100.0
2010-04-22 06:00:00	IWM	ETF	72.08	72.1	72.01	72.01	16700.0
2010-04-22 07:00:00	IWM	ETF	72.0	72.02	71.92	72.0	62312.0
2010-04-22 08:00:00	IWM	ETF	71.99	72.25	71.82	71.92	360195.0
2010-04-22 09:00:00	IWM	ETF	71.92	71.95	71.46	71.92	9785630.0
2010-04-22 10:00:00	IWM	ETF	71.92	72.42	71.85	72.18	14786940.0
2010-04-22 11:00:00	IWM	ETF	72.19	72.35	72.12	72.24	6989968.0
2010-04-22 12:00:00	IWM	ETF	72.23	72.7	72.155	72.6375	8600874.0
2010-04-22 13:00:00	IWM	ETF	72.635	73.1	72.59	73.1	9395074.0
2010-04-22 14:00:00	IWM	ETF	73.1	73.25	72.91	73.05	7172553.0
2010-04-22 15:00:00	IWM	ETF	73.05	73.49	72.9	73.37	14662358.0
2010-04-22 16:00:00	IWM	ETF	73.37	73.4771	72.6181	73.12	5411703.0
2010-04-22 17:00:00	IWM	ETF	73.11	73.15	73.04	73.15	44366.0
2010-04-22 18:00:00	IWM	ETF	73.15	73.15	73.03	73.1	12144.0
2010-04-22 19:00:00	IWM	ETF	73.1	73.1	73.01	73.02	2400.0
2010-04-22 05:00:00	DIA	ETF	111.0	111.0	111.0	111.0	500.0
2010-04-22 07:00:00	DIA	ETF	110.77	110.84	110.75	110.82	2200.0

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

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