PREVIEW / etf_1hour / 2020-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-05.parquet
  size:    371 KB
  rows:    12,492

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-05-05 04:00:00	SPY	ETF	286.17	286.82	283.72	283.78	213478.0
2020-05-05 05:00:00	SPY	ETF	283.7	285.45	283.61	285.17	76414.0
2020-05-05 06:00:00	SPY	ETF	285.39	285.97	285.03	285.7	80877.0
2020-05-05 07:00:00	SPY	ETF	285.79	286.25	285.51	285.9	513916.0
2020-05-05 08:00:00	SPY	ETF	285.91	286.79	284.13	286.46	502925.0
2020-05-05 09:00:00	SPY	ETF	286.46	288.16	286.23	288.1528	8840677.0
2020-05-05 10:00:00	SPY	ETF	288.16	288.47	287.35	287.9664	10493259.0
2020-05-05 11:00:00	SPY	ETF	287.965	288.96	287.83	288.855	7404099.0
2020-05-05 12:00:00	SPY	ETF	288.87	289.24	288.3	288.4	7492122.0
2020-05-05 13:00:00	SPY	ETF	288.41	288.95	288.0	288.74	7052511.0
2020-05-05 14:00:00	SPY	ETF	288.74	289.25	288.46	289.23	5917022.0
2020-05-05 15:00:00	SPY	ETF	289.23	289.23	285.75	286.22	25315907.0
2020-05-05 16:00:00	SPY	ETF	286.14	286.37	285.58	286.3	4452307.0
2020-05-05 17:00:00	SPY	ETF	286.3	286.45	286.0	286.11	292500.0
2020-05-05 18:00:00	SPY	ETF	286.11	287.19	285.79	287.15	217677.0
2020-05-05 19:00:00	SPY	ETF	287.12	287.22	286.82	287.02	150929.0
2020-05-05 04:00:00	QQQ	ETF	217.16	217.6	215.44	215.56	89794.0
2020-05-05 05:00:00	QQQ	ETF	215.4	216.7	215.38	216.68	36414.0
2020-05-05 06:00:00	QQQ	ETF	216.72	217.12	216.5	216.77	51348.0
2020-05-05 07:00:00	QQQ	ETF	217.03	217.49	216.82	217.35	159198.0
2020-05-05 08:00:00	QQQ	ETF	217.2001	217.84	216.14	217.53	260652.0
2020-05-05 09:00:00	QQQ	ETF	217.51	218.64	217.115	218.63	5352858.0
2020-05-05 10:00:00	QQQ	ETF	218.63	218.98	218.145	218.78	4713906.0
2020-05-05 11:00:00	QQQ	ETF	218.77	219.35	218.5	219.31	3019348.0
2020-05-05 12:00:00	QQQ	ETF	219.31	219.625	218.82	219.05	3715842.0
2020-05-05 13:00:00	QQQ	ETF	219.05	219.68	218.85	219.57	2944571.0
2020-05-05 14:00:00	QQQ	ETF	219.57	220.14	219.3804	220.1199	2868874.0
2020-05-05 15:00:00	QQQ	ETF	220.11	220.11	216.85	217.66	8624759.0
2020-05-05 16:00:00	QQQ	ETF	217.67	218.0	217.36	217.98	758045.0
2020-05-05 17:00:00	QQQ	ETF	217.98	218.2	217.97	218.08	62339.0
2020-05-05 18:00:00	QQQ	ETF	218.04	218.82	217.66	218.77	113288.0
2020-05-05 19:00:00	QQQ	ETF	218.77	218.77	218.46	218.56	62098.0
2020-05-05 04:00:00	IWM	ETF	127.79	128.1	126.0	126.0	15046.0
2020-05-05 05:00:00	IWM	ETF	126.21	127.01	126.13	126.97	6511.0
2020-05-05 06:00:00	IWM	ETF	127.15	127.17	126.8	127.16	69790.0
2020-05-05 07:00:00	IWM	ETF	127.21	127.43	127.04	127.39	44269.0
2020-05-05 08:00:00	IWM	ETF	127.39	128.02	126.95	127.92	70052.0
2020-05-05 09:00:00	IWM	ETF	127.89	129.81	127.57	129.72	4571188.0
2020-05-05 10:00:00	IWM	ETF	129.74	129.92	127.95	128.365	4394963.0
2020-05-05 11:00:00	IWM	ETF	128.38	129.45	128.38	129.08	2424109.0
2020-05-05 12:00:00	IWM	ETF	129.09	129.38	128.17	128.425	1736669.0
2020-05-05 13:00:00	IWM	ETF	128.43	128.61	127.87	128.18	2922025.0
2020-05-05 14:00:00	IWM	ETF	128.19	128.69	128.08	128.55	2146515.0
2020-05-05 15:00:00	IWM	ETF	128.55	128.55	126.1	126.59	7066079.0
2020-05-05 16:00:00	IWM	ETF	126.58	126.7867	125.7564	126.49	1615466.0
2020-05-05 17:00:00	IWM	ETF	126.56	126.56	126.26	126.41	7300.0
2020-05-05 18:00:00	IWM	ETF	126.41	127.34	126.37	127.34	67319.0
2020-05-05 19:00:00	IWM	ETF	127.34	127.34	126.9	127.14	33403.0
2020-05-05 04:00:00	DIA	ETF	239.64	240.5	237.88	237.88	3689.0
2020-05-05 05:00:00	DIA	ETF	238.35	239.03	238.35	238.94	635.0

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

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