PREVIEW / etf_1hour / 2021-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-28.parquet
  size:    425 KB
  rows:    14,990

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
2021-10-28 04:00:00	SPY	ETF	454.53	455.04	454.28	454.87	21688.0
2021-10-28 05:00:00	SPY	ETF	454.87	454.95	454.47	454.67	40755.0
2021-10-28 06:00:00	SPY	ETF	454.69	455.43	454.6	455.43	95029.0
2021-10-28 07:00:00	SPY	ETF	455.37	455.63	455.08	455.15	306561.0
2021-10-28 08:00:00	SPY	ETF	455.42	455.76	454.28	455.37	456714.0
2021-10-28 09:00:00	SPY	ETF	455.37	456.96	455.12	456.76	4886136.0
2021-10-28 10:00:00	SPY	ETF	456.77	457.976	456.0424	457.47	5718883.0
2021-10-28 11:00:00	SPY	ETF	457.46	457.95	456.86	457.08	3968084.0
2021-10-28 12:00:00	SPY	ETF	457.08	457.71	456.5	456.69	3202236.0
2021-10-28 13:00:00	SPY	ETF	456.72	457.495	456.68	457.34	2245115.0
2021-10-28 14:00:00	SPY	ETF	457.34	457.91	457.325	457.5	2724970.0
2021-10-28 15:00:00	SPY	ETF	457.49	458.4	457.0929	458.26	10146540.0
2021-10-28 16:00:00	SPY	ETF	458.26	458.48	456.69	457.31	4195528.0
2021-10-28 17:00:00	SPY	ETF	457.25	457.71	457.24	457.35	116871.0
2021-10-28 18:00:00	SPY	ETF	457.4	458.32	456.98	457.11	292433.0
2021-10-28 19:00:00	SPY	ETF	457.1	457.1	456.82	457.0	59414.0
2021-10-28 04:00:00	QQQ	ETF	381.14	381.8	380.82	381.69	277841.0
2021-10-28 05:00:00	QQQ	ETF	381.66	381.7	381.19	381.4	163736.0
2021-10-28 06:00:00	QQQ	ETF	381.42	382.03	381.35	381.99	165992.0
2021-10-28 07:00:00	QQQ	ETF	382.0	382.39	381.88	382.02	219814.0
2021-10-28 08:00:00	QQQ	ETF	382.23	382.41	380.285	381.86	422446.0
2021-10-28 09:00:00	QQQ	ETF	381.87	382.55	381.155	381.89	5163535.0
2021-10-28 10:00:00	QQQ	ETF	381.87	383.88	381.6501	383.04	5530380.0
2021-10-28 11:00:00	QQQ	ETF	383.04	384.03	382.8799	383.27	2637332.0
2021-10-28 12:00:00	QQQ	ETF	383.29	383.975	382.415	382.75	2079892.0
2021-10-28 13:00:00	QQQ	ETF	382.75	383.65	382.65	383.45	1535921.0
2021-10-28 14:00:00	QQQ	ETF	383.4599	384.16	383.42	383.74	2315664.0
2021-10-28 15:00:00	QQQ	ETF	383.73	384.48	383.11	384.2	5098161.0
2021-10-28 16:00:00	QQQ	ETF	384.22	384.6	380.0	381.98	3745382.0
2021-10-28 17:00:00	QQQ	ETF	381.98	382.61	381.72	382.2	141895.0
2021-10-28 18:00:00	QQQ	ETF	382.25	382.51	381.92	382.05	129999.0
2021-10-28 19:00:00	QQQ	ETF	382.03	382.17	381.9	382.05	100051.0
2021-10-28 04:00:00	IWM	ETF	224.18	224.23	223.87	224.0	4969.0
2021-10-28 05:00:00	IWM	ETF	223.92	223.95	223.61	223.77	15169.0
2021-10-28 06:00:00	IWM	ETF	223.8	224.16	223.78	224.12	35916.0
2021-10-28 07:00:00	IWM	ETF	224.06	224.42	224.05	224.32	50277.0
2021-10-28 08:00:00	IWM	ETF	224.2401	224.75	223.86	224.75	207255.0
2021-10-28 09:00:00	IWM	ETF	224.76	227.09	224.57	226.62	3840202.0
2021-10-28 10:00:00	IWM	ETF	226.625	227.4	226.402	226.985	2859465.0
2021-10-28 11:00:00	IWM	ETF	226.99	227.21	226.55	226.65	1483321.0
2021-10-28 12:00:00	IWM	ETF	226.66	227.51	226.65	227.01	999268.0
2021-10-28 13:00:00	IWM	ETF	227.01	227.75	227.01	227.64	1001972.0
2021-10-28 14:00:00	IWM	ETF	227.65	227.885	227.37	227.465	1322642.0
2021-10-28 15:00:00	IWM	ETF	227.47	228.26	227.23	228.05	3612211.0
2021-10-28 16:00:00	IWM	ETF	228.11	228.82	228.0	228.61	3521697.0
2021-10-28 17:00:00	IWM	ETF	228.52	228.68	228.45	228.54	15446.0
2021-10-28 18:00:00	IWM	ETF	228.48	228.48	228.14	228.19	24727.0
2021-10-28 19:00:00	IWM	ETF	228.16	228.2	228.02	228.12	27715.0
2021-10-28 04:00:00	DIA	ETF	355.49	355.5	355.4	355.5	1356.0
2021-10-28 05:00:00	DIA	ETF	355.42	355.42	355.2	355.2	648.0

> showing 50 of 14,990 rows — these rows as CSV

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