PREVIEW / etf_1hour / 2001-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-12-27.parquet
  size:    13 KB
  rows:    282

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-12-27 09:00:00	SPY	ETF	115.3	115.73	115.25	115.68	1413900.0
2001-12-27 10:00:00	SPY	ETF	115.65	115.93	115.58	115.68	1920300.0
2001-12-27 11:00:00	SPY	ETF	115.69	115.86	115.63	115.8	746600.0
2001-12-27 12:00:00	SPY	ETF	115.77	115.88	115.66	115.81	729700.0
2001-12-27 13:00:00	SPY	ETF	115.82	115.82	115.53	115.64	1066500.0
2001-12-27 14:00:00	SPY	ETF	115.63	115.67	115.26	115.33	678900.0
2001-12-27 15:00:00	SPY	ETF	115.36	115.96	115.36	115.93	1383200.0
2001-12-27 16:00:00	SPY	ETF	115.87	116.08	115.87	115.91	1393300.0
2001-12-27 17:00:00	SPY	ETF	116.0	116.0	115.93	115.93	3100.0
2001-12-27 09:00:00	QQQ	ETF	39.85	40.17	39.77	40.1	6752800.0
2001-12-27 10:00:00	QQQ	ETF	40.14	40.2	39.95	40.05	6078100.0
2001-12-27 11:00:00	QQQ	ETF	40.03	40.18	40.01	40.1	3321600.0
2001-12-27 12:00:00	QQQ	ETF	40.12	40.14	39.98	40.0	2115900.0
2001-12-27 13:00:00	QQQ	ETF	40.01	40.02	39.76	39.85	3060500.0
2001-12-27 14:00:00	QQQ	ETF	39.84	39.87	39.6	39.67	4267800.0
2001-12-27 15:00:00	QQQ	ETF	39.68	40.02	39.66	39.95	7791100.0
2001-12-27 16:00:00	QQQ	ETF	39.97	40.05	39.93	40.02	798800.0
2001-12-27 17:00:00	QQQ	ETF	40.02	40.05	40.01	40.03	10200.0
2001-12-27 18:00:00	QQQ	ETF	40.04	40.05	40.01	40.05	9100.0
2001-12-27 09:00:00	IWM	ETF	48.75	49.0	48.75	48.985	114000.0
2001-12-27 10:00:00	IWM	ETF	49.0	49.045	48.87	48.885	186000.0
2001-12-27 11:00:00	IWM	ETF	48.87	48.95	48.8	48.91	234800.0
2001-12-27 12:00:00	IWM	ETF	48.91	48.985	48.835	48.95	147400.0
2001-12-27 13:00:00	IWM	ETF	48.935	48.94	48.8	48.815	210400.0
2001-12-27 14:00:00	IWM	ETF	48.82	48.89	48.785	48.81	263600.0
2001-12-27 15:00:00	IWM	ETF	48.815	49.075	48.73	48.95	494000.0
2001-12-27 16:00:00	IWM	ETF	49.0	49.0	48.925	48.95	52600.0
2001-12-27 09:00:00	DIA	ETF	101.12	101.39	100.9	101.38	215800.0
2001-12-27 10:00:00	DIA	ETF	101.37	101.55	101.17	101.24	169800.0
2001-12-27 11:00:00	DIA	ETF	101.23	101.48	101.22	101.37	172000.0
2001-12-27 12:00:00	DIA	ETF	101.32	101.38	101.2	101.32	286600.0
2001-12-27 13:00:00	DIA	ETF	101.29	101.38	101.1	101.15	338700.0
2001-12-27 14:00:00	DIA	ETF	101.14	101.24	100.89	101.02	256000.0
2001-12-27 15:00:00	DIA	ETF	101.04	101.43	100.96	101.39	321700.0
2001-12-27 16:00:00	DIA	ETF	101.39	101.49	101.3	101.49	88400.0

> showing 35 of 282 rows — these rows as CSV

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