PREVIEW / etf_1hour / 2002-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-03-14.parquet
  size:    13 KB
  rows:    293

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
2002-03-14 09:00:00	SPY	ETF	116.04	116.29	115.85	116.01	1449000.0
2002-03-14 10:00:00	SPY	ETF	115.97	116.28	115.67	116.2	2581200.0
2002-03-14 11:00:00	SPY	ETF	116.22	116.43	116.11	116.3	1618100.0
2002-03-14 12:00:00	SPY	ETF	116.3	116.32	116.06	116.25	466700.0
2002-03-14 13:00:00	SPY	ETF	116.3	116.3	115.86	115.94	764500.0
2002-03-14 14:00:00	SPY	ETF	115.95	116.09	115.63	116.04	1233000.0
2002-03-14 15:00:00	SPY	ETF	116.05	116.17	115.75	115.86	1897200.0
2002-03-14 16:00:00	SPY	ETF	115.86	115.93	115.8	115.92	866700.0
2002-03-14 17:00:00	SPY	ETF	115.84	115.85	115.8	115.8	1500.0
2002-03-14 09:00:00	QQQ	ETF	37.06	37.33	37.0	37.11	10738100.0
2002-03-14 10:00:00	QQQ	ETF	37.1	37.33	36.82	37.28	13615100.0
2002-03-14 11:00:00	QQQ	ETF	37.25	37.4	37.17	37.3	8479300.0
2002-03-14 12:00:00	QQQ	ETF	37.31	37.33	37.06	37.22	2953000.0
2002-03-14 13:00:00	QQQ	ETF	37.21	37.23	36.9	36.98	5222400.0
2002-03-14 14:00:00	QQQ	ETF	36.99	37.02	36.72	36.97	14101700.0
2002-03-14 15:00:00	QQQ	ETF	37.0	37.09	36.75	36.81	11150600.0
2002-03-14 16:00:00	QQQ	ETF	36.82	36.98	36.75	36.85	1884600.0
2002-03-14 17:00:00	QQQ	ETF	36.83	36.89	36.65	36.66	443300.0
2002-03-14 18:00:00	QQQ	ETF	36.67	36.71	36.66	36.7	42600.0
2002-03-14 09:00:00	IWM	ETF	49.375	49.42	49.23	49.285	38200.0
2002-03-14 10:00:00	IWM	ETF	49.285	49.465	48.755	49.465	436200.0
2002-03-14 11:00:00	IWM	ETF	49.49	49.615	49.425	49.615	115000.0
2002-03-14 12:00:00	IWM	ETF	49.545	49.615	49.465	49.56	206000.0
2002-03-14 13:00:00	IWM	ETF	49.485	49.56	49.385	49.385	74600.0
2002-03-14 14:00:00	IWM	ETF	49.385	49.49	49.285	49.49	332800.0
2002-03-14 15:00:00	IWM	ETF	49.51	49.51	49.345	49.445	95800.0
2002-03-14 16:00:00	IWM	ETF	49.935	49.935	49.425	49.685	82200.0
2002-03-14 09:00:00	DIA	ETF	105.33	105.64	104.98	105.17	768100.0
2002-03-14 10:00:00	DIA	ETF	105.18	105.58	104.96	105.57	1216300.0
2002-03-14 11:00:00	DIA	ETF	105.57	105.79	105.48	105.73	570100.0
2002-03-14 12:00:00	DIA	ETF	105.67	105.75	105.46	105.74	1233600.0
2002-03-14 13:00:00	DIA	ETF	105.73	105.76	105.29	105.38	285600.0
2002-03-14 14:00:00	DIA	ETF	105.36	105.71	105.18	105.71	347100.0
2002-03-14 15:00:00	DIA	ETF	105.67	105.71	105.28	105.43	648200.0
2002-03-14 16:00:00	DIA	ETF	105.35	105.46	105.32	105.41	280300.0
2002-03-14 17:00:00	DIA	ETF	105.0	105.1	105.0	105.1	2000.0

> showing 36 of 293 rows — these rows as CSV

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