PREVIEW / etf_1hour / 2008-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-18.parquet
  size:    111 KB
  rows:    3,536

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-07-18 04:00:00	SPY	ETF	124.75	124.75	124.75	124.75	500.0
2008-07-18 05:00:00	SPY	ETF	124.37	124.6	124.37	124.5	25500.0
2008-07-18 06:00:00	SPY	ETF	124.68	125.79	124.62	125.63	797800.0
2008-07-18 07:00:00	SPY	ETF	125.58	126.08	125.52	125.87	3835088.0
2008-07-18 08:00:00	SPY	ETF	125.86	126.19	125.26	126.13	5141972.0
2008-07-18 09:00:00	SPY	ETF	126.14	126.39	125.24	125.41	45156434.0
2008-07-18 10:00:00	SPY	ETF	125.42	126.4159	125.22	125.85	51886960.0
2008-07-18 11:00:00	SPY	ETF	125.86	126.29	125.5	125.71	33996552.0
2008-07-18 12:00:00	SPY	ETF	125.72	126.0	125.21	125.29	23682279.0
2008-07-18 13:00:00	SPY	ETF	125.3	125.84	125.15	125.62	22464618.0
2008-07-18 14:00:00	SPY	ETF	125.63	125.96	125.35	125.4902	20778006.0
2008-07-18 15:00:00	SPY	ETF	125.49	126.14	125.4	125.92	32605781.0
2008-07-18 16:00:00	SPY	ETF	125.82	126.08	125.42	125.99	19811867.0
2008-07-18 17:00:00	SPY	ETF	125.99	126.03	125.95	126.0	1110513.0
2008-07-18 18:00:00	SPY	ETF	126.0	126.07	126.0	126.0	43546.0
2008-07-18 19:00:00	SPY	ETF	126.0	126.06	126.0	126.04	8851.0
2008-07-18 04:00:00	QQQ	ETF	44.87	44.87	44.84	44.85	2000.0
2008-07-18 05:00:00	QQQ	ETF	44.77	44.79	44.76	44.76	1000.0
2008-07-18 06:00:00	QQQ	ETF	44.98	45.13	44.97	45.13	5900.0
2008-07-18 07:00:00	QQQ	ETF	45.11	45.23	45.08	45.14	672439.0
2008-07-18 08:00:00	QQQ	ETF	45.13	45.34	45.06	45.17	6017745.0
2008-07-18 09:00:00	QQQ	ETF	45.18	45.23	44.72	44.8	26610214.0
2008-07-18 10:00:00	QQQ	ETF	44.8	44.98	44.67	44.84	28520750.0
2008-07-18 11:00:00	QQQ	ETF	44.84	45.15	44.81	45.01	21644254.0
2008-07-18 12:00:00	QQQ	ETF	45.02	45.05	44.68	44.7	17675340.0
2008-07-18 13:00:00	QQQ	ETF	44.71	44.9	44.69	44.76	13311240.0
2008-07-18 14:00:00	QQQ	ETF	44.7603	44.88	44.71	44.8001	12177620.0
2008-07-18 15:00:00	QQQ	ETF	44.81	44.96	44.76	44.82	20555110.0
2008-07-18 16:00:00	QQQ	ETF	44.82	44.87	44.59	44.84	8887868.0
2008-07-18 17:00:00	QQQ	ETF	44.81	44.86	44.8	44.86	19270.0
2008-07-18 18:00:00	QQQ	ETF	44.85	44.85	44.81	44.82	13135.0
2008-07-18 19:00:00	QQQ	ETF	44.82	44.85	44.8	44.8	8520.0
2008-07-18 06:00:00	IWM	ETF	69.01	69.45	69.01	69.42	349900.0
2008-07-18 07:00:00	IWM	ETF	69.4	69.72	69.35	69.61	738965.0
2008-07-18 08:00:00	IWM	ETF	69.4	69.71	69.2	69.63	1733811.0
2008-07-18 09:00:00	IWM	ETF	69.65	69.88	68.9	69.04	11627086.0
2008-07-18 10:00:00	IWM	ETF	69.04	69.38	68.82	69.17	16128555.0
2008-07-18 11:00:00	IWM	ETF	69.18	69.58	69.15	69.26	7031476.0
2008-07-18 12:00:00	IWM	ETF	69.26	69.42	68.53	68.65	13973000.0
2008-07-18 13:00:00	IWM	ETF	68.65	69.09	68.64	68.87	9745739.0
2008-07-18 14:00:00	IWM	ETF	68.87	69.21	68.76	68.9	6487759.0
2008-07-18 15:00:00	IWM	ETF	68.9	69.25	68.85	69.01	10323721.0
2008-07-18 16:00:00	IWM	ETF	69.02	69.46	68.65	69.0	12566363.0
2008-07-18 17:00:00	IWM	ETF	69.0	69.0	69.0	69.0	1000.0
2008-07-18 05:00:00	DIA	ETF	113.6	113.6	113.6	113.6	100.0
2008-07-18 07:00:00	DIA	ETF	114.25	114.51	114.25	114.43	15738.0
2008-07-18 08:00:00	DIA	ETF	114.4	114.66	114.33	114.58	120604.0
2008-07-18 09:00:00	DIA	ETF	114.6	114.69	113.7	113.88	2703520.0
2008-07-18 10:00:00	DIA	ETF	113.86	114.59	113.72	114.4	3699745.0
2008-07-18 11:00:00	DIA	ETF	114.41	115.03	114.3	114.5	2857201.0

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

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