PREVIEW / etf_1hour / 2002-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-04-29.parquet
  size:    14 KB
  rows:    309

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-04-29 09:00:00	SPY	ETF	107.93	108.19	107.66	108.17	2456100.0
2002-04-29 10:00:00	SPY	ETF	108.16	108.26	107.53	108.09	2458900.0
2002-04-29 11:00:00	SPY	ETF	108.08	108.13	107.55	107.75	1582700.0
2002-04-29 12:00:00	SPY	ETF	107.75	107.94	107.62	107.68	874000.0
2002-04-29 13:00:00	SPY	ETF	107.65	107.69	107.1	107.6	2430500.0
2002-04-29 14:00:00	SPY	ETF	107.6	107.65	106.86	106.94	1766400.0
2002-04-29 15:00:00	SPY	ETF	106.92	107.24	106.63	106.82	4282600.0
2002-04-29 16:00:00	SPY	ETF	106.91	106.98	106.7	106.8	1074500.0
2002-04-29 17:00:00	SPY	ETF	106.9	106.99	106.9	106.99	1200.0
2002-04-29 18:00:00	SPY	ETF	106.97	107.09	106.9	106.93	600.0
2002-04-29 09:00:00	QQQ	ETF	31.24	31.52	31.1	31.46	9198700.0
2002-04-29 10:00:00	QQQ	ETF	31.46	31.55	31.06	31.39	15209500.0
2002-04-29 11:00:00	QQQ	ETF	31.38	31.47	31.15	31.33	10949900.0
2002-04-29 12:00:00	QQQ	ETF	31.35	31.42	31.21	31.25	4691000.0
2002-04-29 13:00:00	QQQ	ETF	31.25	31.29	30.95	31.19	9299200.0
2002-04-29 14:00:00	QQQ	ETF	31.18	31.23	30.56	30.63	11562500.0
2002-04-29 15:00:00	QQQ	ETF	30.63	31.04	30.62	31.02	19899700.0
2002-04-29 16:00:00	QQQ	ETF	31.03	31.13	31.0	31.13	2840400.0
2002-04-29 17:00:00	QQQ	ETF	31.14	31.14	31.08	31.09	30100.0
2002-04-29 18:00:00	QQQ	ETF	31.09	31.16	31.09	31.13	19100.0
2002-04-29 09:00:00	IWM	ETF	50.0	50.09	49.875	49.98	511600.0
2002-04-29 10:00:00	IWM	ETF	49.935	50.04	49.75	49.85	183800.0
2002-04-29 11:00:00	IWM	ETF	49.835	49.925	49.725	49.82	294000.0
2002-04-29 12:00:00	IWM	ETF	49.805	49.915	49.79	49.85	140200.0
2002-04-29 13:00:00	IWM	ETF	49.785	49.85	49.58	49.83	632000.0
2002-04-29 14:00:00	IWM	ETF	49.765	49.83	49.55	49.575	632200.0
2002-04-29 15:00:00	IWM	ETF	49.55	49.88	49.55	49.86	725400.0
2002-04-29 16:00:00	IWM	ETF	49.9	49.93	49.825	49.835	428400.0
2002-04-29 09:00:00	DIA	ETF	99.35	99.42	99.0	99.38	553200.0
2002-04-29 10:00:00	DIA	ETF	99.39	99.5	98.86	99.39	378800.0
2002-04-29 11:00:00	DIA	ETF	99.32	99.43	98.97	99.2	869300.0
2002-04-29 12:00:00	DIA	ETF	99.2	99.5	99.1	99.23	378300.0
2002-04-29 13:00:00	DIA	ETF	99.23	99.23	98.66	99.03	693100.0
2002-04-29 14:00:00	DIA	ETF	99.06	99.08	98.45	98.59	633800.0
2002-04-29 15:00:00	DIA	ETF	98.58	98.71	98.13	98.26	688900.0
2002-04-29 16:00:00	DIA	ETF	98.29	98.39	98.2	98.39	80100.0
2002-04-29 17:00:00	DIA	ETF	98.01	98.01	98.01	98.01	100.0

> showing 37 of 309 rows — these rows as CSV

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