PREVIEW / etf_1hour / 2007-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-01.parquet
  size:    64 KB
  rows:    2,028

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-02-01 05:00:00	SPY	ETF	143.98	143.98	143.98	143.98	400.0
2007-02-01 06:00:00	SPY	ETF	144.07	144.07	144.05	144.05	6000.0
2007-02-01 07:00:00	SPY	ETF	143.99	144.03	143.92	144.03	120800.0
2007-02-01 08:00:00	SPY	ETF	144.01	144.25	143.8	144.23	1409800.0
2007-02-01 09:00:00	SPY	ETF	144.21	144.39	143.8	144.31	9724200.0
2007-02-01 10:00:00	SPY	ETF	144.31	144.41	144.02	144.2	18211300.0
2007-02-01 11:00:00	SPY	ETF	144.2	144.25	143.91	144.19	10989700.0
2007-02-01 12:00:00	SPY	ETF	144.19	144.25	144.09	144.18	5752900.0
2007-02-01 13:00:00	SPY	ETF	144.18	144.38	144.12	144.27	6463300.0
2007-02-01 14:00:00	SPY	ETF	144.27	144.49	144.2	144.47	4656800.0
2007-02-01 15:00:00	SPY	ETF	144.48	144.66	144.47	144.57	9245000.0
2007-02-01 16:00:00	SPY	ETF	144.57	144.62	144.5	144.59	1125000.0
2007-02-01 17:00:00	SPY	ETF	144.59	144.64	144.57	144.58	44400.0
2007-02-01 18:00:00	SPY	ETF	144.6	144.6	144.54	144.54	7400.0
2007-02-01 19:00:00	SPY	ETF	144.53	144.53	144.53	144.53	400.0
2007-02-01 05:00:00	QQQ	ETF	44.13	44.13	44.13	44.13	1000.0
2007-02-01 06:00:00	QQQ	ETF	44.18	44.18	44.18	44.18	25000.0
2007-02-01 07:00:00	QQQ	ETF	44.14	44.14	44.13	44.14	27100.0
2007-02-01 08:00:00	QQQ	ETF	44.16	44.28	44.14	44.27	1695722.0
2007-02-01 09:00:00	QQQ	ETF	44.27	44.4	44.2	44.33	27770922.0
2007-02-01 10:00:00	QQQ	ETF	44.33	44.39	44.1	44.14	34667500.0
2007-02-01 11:00:00	QQQ	ETF	44.14	44.15	43.85	44.01	25078100.0
2007-02-01 12:00:00	QQQ	ETF	44.01	44.08	43.95	43.95	10935000.0
2007-02-01 13:00:00	QQQ	ETF	43.95	44.02	43.87	43.95	12845800.0
2007-02-01 14:00:00	QQQ	ETF	43.96	44.03	43.88	44.02	10874000.0
2007-02-01 15:00:00	QQQ	ETF	44.02	44.15	44.0	44.0	18722200.0
2007-02-01 16:00:00	QQQ	ETF	44.01	44.08	44.0	44.05	2868660.0
2007-02-01 17:00:00	QQQ	ETF	44.05	44.07	44.02	44.07	61684.0
2007-02-01 18:00:00	QQQ	ETF	44.03	44.05	44.01	44.02	47900.0
2007-02-01 19:00:00	QQQ	ETF	44.02	44.07	44.02	44.07	11725.0
2007-02-01 08:00:00	IWM	ETF	79.35	79.64	79.31	79.6	176800.0
2007-02-01 09:00:00	IWM	ETF	79.69	80.14	79.63	80.07	12886700.0
2007-02-01 10:00:00	IWM	ETF	80.07	80.11	79.74	79.85	11723200.0
2007-02-01 11:00:00	IWM	ETF	79.85	79.88	79.54	79.82	7828100.0
2007-02-01 12:00:00	IWM	ETF	79.83	79.93	79.77	79.86	3248700.0
2007-02-01 13:00:00	IWM	ETF	79.86	79.98	79.7272	79.9	1927200.0
2007-02-01 14:00:00	IWM	ETF	79.92	80.04	79.82	80.04	2429000.0
2007-02-01 15:00:00	IWM	ETF	80.03	80.19	80.03	80.17	5875600.0
2007-02-01 16:00:00	IWM	ETF	80.17	80.24	80.06	80.19	528100.0
2007-02-01 17:00:00	IWM	ETF	78.0	78.0	78.0	78.0	40000.0
2007-02-01 18:00:00	IWM	ETF	80.15	80.19	80.14	80.14	34900.0
2007-02-01 07:00:00	DIA	ETF	126.2	126.5	126.2	126.45	900.0
2007-02-01 08:00:00	DIA	ETF	126.45	126.55	126.39	126.55	22200.0
2007-02-01 09:00:00	DIA	ETF	126.58	126.59	126.34	126.51	648100.0
2007-02-01 10:00:00	DIA	ETF	126.51	126.6	126.28	126.44	1339300.0
2007-02-01 11:00:00	DIA	ETF	126.44	126.45	126.17	126.35	1108800.0
2007-02-01 12:00:00	DIA	ETF	126.35	126.39	126.23	126.31	287100.0
2007-02-01 13:00:00	DIA	ETF	126.3	126.49	126.23	126.38	661000.0
2007-02-01 14:00:00	DIA	ETF	126.38	126.59	126.3	126.59	559000.0
2007-02-01 15:00:00	DIA	ETF	126.59	126.77	126.57	126.68	3725300.0

> showing 50 of 2,028 rows — these rows as CSV

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