PREVIEW / etf_1hour / 2002-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2002/2002-01-04.parquet
  size:    14 KB
  rows:    296

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-04 09:00:00	SPY	ETF	117.17	117.7	117.14	117.62	1700100.0
2002-01-04 10:00:00	SPY	ETF	117.65	117.98	116.7	117.03	6497000.0
2002-01-04 11:00:00	SPY	ETF	117.01	117.28	116.86	116.94	2294400.0
2002-01-04 12:00:00	SPY	ETF	116.92	117.11	116.55	117.04	1485400.0
2002-01-04 13:00:00	SPY	ETF	117.04	117.35	116.93	117.35	3392300.0
2002-01-04 14:00:00	SPY	ETF	117.35	117.45	117.0	117.34	1742600.0
2002-01-04 15:00:00	SPY	ETF	117.37	117.7	117.26	117.41	2063300.0
2002-01-04 16:00:00	SPY	ETF	117.44	117.72	117.0	117.0	951900.0
2002-01-04 17:00:00	SPY	ETF	117.51	117.61	117.43	117.51	600.0
2002-01-04 18:00:00	SPY	ETF	117.51	117.51	117.51	117.51	100.0
2002-01-04 09:00:00	QQQ	ETF	41.95	42.29	41.86	41.95	13898600.0
2002-01-04 10:00:00	QQQ	ETF	41.95	42.15	41.2	41.41	24478100.0
2002-01-04 11:00:00	QQQ	ETF	41.42	41.62	41.19	41.24	11442100.0
2002-01-04 12:00:00	QQQ	ETF	41.25	41.39	40.93	41.34	6819400.0
2002-01-04 13:00:00	QQQ	ETF	41.33	41.72	41.26	41.69	7322700.0
2002-01-04 14:00:00	QQQ	ETF	41.72	41.89	41.5	41.75	9707700.0
2002-01-04 15:00:00	QQQ	ETF	41.76	41.95	41.59	41.65	10833800.0
2002-01-04 16:00:00	QQQ	ETF	41.65	41.74	41.39	41.6	1157500.0
2002-01-04 17:00:00	QQQ	ETF	41.64	41.71	41.57	41.6	110900.0
2002-01-04 18:00:00	QQQ	ETF	41.57	41.6	41.55	41.55	8500.0
2002-01-04 09:00:00	IWM	ETF	49.375	49.835	49.375	49.625	108000.0
2002-01-04 10:00:00	IWM	ETF	49.575	49.79	49.165	49.275	51200.0
2002-01-04 11:00:00	IWM	ETF	49.225	49.435	49.225	49.325	309200.0
2002-01-04 12:00:00	IWM	ETF	49.25	49.485	49.15	49.455	164000.0
2002-01-04 13:00:00	IWM	ETF	49.46	49.775	49.45	49.775	175400.0
2002-01-04 14:00:00	IWM	ETF	49.775	49.845	49.67	49.765	394000.0
2002-01-04 15:00:00	IWM	ETF	49.75	49.92	49.6	49.67	97600.0
2002-01-04 16:00:00	IWM	ETF	49.6	49.725	49.6	49.725	5000.0
2002-01-04 09:00:00	DIA	ETF	102.36	102.67	102.02	102.65	445700.0
2002-01-04 10:00:00	DIA	ETF	102.66	102.95	102.1	102.35	389400.0
2002-01-04 11:00:00	DIA	ETF	102.37	102.56	102.27	102.32	121600.0
2002-01-04 12:00:00	DIA	ETF	102.36	102.54	102.02	102.54	239400.0
2002-01-04 13:00:00	DIA	ETF	102.45	102.65	102.33	102.65	151100.0
2002-01-04 14:00:00	DIA	ETF	102.7	102.78	102.32	102.61	753600.0
2002-01-04 15:00:00	DIA	ETF	102.54	102.82	102.52	102.68	159400.0
2002-01-04 16:00:00	DIA	ETF	102.67	102.89	102.67	102.89	26400.0

> showing 36 of 296 rows — these rows as CSV

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