PREVIEW / etf_1hour / 2020-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-28.parquet
  size:    374 KB
  rows:    12,662

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
2020-04-28 04:00:00	SPY	ETF	288.2	288.26	287.58	287.88	43292.0
2020-04-28 05:00:00	SPY	ETF	287.91	290.66	287.91	290.61	233113.0
2020-04-28 06:00:00	SPY	ETF	290.7	290.95	290.2	290.29	172695.0
2020-04-28 07:00:00	SPY	ETF	290.26	290.84	290.02	290.84	709872.0
2020-04-28 08:00:00	SPY	ETF	290.84	291.42	285.5	291.37	1361692.0
2020-04-28 09:00:00	SPY	ETF	291.32	291.45	289.45	289.48	15209663.0
2020-04-28 10:00:00	SPY	ETF	289.46	289.99	285.62	285.82	21379080.0
2020-04-28 11:00:00	SPY	ETF	285.84	287.79	285.58	286.81	14467937.0
2020-04-28 12:00:00	SPY	ETF	286.84	291.28	285.7	287.31	8615878.0
2020-04-28 13:00:00	SPY	ETF	287.32	288.02	287.0	287.45	6993767.0
2020-04-28 14:00:00	SPY	ETF	287.45	288.36	287.07	287.347	8722954.0
2020-04-28 15:00:00	SPY	ETF	287.35	288.09	285.4	285.77	20738194.0
2020-04-28 16:00:00	SPY	ETF	285.78	287.7804	285.64	286.28	4849316.0
2020-04-28 17:00:00	SPY	ETF	286.22	291.0	285.73	287.12	236842.0
2020-04-28 18:00:00	SPY	ETF	287.14	287.4	286.36	286.62	288037.0
2020-04-28 19:00:00	SPY	ETF	286.65	287.75	286.33	287.39	178096.0
2020-04-28 04:00:00	QQQ	ETF	216.41	216.5	216.1	216.3	20785.0
2020-04-28 05:00:00	QQQ	ETF	216.35	218.12	216.34	218.12	49908.0
2020-04-28 06:00:00	QQQ	ETF	218.1	218.3	217.7	217.73	56923.0
2020-04-28 07:00:00	QQQ	ETF	217.75	217.92	217.51	217.9	149732.0
2020-04-28 08:00:00	QQQ	ETF	217.6301	218.0	215.33	217.73	307226.0
2020-04-28 09:00:00	QQQ	ETF	217.64	217.74	215.42	215.47	5218611.0
2020-04-28 10:00:00	QQQ	ETF	215.47	215.7	212.06	212.3	8972732.0
2020-04-28 11:00:00	QQQ	ETF	212.32	213.59	212.1769	212.76	4461797.0
2020-04-28 12:00:00	QQQ	ETF	212.78	213.2098	211.71	213.0529	5221825.0
2020-04-28 13:00:00	QQQ	ETF	213.06	213.5499	212.79	213.17	3319377.0
2020-04-28 14:00:00	QQQ	ETF	213.189	213.88	212.67	212.87	3307625.0
2020-04-28 15:00:00	QQQ	ETF	212.86	213.46	211.21	211.52	6723011.0
2020-04-28 16:00:00	QQQ	ETF	211.51	212.97	211.25	212.3	1807031.0
2020-04-28 17:00:00	QQQ	ETF	212.16	213.95	212.16	213.87	356253.0
2020-04-28 18:00:00	QQQ	ETF	213.84	214.13	213.2	213.53	306280.0
2020-04-28 19:00:00	QQQ	ETF	213.51	214.15	213.28	214.0	92280.0
2020-04-28 04:00:00	IWM	ETF	128.02	128.02	127.58	127.87	1400.0
2020-04-28 05:00:00	IWM	ETF	128.34	129.29	128.34	129.24	8460.0
2020-04-28 06:00:00	IWM	ETF	129.74	129.74	129.25	129.4	20456.0
2020-04-28 07:00:00	IWM	ETF	129.31	130.14	129.23	130.06	103840.0
2020-04-28 08:00:00	IWM	ETF	129.74	131.52	128.25	131.5	469631.0
2020-04-28 09:00:00	IWM	ETF	131.45	131.64	130.03	130.19	8083748.0
2020-04-28 10:00:00	IWM	ETF	130.18	130.65	127.28	127.49	8573023.0
2020-04-28 11:00:00	IWM	ETF	127.49	129.48	127.34	129.0281	4807699.0
2020-04-28 12:00:00	IWM	ETF	129.07	129.64	128.44	129.61	2615755.0
2020-04-28 13:00:00	IWM	ETF	129.62	130.47	129.565	130.15	3106303.0
2020-04-28 14:00:00	IWM	ETF	130.1304	130.5	129.4022	129.73	4714805.0
2020-04-28 15:00:00	IWM	ETF	129.73	130.22	128.93	129.23	5447102.0
2020-04-28 16:00:00	IWM	ETF	129.25	130.11	128.9	129.5	1529013.0
2020-04-28 17:00:00	IWM	ETF	129.72	129.72	129.36	129.6	36040.0
2020-04-28 18:00:00	IWM	ETF	129.65	129.73	129.01	129.27	57297.0
2020-04-28 19:00:00	IWM	ETF	129.28	129.97	129.09	129.84	53489.0
2020-04-28 04:00:00	DIA	ETF	242.45	242.45	242.0	242.0	2615.0
2020-04-28 05:00:00	DIA	ETF	242.89	244.45	242.89	244.27	4573.0

> showing 50 of 12,662 rows — these rows as CSV

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