PREVIEW / etf_1hour / 2001-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-07-05.parquet
  size:    12 KB
  rows:    240

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
2001-07-05 09:00:00	SPY	ETF	123.07	123.39	122.93	123.01	1002200.0
2001-07-05 10:00:00	SPY	ETF	123.02	123.65	122.87	123.02	956900.0
2001-07-05 11:00:00	SPY	ETF	123.05	123.17	122.27	122.29	846900.0
2001-07-05 12:00:00	SPY	ETF	122.37	122.69	122.3	122.59	284000.0
2001-07-05 13:00:00	SPY	ETF	122.53	122.53	122.25	122.32	238000.0
2001-07-05 14:00:00	SPY	ETF	122.39	122.73	122.39	122.47	329000.0
2001-07-05 15:00:00	SPY	ETF	122.53	122.6	122.11	122.13	964500.0
2001-07-05 16:00:00	SPY	ETF	122.13	122.37	121.66	122.37	723800.0
2001-07-05 17:00:00	SPY	ETF	121.7	122.37	120.51	121.0	11700.0
2001-07-05 18:00:00	SPY	ETF	121.12	121.3	120.3	121.3	3100.0
2001-07-05 09:00:00	QQQ	ETF	44.87	45.1	44.72	44.72	6577600.0
2001-07-05 10:00:00	QQQ	ETF	44.74	45.18	44.63	44.73	8745000.0
2001-07-05 11:00:00	QQQ	ETF	44.72	44.84	44.15	44.19	6490600.0
2001-07-05 12:00:00	QQQ	ETF	44.18	44.38	44.13	44.27	3516700.0
2001-07-05 13:00:00	QQQ	ETF	44.26	44.3	43.95	44.03	4106900.0
2001-07-05 14:00:00	QQQ	ETF	44.07	44.24	44.01	44.07	3107400.0
2001-07-05 15:00:00	QQQ	ETF	44.07	44.15	43.65	43.66	7008000.0
2001-07-05 16:00:00	QQQ	ETF	43.66	43.72	43.14	43.4	2832600.0
2001-07-05 17:00:00	QQQ	ETF	43.4	43.4	42.65	42.69	408100.0
2001-07-05 18:00:00	QQQ	ETF	42.77	42.8	42.69	42.75	31000.0
2001-07-05 09:00:00	IWM	ETF	49.0	49.25	49.0	49.175	126600.0
2001-07-05 10:00:00	IWM	ETF	49.14	49.495	49.14	49.265	123000.0
2001-07-05 11:00:00	IWM	ETF	49.335	49.35	49.15	49.23	286200.0
2001-07-05 12:00:00	IWM	ETF	49.15	49.3	49.15	49.26	41400.0
2001-07-05 13:00:00	IWM	ETF	49.205	49.29	49.185	49.245	55000.0
2001-07-05 14:00:00	IWM	ETF	49.25	49.34	49.225	49.25	135600.0
2001-07-05 15:00:00	IWM	ETF	49.2	49.225	48.83	48.975	54200.0
2001-07-05 16:00:00	IWM	ETF	48.775	48.85	48.775	48.85	1600.0
2001-07-05 17:00:00	IWM	ETF	49.165	49.165	49.165	49.165	1000.0
2001-07-05 09:00:00	DIA	ETF	105.25	105.5	105.2	105.2	106800.0
2001-07-05 10:00:00	DIA	ETF	105.2	105.74	105.14	105.4	207000.0
2001-07-05 11:00:00	DIA	ETF	105.41	105.48	104.75	104.84	329100.0
2001-07-05 12:00:00	DIA	ETF	104.85	105.15	104.77	105.05	46100.0
2001-07-05 13:00:00	DIA	ETF	105.0	105.0	104.78	104.91	64300.0
2001-07-05 14:00:00	DIA	ETF	104.92	105.13	104.9	104.9	74300.0
2001-07-05 15:00:00	DIA	ETF	104.95	105.09	104.76	104.8	138100.0
2001-07-05 16:00:00	DIA	ETF	104.82	104.82	104.6	104.66	86300.0
2001-07-05 17:00:00	DIA	ETF	104.5	104.5	104.33	104.33	500.0

> showing 38 of 240 rows — these rows as CSV

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