PREVIEW / etf_1hour / 2001-05-24

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-05-24.parquet
  size:    11 KB
  rows:    225

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-05-24 09:00:00	SPY	ETF	129.47	130.0	129.17	129.84	1364000.0
2001-05-24 10:00:00	SPY	ETF	129.84	129.93	128.68	128.75	1590700.0
2001-05-24 11:00:00	SPY	ETF	128.75	129.08	128.62	129.0	790900.0
2001-05-24 12:00:00	SPY	ETF	129.06	129.09	128.67	128.67	463900.0
2001-05-24 13:00:00	SPY	ETF	128.65	129.02	128.55	128.84	664800.0
2001-05-24 14:00:00	SPY	ETF	128.86	129.57	128.67	129.35	960500.0
2001-05-24 15:00:00	SPY	ETF	129.39	129.89	129.37	129.7	1121100.0
2001-05-24 16:00:00	SPY	ETF	129.7	129.81	129.6	129.64	697200.0
2001-05-24 17:00:00	SPY	ETF	129.75	131.0	129.58	129.9	11500.0
2001-05-24 09:00:00	QQQ	ETF	48.97	49.48	48.5	49.27	9714700.0
2001-05-24 10:00:00	QQQ	ETF	49.31	49.45	48.35	48.45	11873600.0
2001-05-24 11:00:00	QQQ	ETF	48.48	48.9	48.27	48.86	7481400.0
2001-05-24 12:00:00	QQQ	ETF	48.86	49.09	48.7	48.75	4715100.0
2001-05-24 13:00:00	QQQ	ETF	48.73	48.97	48.48	48.72	4963700.0
2001-05-24 14:00:00	QQQ	ETF	48.75	49.38	48.6	49.28	7989800.0
2001-05-24 15:00:00	QQQ	ETF	49.27	49.98	49.22	49.91	11116400.0
2001-05-24 16:00:00	QQQ	ETF	49.94	50.0	49.05	49.98	1504100.0
2001-05-24 17:00:00	QQQ	ETF	49.95	50.16	49.92	50.1	96000.0
2001-05-24 18:00:00	QQQ	ETF	50.15	50.15	50.05	50.05	63100.0
2001-05-24 09:00:00	IWM	ETF	50.8	50.85	50.525	50.85	108000.0
2001-05-24 10:00:00	IWM	ETF	50.7	50.7	50.315	50.41	90600.0
2001-05-24 11:00:00	IWM	ETF	50.255	50.35	50.16	50.35	66400.0
2001-05-24 12:00:00	IWM	ETF	50.37	50.545	50.255	50.545	27400.0
2001-05-24 13:00:00	IWM	ETF	50.45	50.495	50.44	50.44	13000.0
2001-05-24 14:00:00	IWM	ETF	50.45	50.745	50.45	50.74	22400.0
2001-05-24 15:00:00	IWM	ETF	50.735	51.1	50.735	51.1	145400.0
2001-05-24 16:00:00	IWM	ETF	51.1	51.175	51.025	51.025	56400.0
2001-05-24 09:00:00	DIA	ETF	111.45	111.85	111.1	111.65	327500.0
2001-05-24 10:00:00	DIA	ETF	111.61	111.75	110.7	110.7	410100.0
2001-05-24 11:00:00	DIA	ETF	110.71	111.13	110.61	111.02	160900.0
2001-05-24 12:00:00	DIA	ETF	111.09	111.09	110.61	110.65	179600.0
2001-05-24 13:00:00	DIA	ETF	110.62	110.85	110.55	110.79	170800.0
2001-05-24 14:00:00	DIA	ETF	110.81	111.4	110.68	111.23	344600.0
2001-05-24 15:00:00	DIA	ETF	111.23	111.6	111.17	111.29	495400.0
2001-05-24 16:00:00	DIA	ETF	111.26	111.42	111.25	111.3	279700.0
2001-05-24 17:00:00	DIA	ETF	111.29	111.29	111.29	111.29	100.0

> showing 36 of 225 rows — these rows as CSV

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