PREVIEW / etf_1hour / 2001-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-06-27.parquet
  size:    12 KB
  rows:    237

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-06-27 09:00:00	SPY	ETF	121.6	121.88	121.38	121.71	669400.0
2001-06-27 10:00:00	SPY	ETF	121.7	122.24	121.6	122.07	859900.0
2001-06-27 11:00:00	SPY	ETF	122.07	122.23	121.98	122.09	664200.0
2001-06-27 12:00:00	SPY	ETF	122.07	122.19	121.95	122.05	421100.0
2001-06-27 13:00:00	SPY	ETF	122.04	122.19	121.85	121.94	1063800.0
2001-06-27 14:00:00	SPY	ETF	121.9	122.06	120.91	121.93	3325600.0
2001-06-27 15:00:00	SPY	ETF	121.99	122.22	121.34	121.35	2332100.0
2001-06-27 16:00:00	SPY	ETF	121.31	122.42	120.54	121.48	521700.0
2001-06-27 17:00:00	SPY	ETF	121.43	121.43	121.43	121.43	200.0
2001-06-27 09:00:00	QQQ	ETF	43.68	43.8	43.3	43.56	5137400.0
2001-06-27 10:00:00	QQQ	ETF	43.56	43.82	43.41	43.68	5004700.0
2001-06-27 11:00:00	QQQ	ETF	43.7	44.13	43.66	43.96	4224300.0
2001-06-27 12:00:00	QQQ	ETF	43.96	44.06	43.85	43.97	2097300.0
2001-06-27 13:00:00	QQQ	ETF	43.93	44.02	43.7	43.75	3843300.0
2001-06-27 14:00:00	QQQ	ETF	43.75	44.0	43.0	43.77	17852500.0
2001-06-27 15:00:00	QQQ	ETF	43.77	44.15	43.66	43.75	11831100.0
2001-06-27 16:00:00	QQQ	ETF	43.73	43.89	43.35	43.79	1011900.0
2001-06-27 17:00:00	QQQ	ETF	43.83	43.95	43.77	43.9	203400.0
2001-06-27 18:00:00	QQQ	ETF	43.94	43.94	43.65	43.8	4800.0
2001-06-27 09:00:00	IWM	ETF	49.1	49.15	48.95	48.95	367800.0
2001-06-27 10:00:00	IWM	ETF	49.07	49.36	49.05	49.295	64600.0
2001-06-27 11:00:00	IWM	ETF	49.275	49.35	49.25	49.35	57400.0
2001-06-27 12:00:00	IWM	ETF	49.375	49.525	49.3	49.47	109400.0
2001-06-27 13:00:00	IWM	ETF	49.49	49.6	49.35	49.37	55800.0
2001-06-27 14:00:00	IWM	ETF	49.305	49.45	48.965	49.45	144000.0
2001-06-27 15:00:00	IWM	ETF	49.29	49.53	49.225	49.375	120400.0
2001-06-27 16:00:00	IWM	ETF	49.525	49.525	49.1	49.475	43800.0
2001-06-27 09:00:00	DIA	ETF	104.88	105.18	104.74	105.18	110200.0
2001-06-27 10:00:00	DIA	ETF	105.05	105.37	105.03	105.19	233600.0
2001-06-27 11:00:00	DIA	ETF	105.28	105.4	105.15	105.25	138700.0
2001-06-27 12:00:00	DIA	ETF	105.26	105.4	105.15	105.32	51200.0
2001-06-27 13:00:00	DIA	ETF	105.38	105.38	104.9	105.07	119100.0
2001-06-27 14:00:00	DIA	ETF	105.0	105.25	104.06	105.0	729000.0
2001-06-27 15:00:00	DIA	ETF	104.96	105.15	104.38	104.52	389700.0
2001-06-27 16:00:00	DIA	ETF	104.57	105.35	104.42	104.5	28000.0

> showing 35 of 237 rows — these rows as CSV

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