PREVIEW / etf_1hour / 2020-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-29.parquet
  size:    382 KB
  rows:    12,901

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-29 04:00:00	SPY	ETF	289.47	289.69	288.81	289.69	58139.0
2020-04-29 05:00:00	SPY	ETF	289.66	289.87	289.32	289.5	19875.0
2020-04-29 06:00:00	SPY	ETF	289.57	289.57	288.6	289.35	170711.0
2020-04-29 07:00:00	SPY	ETF	289.32	289.53	288.21	288.46	1023781.0
2020-04-29 08:00:00	SPY	ETF	289.13	292.5	288.2	292.33	4957660.0
2020-04-29 09:00:00	SPY	ETF	292.33	292.88	290.41	291.98	13502017.0
2020-04-29 10:00:00	SPY	ETF	291.96	292.67	290.8	292.39	14951784.0
2020-04-29 11:00:00	SPY	ETF	292.39	293.14	291.91	292.8899	12736237.0
2020-04-29 12:00:00	SPY	ETF	292.8843	294.37	292.8843	293.94	10708712.0
2020-04-29 13:00:00	SPY	ETF	293.95	294.58	293.38	293.69	10010993.0
2020-04-29 14:00:00	SPY	ETF	293.69	294.12	292.51	293.97	15908775.0
2020-04-29 15:00:00	SPY	ETF	293.99	294.88	293.08	293.19	25853692.0
2020-04-29 16:00:00	SPY	ETF	293.19	296.1	293.09	296.0	6012953.0
2020-04-29 17:00:00	SPY	ETF	296.02	296.02	293.21	295.82	537753.0
2020-04-29 18:00:00	SPY	ETF	295.86	295.86	294.86	295.12	400869.0
2020-04-29 19:00:00	SPY	ETF	295.12	295.22	294.64	294.8	272304.0
2020-04-29 04:00:00	QQQ	ETF	215.23	215.42	214.91	215.29	37992.0
2020-04-29 05:00:00	QQQ	ETF	215.3	215.43	214.98	215.08	12286.0
2020-04-29 06:00:00	QQQ	ETF	215.08	215.09	214.6	215.09	38583.0
2020-04-29 07:00:00	QQQ	ETF	215.09	215.13	214.1	214.37	251475.0
2020-04-29 08:00:00	QQQ	ETF	215.08	217.04	214.1398	216.91	998761.0
2020-04-29 09:00:00	QQQ	ETF	216.97	217.36	215.14	217.03	5959523.0
2020-04-29 10:00:00	QQQ	ETF	217.025	218.135	216.3701	217.67	5840410.0
2020-04-29 11:00:00	QQQ	ETF	217.67	217.995	217.2801	217.54	4328251.0
2020-04-29 12:00:00	QQQ	ETF	217.55	218.72	217.55	218.34	2855789.0
2020-04-29 13:00:00	QQQ	ETF	218.35	218.83	218.2	218.6301	3360003.0
2020-04-29 14:00:00	QQQ	ETF	218.62	219.2	217.73	219.094	4429627.0
2020-04-29 15:00:00	QQQ	ETF	219.1066	219.97	218.63	218.75	8480691.0
2020-04-29 16:00:00	QQQ	ETF	218.76	222.5	218.7	222.47	3085959.0
2020-04-29 17:00:00	QQQ	ETF	222.48	222.64	222.0	222.28	164369.0
2020-04-29 18:00:00	QQQ	ETF	222.12	222.32	221.48	221.88	208629.0
2020-04-29 19:00:00	QQQ	ETF	221.85	222.17	221.51	221.87	151551.0
2020-04-29 04:00:00	IWM	ETF	130.96	130.96	130.69	130.9	2135.0
2020-04-29 05:00:00	IWM	ETF	131.0	131.06	130.67	130.78	3704.0
2020-04-29 06:00:00	IWM	ETF	130.44	130.71	130.36	130.71	2182.0
2020-04-29 07:00:00	IWM	ETF	130.7	130.88	130.0	130.16	186788.0
2020-04-29 08:00:00	IWM	ETF	130.4201	134.03	130.09	133.99	1127711.0
2020-04-29 09:00:00	IWM	ETF	133.99	134.09	131.875	133.36	5903027.0
2020-04-29 10:00:00	IWM	ETF	133.36	134.62	132.615	134.14	5049201.0
2020-04-29 11:00:00	IWM	ETF	134.14	135.47	133.83	135.335	4242308.0
2020-04-29 12:00:00	IWM	ETF	135.34	136.53	135.33	136.28	4939774.0
2020-04-29 13:00:00	IWM	ETF	136.29	136.7	135.515	135.695	5143314.0
2020-04-29 14:00:00	IWM	ETF	135.695	136.845	135.22	136.42	4864969.0
2020-04-29 15:00:00	IWM	ETF	136.4101	136.65	135.15	135.35	8529891.0
2020-04-29 16:00:00	IWM	ETF	135.36	136.35	135.13	136.34	2400722.0
2020-04-29 17:00:00	IWM	ETF	136.35	136.5	135.46	136.47	121754.0
2020-04-29 18:00:00	IWM	ETF	136.46	136.49	135.92	136.02	210229.0
2020-04-29 19:00:00	IWM	ETF	136.02	136.22	135.83	135.85	76800.0
2020-04-29 04:00:00	DIA	ETF	243.49	243.49	242.99	243.34	4715.0
2020-04-29 05:00:00	DIA	ETF	243.57	243.77	243.35	243.35	2050.0

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

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