PREVIEW / etf_1hour / 2007-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-19.parquet
  size:    95 KB
  rows:    3,176

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
2007-11-19 04:00:00	SPY	ETF	145.93	145.93	145.53	145.53	2000.0
2007-11-19 05:00:00	SPY	ETF	145.43	145.43	145.37	145.37	20100.0
2007-11-19 06:00:00	SPY	ETF	145.1	145.35	144.93	145.15	73900.0
2007-11-19 07:00:00	SPY	ETF	145.15	145.46	145.09	145.32	1037200.0
2007-11-19 08:00:00	SPY	ETF	145.3	145.3	145.0	145.17	1407800.0
2007-11-19 09:00:00	SPY	ETF	145.15	145.36	144.56	144.88	23112816.0
2007-11-19 10:00:00	SPY	ETF	144.88	145.14	144.02	144.09	46629649.0
2007-11-19 11:00:00	SPY	ETF	144.1	144.23	143.63	143.81	44109919.0
2007-11-19 12:00:00	SPY	ETF	143.82	145.155	143.67	143.85	20209285.0
2007-11-19 13:00:00	SPY	ETF	143.85	144.117	143.19	143.33	29647739.0
2007-11-19 14:00:00	SPY	ETF	143.3	144.61	143.26	144.04	40982934.0
2007-11-19 15:00:00	SPY	ETF	144.04	144.33	143.37	143.54	44391998.0
2007-11-19 16:00:00	SPY	ETF	143.54	146.0818	143.51	143.69	3892800.0
2007-11-19 17:00:00	SPY	ETF	146.0818	146.0818	143.45	143.78	3241100.0
2007-11-19 18:00:00	SPY	ETF	143.78	144.06	143.72	144.0	98100.0
2007-11-19 19:00:00	SPY	ETF	144.06	144.09	143.92	144.05	28900.0
2007-11-19 05:00:00	QQQ	ETF	50.27	50.27	50.19	50.19	30100.0
2007-11-19 06:00:00	QQQ	ETF	50.07	50.11	50.07	50.11	400.0
2007-11-19 07:00:00	QQQ	ETF	50.12	50.26	50.1	50.21	311152.0
2007-11-19 08:00:00	QQQ	ETF	50.22	50.23	50.05	50.17	1889906.0
2007-11-19 09:00:00	QQQ	ETF	50.17	50.45	50.0	50.26	21461016.0
2007-11-19 10:00:00	QQQ	ETF	50.2524	50.38	49.86	49.91	24082492.0
2007-11-19 11:00:00	QQQ	ETF	49.92	50.0	49.65	49.8	27517249.0
2007-11-19 12:00:00	QQQ	ETF	49.79	50.0001	49.66	49.725	14964974.0
2007-11-19 13:00:00	QQQ	ETF	49.73	49.83	49.44	49.49	22682381.0
2007-11-19 14:00:00	QQQ	ETF	49.49	50.16	49.41	49.87	29709342.0
2007-11-19 15:00:00	QQQ	ETF	49.87	50.02	49.57	49.71	40081975.0
2007-11-19 16:00:00	QQQ	ETF	49.72	49.9121	49.4239	49.85	16530390.0
2007-11-19 17:00:00	QQQ	ETF	49.85	49.91	49.7	49.82	2686614.0
2007-11-19 18:00:00	QQQ	ETF	49.83	49.96	49.7	49.95	2889059.0
2007-11-19 19:00:00	QQQ	ETF	49.94	49.94	49.88	49.92	14075.0
2007-11-19 07:00:00	IWM	ETF	75.68	75.9	75.68	75.78	19300.0
2007-11-19 08:00:00	IWM	ETF	75.82	75.82	75.64	75.68	239300.0
2007-11-19 09:00:00	IWM	ETF	75.65	76.04	75.42	75.42	14184569.0
2007-11-19 10:00:00	IWM	ETF	75.43	75.66	74.8	74.85	18363800.0
2007-11-19 11:00:00	IWM	ETF	74.84	75.0	74.5	74.79	16795247.0
2007-11-19 12:00:00	IWM	ETF	74.79	75.13	74.65	74.74	9482817.0
2007-11-19 13:00:00	IWM	ETF	74.75	74.83	74.32	74.43	12123645.0
2007-11-19 14:00:00	IWM	ETF	74.43	75.41	74.41	75.02	13526480.0
2007-11-19 15:00:00	IWM	ETF	75.01	75.5	74.66	74.66	18865730.0
2007-11-19 16:00:00	IWM	ETF	74.68	76.68	74.6	74.71	7216500.0
2007-11-19 17:00:00	IWM	ETF	76.68	76.68	74.64	74.64	2019300.0
2007-11-19 18:00:00	IWM	ETF	74.77	74.9	74.74	74.9	3352200.0
2007-11-19 07:00:00	DIA	ETF	131.08	131.2	130.95	131.19	30100.0
2007-11-19 08:00:00	DIA	ETF	131.07	131.07	130.91	131.03	13500.0
2007-11-19 09:00:00	DIA	ETF	131.0	131.14	130.6	130.78	1614486.0
2007-11-19 10:00:00	DIA	ETF	130.78	130.94	130.07	130.14	3015203.0
2007-11-19 11:00:00	DIA	ETF	130.13	130.25	129.75	129.91	3748465.0
2007-11-19 12:00:00	DIA	ETF	129.91	130.32	129.77	129.87	1568800.0
2007-11-19 13:00:00	DIA	ETF	129.87	130.03	129.42	129.52	3663515.0

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

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