PREVIEW / etf_1hour / 2001-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2001/2001-04-05.parquet
  size:    11 KB
  rows:    213

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-04-05 09:00:00	SPY	ETF	113.3	113.31	112.5	113.01	3334900.0
2001-04-05 10:00:00	SPY	ETF	113.06	113.93	112.95	113.58	2573600.0
2001-04-05 11:00:00	SPY	ETF	113.74	113.78	113.11	113.4	1161000.0
2001-04-05 12:00:00	SPY	ETF	113.49	114.1	113.21	113.81	1098800.0
2001-04-05 13:00:00	SPY	ETF	113.89	114.32	113.8	113.98	1796200.0
2001-04-05 14:00:00	SPY	ETF	114.0	115.29	113.86	115.01	2105500.0
2001-04-05 15:00:00	SPY	ETF	115.04	115.49	114.9	115.22	2086500.0
2001-04-05 16:00:00	SPY	ETF	115.22	115.39	113.95	115.05	7317300.0
2001-04-05 17:00:00	SPY	ETF	115.0	115.25	115.0	115.16	4900.0
2001-04-05 18:00:00	SPY	ETF	115.01	115.31	115.0	115.31	12900.0
2001-04-05 09:00:00	QQQ	ETF	36.0	36.28	35.71	35.93	15561300.0
2001-04-05 10:00:00	QQQ	ETF	35.91	36.7	35.86	36.56	15314700.0
2001-04-05 11:00:00	QQQ	ETF	36.59	36.76	36.2	36.47	8529200.0
2001-04-05 12:00:00	QQQ	ETF	36.47	36.91	36.37	36.89	7298000.0
2001-04-05 13:00:00	QQQ	ETF	36.87	37.16	36.65	36.99	8584200.0
2001-04-05 14:00:00	QQQ	ETF	36.99	37.8	36.84	37.64	11494800.0
2001-04-05 15:00:00	QQQ	ETF	37.62	37.96	37.54	37.77	15526100.0
2001-04-05 16:00:00	QQQ	ETF	37.77	37.95	37.0	37.51	4107700.0
2001-04-05 17:00:00	QQQ	ETF	37.59	37.75	37.46	37.64	93600.0
2001-04-05 18:00:00	QQQ	ETF	37.75	37.9	37.65	37.9	73300.0
2001-04-05 09:00:00	IWM	ETF	43.0	43.425	43.0	43.425	280800.0
2001-04-05 10:00:00	IWM	ETF	43.5	43.7	43.5	43.55	127200.0
2001-04-05 11:00:00	IWM	ETF	43.55	43.72	43.5	43.575	88200.0
2001-04-05 12:00:00	IWM	ETF	43.595	43.7	43.525	43.7	49000.0
2001-04-05 13:00:00	IWM	ETF	43.75	43.825	43.565	43.675	154000.0
2001-04-05 14:00:00	IWM	ETF	43.675	44.05	43.675	44.0	115000.0
2001-04-05 15:00:00	IWM	ETF	44.125	44.45	44.05	44.45	125800.0
2001-04-05 16:00:00	IWM	ETF	44.45	44.45	44.45	44.45	10000.0
2001-04-05 09:00:00	DIA	ETF	97.24	97.8	97.1	97.43	829500.0
2001-04-05 10:00:00	DIA	ETF	97.5	98.4	97.42	98.1	1079500.0
2001-04-05 11:00:00	DIA	ETF	98.08	98.11	97.5	97.85	311700.0
2001-04-05 12:00:00	DIA	ETF	97.89	98.2	97.61	98.19	137300.0
2001-04-05 13:00:00	DIA	ETF	98.06	98.8	98.02	98.3	996000.0
2001-04-05 14:00:00	DIA	ETF	98.21	99.25	98.2	99.0	629800.0
2001-04-05 15:00:00	DIA	ETF	98.9	99.49	98.9	99.4	1295000.0
2001-04-05 16:00:00	DIA	ETF	99.4	99.45	99.0	99.33	385700.0
2001-04-05 17:00:00	DIA	ETF	99.99	99.99	99.22	99.22	200.0
2001-04-05 18:00:00	DIA	ETF	99.0	99.0	98.0	98.0	400.0

> showing 38 of 213 rows — these rows as CSV

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