PREVIEW / etf_1hour / 2002-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-01-16.parquet
  size:    14 KB
  rows:    301

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-01-16 09:00:00	SPY	ETF	114.3	114.33	113.78	114.18	3118700.0
2002-01-16 10:00:00	SPY	ETF	114.18	114.4	113.9	113.98	1736000.0
2002-01-16 11:00:00	SPY	ETF	113.95	114.03	113.55	113.92	1709900.0
2002-01-16 12:00:00	SPY	ETF	113.92	114.0	113.72	113.91	1274100.0
2002-01-16 13:00:00	SPY	ETF	113.88	113.98	113.68	113.77	1088900.0
2002-01-16 14:00:00	SPY	ETF	113.73	114.27	113.6	114.11	2610100.0
2002-01-16 15:00:00	SPY	ETF	114.13	114.3	113.0	113.05	3026100.0
2002-01-16 16:00:00	SPY	ETF	113.12	113.25	112.69	112.93	1413000.0
2002-01-16 17:00:00	SPY	ETF	113.3	113.3	112.95	113.05	136900.0
2002-01-16 18:00:00	SPY	ETF	113.04	113.1	113.04	113.05	4500.0
2002-01-16 09:00:00	QQQ	ETF	39.53	39.71	39.25	39.65	12720300.0
2002-01-16 10:00:00	QQQ	ETF	39.65	39.76	39.31	39.34	13605500.0
2002-01-16 11:00:00	QQQ	ETF	39.34	39.47	39.13	39.42	11216200.0
2002-01-16 12:00:00	QQQ	ETF	39.41	39.47	39.24	39.44	7219200.0
2002-01-16 13:00:00	QQQ	ETF	39.44	39.49	39.26	39.29	5990900.0
2002-01-16 14:00:00	QQQ	ETF	39.32	39.67	39.21	39.54	12872400.0
2002-01-16 15:00:00	QQQ	ETF	39.54	39.67	38.79	38.8	20287300.0
2002-01-16 16:00:00	QQQ	ETF	38.8	39.22	38.77	39.08	2772700.0
2002-01-16 17:00:00	QQQ	ETF	39.09	39.17	39.0	39.15	205900.0
2002-01-16 18:00:00	QQQ	ETF	39.15	39.19	39.1	39.17	34500.0
2002-01-16 09:00:00	IWM	ETF	47.75	47.85	47.58	47.805	325200.0
2002-01-16 10:00:00	IWM	ETF	47.785	47.85	47.7	47.7	187600.0
2002-01-16 11:00:00	IWM	ETF	47.7	47.75	47.55	47.585	61800.0
2002-01-16 12:00:00	IWM	ETF	47.605	47.71	47.57	47.7	3172800.0
2002-01-16 13:00:00	IWM	ETF	47.75	47.75	47.675	47.7	80000.0
2002-01-16 14:00:00	IWM	ETF	47.7	47.845	47.675	47.845	47200.0
2002-01-16 15:00:00	IWM	ETF	47.845	47.86	47.1	47.1	444400.0
2002-01-16 16:00:00	IWM	ETF	47.2	47.32	47.1	47.32	52000.0
2002-01-16 09:00:00	DIA	ETF	98.6	98.88	98.2	98.49	946000.0
2002-01-16 10:00:00	DIA	ETF	98.49	98.77	98.29	98.33	756000.0
2002-01-16 11:00:00	DIA	ETF	98.36	98.36	98.01	98.25	324500.0
2002-01-16 12:00:00	DIA	ETF	98.25	98.32	98.01	98.18	441200.0
2002-01-16 13:00:00	DIA	ETF	98.2	98.2	97.65	97.71	904400.0
2002-01-16 14:00:00	DIA	ETF	97.7	98.2	97.6	98.14	691100.0
2002-01-16 15:00:00	DIA	ETF	98.16	98.34	97.2	97.3	784400.0
2002-01-16 16:00:00	DIA	ETF	97.26	97.85	97.04	97.05	160500.0
2002-01-16 17:00:00	DIA	ETF	97.13	97.13	97.05	97.05	2300.0

> showing 37 of 301 rows — these rows as CSV

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