PREVIEW / etf_1hour / 2001-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-10-10.parquet
  size:    12 KB
  rows:    243

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-10-10 09:00:00	SPY	ETF	105.8	106.67	105.52	106.47	2253100.0
2001-10-10 10:00:00	SPY	ETF	106.53	107.58	106.46	107.42	5910700.0
2001-10-10 11:00:00	SPY	ETF	107.48	107.69	107.07	107.56	1629800.0
2001-10-10 12:00:00	SPY	ETF	107.53	108.05	107.52	107.86	1854000.0
2001-10-10 13:00:00	SPY	ETF	107.9	108.2	107.72	107.88	2007100.0
2001-10-10 14:00:00	SPY	ETF	107.85	108.1	107.65	108.09	1550000.0
2001-10-10 15:00:00	SPY	ETF	108.1	108.55	107.94	108.4	2946800.0
2001-10-10 16:00:00	SPY	ETF	108.4	108.6	108.3	108.32	1429500.0
2001-10-10 17:00:00	SPY	ETF	108.5	108.5	108.0	108.35	3600.0
2001-10-10 18:00:00	SPY	ETF	108.35	108.35	108.35	108.35	5000.0
2001-10-10 09:00:00	QQQ	ETF	30.87	31.52	30.75	31.48	10562900.0
2001-10-10 10:00:00	QQQ	ETF	31.44	31.93	31.32	31.78	17030700.0
2001-10-10 11:00:00	QQQ	ETF	31.8	31.86	31.52	31.77	7949000.0
2001-10-10 12:00:00	QQQ	ETF	31.77	32.0	31.67	31.93	5404000.0
2001-10-10 13:00:00	QQQ	ETF	31.9	32.23	31.9	32.01	7572000.0
2001-10-10 14:00:00	QQQ	ETF	32.01	32.19	31.8	32.18	6278800.0
2001-10-10 15:00:00	QQQ	ETF	32.18	32.5	32.09	32.49	13945400.0
2001-10-10 16:00:00	QQQ	ETF	32.48	32.7	31.55	32.61	2733700.0
2001-10-10 17:00:00	QQQ	ETF	32.72	32.75	32.55	32.62	95300.0
2001-10-10 18:00:00	QQQ	ETF	32.6	32.68	32.52	32.62	27100.0
2001-10-10 09:00:00	IWM	ETF	40.55	41.15	40.55	41.135	10600.0
2001-10-10 10:00:00	IWM	ETF	41.075	41.59	41.075	41.59	67400.0
2001-10-10 11:00:00	IWM	ETF	41.585	41.585	41.27	41.35	72400.0
2001-10-10 12:00:00	IWM	ETF	41.425	41.425	41.305	41.33	9000.0
2001-10-10 13:00:00	IWM	ETF	41.33	41.455	41.33	41.395	18400.0
2001-10-10 14:00:00	IWM	ETF	41.42	41.44	41.315	41.365	37800.0
2001-10-10 15:00:00	IWM	ETF	41.46	41.915	41.46	41.915	165400.0
2001-10-10 16:00:00	IWM	ETF	41.94	42.0	41.875	42.0	253400.0
2001-10-10 09:00:00	DIA	ETF	90.2	91.1	90.07	91.0	1058100.0
2001-10-10 10:00:00	DIA	ETF	90.93	92.1	90.93	91.9	1441500.0
2001-10-10 11:00:00	DIA	ETF	91.94	91.96	91.48	91.84	1106200.0
2001-10-10 12:00:00	DIA	ETF	91.77	92.42	91.76	92.09	630700.0
2001-10-10 13:00:00	DIA	ETF	92.15	92.43	92.02	92.15	515000.0
2001-10-10 14:00:00	DIA	ETF	92.16	92.35	91.9	92.18	412500.0
2001-10-10 15:00:00	DIA	ETF	92.23	92.79	92.11	92.65	1433900.0
2001-10-10 16:00:00	DIA	ETF	92.65	92.99	92.48	92.99	91300.0
2001-10-10 17:00:00	DIA	ETF	93.0	93.0	93.0	93.0	700.0
2001-10-10 18:00:00	DIA	ETF	93.0	93.0	92.81	92.81	200.0

> showing 38 of 243 rows — these rows as CSV

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