PREVIEW / etf_1hour / 2001-08-20

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-08-20.parquet
  size:    11 KB
  rows:    227

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-20 09:00:00	SPY	ETF	116.8	117.0	116.65	116.68	1481200.0
2001-08-20 10:00:00	SPY	ETF	116.7	117.52	116.55	117.32	1814300.0
2001-08-20 11:00:00	SPY	ETF	117.28	117.42	117.1	117.24	604900.0
2001-08-20 12:00:00	SPY	ETF	117.24	117.4	116.94	116.94	541000.0
2001-08-20 13:00:00	SPY	ETF	116.98	117.39	116.85	117.36	2314900.0
2001-08-20 14:00:00	SPY	ETF	117.35	117.57	117.1	117.49	770400.0
2001-08-20 15:00:00	SPY	ETF	117.48	117.66	117.38	117.52	1781200.0
2001-08-20 16:00:00	SPY	ETF	117.56	118.62	116.72	117.97	774000.0
2001-08-20 17:00:00	SPY	ETF	117.85	117.85	117.85	117.85	40000.0
2001-08-20 09:00:00	QQQ	ETF	37.85	38.02	37.72	37.75	5556600.0
2001-08-20 10:00:00	QQQ	ETF	37.75	38.31	37.52	38.13	12295700.0
2001-08-20 11:00:00	QQQ	ETF	38.16	38.28	38.0	38.1	4582400.0
2001-08-20 12:00:00	QQQ	ETF	38.1	38.28	37.82	37.84	5340500.0
2001-08-20 13:00:00	QQQ	ETF	37.82	38.12	37.76	38.05	5574800.0
2001-08-20 14:00:00	QQQ	ETF	38.05	38.24	37.89	38.19	4636200.0
2001-08-20 15:00:00	QQQ	ETF	38.2	38.32	38.1	38.25	7021200.0
2001-08-20 16:00:00	QQQ	ETF	38.21	38.37	38.18	38.35	1620100.0
2001-08-20 17:00:00	QQQ	ETF	38.34	38.37	38.28	38.3	70300.0
2001-08-20 09:00:00	IWM	ETF	47.3	47.47	47.3	47.36	16200.0
2001-08-20 10:00:00	IWM	ETF	47.35	47.59	47.3	47.55	11600.0
2001-08-20 11:00:00	IWM	ETF	47.55	47.55	47.525	47.525	27800.0
2001-08-20 12:00:00	IWM	ETF	47.525	47.525	47.4	47.42	44200.0
2001-08-20 13:00:00	IWM	ETF	47.42	47.42	47.275	47.39	30800.0
2001-08-20 14:00:00	IWM	ETF	47.395	47.75	47.395	47.71	1432600.0
2001-08-20 15:00:00	IWM	ETF	47.8	47.875	47.655	47.875	898000.0
2001-08-20 16:00:00	IWM	ETF	47.875	47.875	47.875	47.875	6200.0
2001-08-20 09:00:00	DIA	ETF	102.4	102.59	102.25	102.35	259200.0
2001-08-20 10:00:00	DIA	ETF	102.33	103.14	102.15	102.98	664300.0
2001-08-20 11:00:00	DIA	ETF	103.01	103.15	102.88	103.0	362700.0
2001-08-20 12:00:00	DIA	ETF	103.0	103.12	102.8	102.83	77300.0
2001-08-20 13:00:00	DIA	ETF	102.78	103.0	102.66	102.99	212700.0
2001-08-20 14:00:00	DIA	ETF	102.99	103.17	102.82	103.12	103000.0
2001-08-20 15:00:00	DIA	ETF	103.11	103.27	102.97	103.25	192200.0
2001-08-20 16:00:00	DIA	ETF	103.28	103.65	103.27	103.58	115900.0

> showing 34 of 227 rows — these rows as CSV

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