PREVIEW / etf_1hour / 2002-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-05-20.parquet
  size:    14 KB
  rows:    319

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-05-20 09:00:00	SPY	ETF	110.64	110.69	110.13	110.29	1886500.0
2002-05-20 10:00:00	SPY	ETF	110.29	110.33	109.62	109.7	3888600.0
2002-05-20 11:00:00	SPY	ETF	109.71	109.91	109.54	109.89	1789700.0
2002-05-20 12:00:00	SPY	ETF	109.89	109.98	109.73	109.8	729500.0
2002-05-20 13:00:00	SPY	ETF	109.79	110.18	109.79	110.05	1087400.0
2002-05-20 14:00:00	SPY	ETF	110.04	110.09	109.73	109.79	1060500.0
2002-05-20 15:00:00	SPY	ETF	109.76	109.86	109.49	109.64	2097200.0
2002-05-20 16:00:00	SPY	ETF	109.64	109.9	109.52	109.77	897300.0
2002-05-20 17:00:00	SPY	ETF	109.75	109.75	109.7	109.75	2500.0
2002-05-20 18:00:00	SPY	ETF	109.71	109.71	109.68	109.68	400.0
2002-05-20 09:00:00	QQQ	ETF	32.6	32.7	32.45	32.53	9104000.0
2002-05-20 10:00:00	QQQ	ETF	32.51	32.54	31.97	32.02	16546700.0
2002-05-20 11:00:00	QQQ	ETF	32.02	32.15	31.94	32.15	7223700.0
2002-05-20 12:00:00	QQQ	ETF	32.13	32.18	31.95	32.03	4673400.0
2002-05-20 13:00:00	QQQ	ETF	32.01	32.29	32.01	32.17	8525200.0
2002-05-20 14:00:00	QQQ	ETF	32.16	32.25	32.02	32.08	6827400.0
2002-05-20 15:00:00	QQQ	ETF	32.08	32.25	31.94	32.17	14447100.0
2002-05-20 16:00:00	QQQ	ETF	32.17	32.28	32.05	32.25	1698600.0
2002-05-20 17:00:00	QQQ	ETF	32.24	32.25	32.2	32.21	76100.0
2002-05-20 18:00:00	QQQ	ETF	32.21	32.21	32.15	32.18	15800.0
2002-05-20 09:00:00	IWM	ETF	50.625	50.625	50.475	50.54	33000.0
2002-05-20 10:00:00	IWM	ETF	50.565	50.565	50.25	50.255	139000.0
2002-05-20 11:00:00	IWM	ETF	50.31	50.33	50.17	50.245	114400.0
2002-05-20 12:00:00	IWM	ETF	50.21	50.245	50.17	50.245	145400.0
2002-05-20 13:00:00	IWM	ETF	50.225	50.3	50.15	50.295	263200.0
2002-05-20 14:00:00	IWM	ETF	50.24	50.29	50.16	50.19	104600.0
2002-05-20 15:00:00	IWM	ETF	50.2	50.2	50.005	50.05	283800.0
2002-05-20 16:00:00	IWM	ETF	50.05	50.205	50.03	50.12	741200.0
2002-05-20 17:00:00	IWM	ETF	50.05	50.05	50.05	50.05	200.0
2002-05-20 18:00:00	IWM	ETF	50.25	50.25	50.25	50.25	200.0
2002-05-20 09:00:00	DIA	ETF	103.08	103.18	102.63	102.84	360000.0
2002-05-20 10:00:00	DIA	ETF	102.75	102.81	102.34	102.45	523100.0
2002-05-20 11:00:00	DIA	ETF	102.44	102.63	102.24	102.51	268900.0
2002-05-20 12:00:00	DIA	ETF	102.43	102.61	102.34	102.48	175200.0
2002-05-20 13:00:00	DIA	ETF	102.42	102.8	102.41	102.68	325500.0
2002-05-20 14:00:00	DIA	ETF	102.67	102.74	102.4	102.4	444700.0
2002-05-20 15:00:00	DIA	ETF	102.4	102.52	102.17	102.42	714100.0
2002-05-20 16:00:00	DIA	ETF	102.4	102.49	102.25	102.49	50400.0

> showing 38 of 319 rows — these rows as CSV

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