PREVIEW / etf_1hour / 2008-09-24

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-24.parquet
  size:    110 KB
  rows:    3,564

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
2008-09-24 05:00:00	SPY	ETF	120.0	120.0	120.0	120.0	3500.0
2008-09-24 06:00:00	SPY	ETF	119.8	119.8	119.0	119.5	35800.0
2008-09-24 07:00:00	SPY	ETF	119.5	119.87	118.8	119.45	1078622.0
2008-09-24 08:00:00	SPY	ETF	119.46	120.5	119.11	119.69	7487531.0
2008-09-24 09:00:00	SPY	ETF	119.67	120.244	118.3	118.83	37161484.0
2008-09-24 10:00:00	SPY	ETF	118.82	119.31	118.08	119.281	47512190.0
2008-09-24 11:00:00	SPY	ETF	119.28	119.32	118.16	118.75	35414287.0
2008-09-24 12:00:00	SPY	ETF	118.75	118.97	118.21	118.57	27090088.0
2008-09-24 13:00:00	SPY	ETF	118.57	120.0	118.48	118.96	39414330.0
2008-09-24 14:00:00	SPY	ETF	118.96	119.52	118.5	118.76	35640300.0
2008-09-24 15:00:00	SPY	ETF	118.77	119.1	117.79	118.84	56044708.0
2008-09-24 16:00:00	SPY	ETF	118.8	119.05	118.2244	118.99	13747257.0
2008-09-24 17:00:00	SPY	ETF	118.99	118.99	118.5	118.6	5208382.0
2008-09-24 18:00:00	SPY	ETF	118.58	118.83	118.58	118.8	189582.0
2008-09-24 19:00:00	SPY	ETF	118.81	118.98	118.57	118.65	32018.0
2008-09-24 05:00:00	QQQ	ETF	40.99	40.99	40.99	40.99	100.0
2008-09-24 06:00:00	QQQ	ETF	40.9	40.9	40.9	40.9	900.0
2008-09-24 07:00:00	QQQ	ETF	40.93	40.95	40.65	40.83	91710.0
2008-09-24 08:00:00	QQQ	ETF	40.83	41.11	40.77	41.0	5192612.0
2008-09-24 09:00:00	QQQ	ETF	41.0	41.15	40.55	40.78	24219733.0
2008-09-24 10:00:00	QQQ	ETF	40.77	41.09	40.52	41.07	23801504.0
2008-09-24 11:00:00	QQQ	ETF	41.07	41.09	40.66	40.88	15974499.0
2008-09-24 12:00:00	QQQ	ETF	40.8784	41.0	40.7	40.81	11872324.0
2008-09-24 13:00:00	QQQ	ETF	40.81	41.26	40.76	41.03	14793873.0
2008-09-24 14:00:00	QQQ	ETF	41.03	41.26	40.89	40.96	13713973.0
2008-09-24 15:00:00	QQQ	ETF	40.96	41.17	40.53	40.91	24349106.0
2008-09-24 16:00:00	QQQ	ETF	40.95	41.07	40.774	41.0	3652907.0
2008-09-24 17:00:00	QQQ	ETF	41.0	41.01	40.85	40.93	14061875.0
2008-09-24 18:00:00	QQQ	ETF	40.93	40.96	40.91	40.95	57074.0
2008-09-24 19:00:00	QQQ	ETF	40.97	41.01	40.89	40.89	16300.0
2008-09-24 07:00:00	IWM	ETF	71.27	71.27	70.9	70.96	6160.0
2008-09-24 08:00:00	IWM	ETF	71.05	71.41	70.85	71.14	237720.0
2008-09-24 09:00:00	IWM	ETF	71.13	72.28	70.1	70.49	9248341.0
2008-09-24 10:00:00	IWM	ETF	70.48	70.95	70.05	70.88	15133531.0
2008-09-24 11:00:00	IWM	ETF	70.88	70.94	69.87	70.19	7307414.0
2008-09-24 12:00:00	IWM	ETF	70.19	70.47	69.95	70.14	6773367.0
2008-09-24 13:00:00	IWM	ETF	70.15	70.67	70.12	70.42	8748863.0
2008-09-24 14:00:00	IWM	ETF	70.42	70.62	70.11	70.27	7788681.0
2008-09-24 15:00:00	IWM	ETF	70.25	70.73	68.9	69.86	23742310.0
2008-09-24 16:00:00	IWM	ETF	69.85	70.73	69.68	70.0	4129659.0
2008-09-24 17:00:00	IWM	ETF	70.0	70.73	69.83	69.9	4795304.0
2008-09-24 18:00:00	IWM	ETF	69.9	70.0	69.9	70.0	1931.0
2008-09-24 19:00:00	IWM	ETF	70.05	70.1	69.86	69.86	5609.0
2008-09-24 07:00:00	DIA	ETF	109.03	109.6	109.02	109.05	2800.0
2008-09-24 08:00:00	DIA	ETF	109.24	109.69	109.06	109.39	69536.0
2008-09-24 09:00:00	DIA	ETF	109.36	109.45	108.27	108.68	2814649.0
2008-09-24 10:00:00	DIA	ETF	108.67	108.88	107.99	108.81	3234369.0
2008-09-24 11:00:00	DIA	ETF	108.8	108.85	107.89	108.48	2923392.0
2008-09-24 12:00:00	DIA	ETF	108.48	108.64	108.05	108.31	1454244.0
2008-09-24 13:00:00	DIA	ETF	108.31	109.23	108.24	108.58	2348372.0

> showing 50 of 3,564 rows — these rows as CSV

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