PREVIEW / etf_1hour / 2001-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-14.parquet
  size:    11 KB
  rows:    224

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
2001-08-14 09:00:00	SPY	ETF	120.14	120.35	119.86	120.2	2499500.0
2001-08-14 10:00:00	SPY	ETF	120.2	120.22	119.3	119.56	2493300.0
2001-08-14 11:00:00	SPY	ETF	119.53	119.76	119.42	119.56	784200.0
2001-08-14 12:00:00	SPY	ETF	119.55	119.78	119.45	119.56	538300.0
2001-08-14 13:00:00	SPY	ETF	119.53	119.56	119.06	119.35	1110500.0
2001-08-14 14:00:00	SPY	ETF	119.33	119.52	119.16	119.26	694000.0
2001-08-14 15:00:00	SPY	ETF	119.29	119.36	118.8	119.11	2070300.0
2001-08-14 16:00:00	SPY	ETF	119.11	119.35	119.02	119.35	692400.0
2001-08-14 17:00:00	SPY	ETF	119.3	119.35	119.3	119.35	1000.0
2001-08-14 09:00:00	QQQ	ETF	41.49	41.63	41.26	41.56	8469400.0
2001-08-14 10:00:00	QQQ	ETF	41.56	41.7	40.92	41.11	9697400.0
2001-08-14 11:00:00	QQQ	ETF	41.13	41.23	40.97	41.15	6008000.0
2001-08-14 12:00:00	QQQ	ETF	41.14	41.39	41.03	41.23	2836300.0
2001-08-14 13:00:00	QQQ	ETF	41.26	41.26	40.74	40.94	6541500.0
2001-08-14 14:00:00	QQQ	ETF	40.95	41.15	40.85	40.91	5757800.0
2001-08-14 15:00:00	QQQ	ETF	40.93	40.99	40.54	40.66	7329000.0
2001-08-14 16:00:00	QQQ	ETF	40.64	41.03	40.0	40.55	2489800.0
2001-08-14 17:00:00	QQQ	ETF	40.55	40.85	40.55	40.85	210500.0
2001-08-14 18:00:00	QQQ	ETF	40.78	40.95	40.75	40.9	110000.0
2001-08-14 09:00:00	IWM	ETF	47.775	47.85	47.725	47.85	11200.0
2001-08-14 10:00:00	IWM	ETF	47.85	48.075	47.755	47.975	1425600.0
2001-08-14 11:00:00	IWM	ETF	47.975	48.175	47.975	48.175	1526200.0
2001-08-14 12:00:00	IWM	ETF	48.025	48.2	48.025	48.175	390200.0
2001-08-14 13:00:00	IWM	ETF	48.115	48.115	47.95	47.995	65400.0
2001-08-14 14:00:00	IWM	ETF	47.995	48.1	47.915	47.915	85400.0
2001-08-14 15:00:00	IWM	ETF	47.975	47.975	47.71	47.85	163800.0
2001-08-14 09:00:00	DIA	ETF	104.5	104.97	104.5	104.83	207700.0
2001-08-14 10:00:00	DIA	ETF	104.83	104.86	104.02	104.26	392000.0
2001-08-14 11:00:00	DIA	ETF	104.27	104.57	104.22	104.4	145700.0
2001-08-14 12:00:00	DIA	ETF	104.37	104.63	104.36	104.42	55100.0
2001-08-14 13:00:00	DIA	ETF	104.37	104.37	104.09	104.31	142300.0
2001-08-14 14:00:00	DIA	ETF	104.31	104.41	104.15	104.28	125300.0
2001-08-14 15:00:00	DIA	ETF	104.31	104.35	103.97	104.22	202700.0
2001-08-14 16:00:00	DIA	ETF	104.2	104.35	103.97	104.3	16200.0

> showing 34 of 224 rows — these rows as CSV

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