PREVIEW / etf_1hour / 2020-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-10.parquet
  size:    356 KB
  rows:    11,667

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-01-10 04:00:00	SPY	ETF	327.22	327.41	327.15	327.4	5726.0
2020-01-10 05:00:00	SPY	ETF	327.43	327.5	327.41	327.42	3920.0
2020-01-10 06:00:00	SPY	ETF	327.41	327.74	327.41	327.58	29141.0
2020-01-10 07:00:00	SPY	ETF	327.58	327.58	327.36	327.44	111054.0
2020-01-10 08:00:00	SPY	ETF	327.43	327.59	326.85	327.26	958848.0
2020-01-10 09:00:00	SPY	ETF	327.28	327.44	326.573	327.16	6293733.0
2020-01-10 10:00:00	SPY	ETF	327.155	327.46	326.92	327.21	8261633.0
2020-01-10 11:00:00	SPY	ETF	327.21	327.305	326.415	326.565	5755635.0
2020-01-10 12:00:00	SPY	ETF	326.59	326.63	325.93	326.5	4627583.0
2020-01-10 13:00:00	SPY	ETF	326.5	326.89	326.46	326.765	2564590.0
2020-01-10 14:00:00	SPY	ETF	326.76	326.8	326.04	326.29	3979111.0
2020-01-10 15:00:00	SPY	ETF	326.29	326.6094	325.2	325.7	13687528.0
2020-01-10 16:00:00	SPY	ETF	325.69	325.73	325.45	325.46	5986147.0
2020-01-10 17:00:00	SPY	ETF	325.45	325.6	325.4	325.57	88287.0
2020-01-10 18:00:00	SPY	ETF	325.57	325.63	325.52	325.62	11591.0
2020-01-10 19:00:00	SPY	ETF	325.6	325.62	325.49	325.6	16149.0
2020-01-10 04:00:00	QQQ	ETF	219.56	219.86	219.56	219.86	7095.0
2020-01-10 05:00:00	QQQ	ETF	219.86	219.92	219.81	219.88	9400.0
2020-01-10 06:00:00	QQQ	ETF	219.88	220.21	219.87	220.05	48663.0
2020-01-10 07:00:00	QQQ	ETF	220.03	220.08	219.97	220.03	84755.0
2020-01-10 08:00:00	QQQ	ETF	220.04	220.16	219.5	219.78	538987.0
2020-01-10 09:00:00	QQQ	ETF	219.79	219.94	218.99	219.605	2851371.0
2020-01-10 10:00:00	QQQ	ETF	219.61	219.87	219.44	219.7334	2984366.0
2020-01-10 11:00:00	QQQ	ETF	219.73	219.87	219.1236	219.27	1710455.0
2020-01-10 12:00:00	QQQ	ETF	219.28	219.285	218.61	219.0087	2517797.0
2020-01-10 13:00:00	QQQ	ETF	219.0	219.33	218.97	219.175	1035281.0
2020-01-10 14:00:00	QQQ	ETF	219.19	219.26	218.58	218.89	1163795.0
2020-01-10 15:00:00	QQQ	ETF	218.89	218.92	218.04	218.45	3347764.0
2020-01-10 16:00:00	QQQ	ETF	218.45	218.5	218.25	218.3	2162844.0
2020-01-10 17:00:00	QQQ	ETF	218.27	218.43	218.27	218.31	34857.0
2020-01-10 18:00:00	QQQ	ETF	218.36	218.43	218.31	218.32	3515.0
2020-01-10 19:00:00	QQQ	ETF	218.33	218.5	218.31	218.37	10546.0
2020-01-10 04:00:00	IWM	ETF	165.59	165.6	165.59	165.6	400.0
2020-01-10 05:00:00	IWM	ETF	165.75	165.81	165.75	165.81	5200.0
2020-01-10 06:00:00	IWM	ETF	165.83	165.94	165.83	165.83	6900.0
2020-01-10 07:00:00	IWM	ETF	165.83	165.83	165.76	165.8	15243.0
2020-01-10 08:00:00	IWM	ETF	165.75	165.75	165.17	165.4501	113923.0
2020-01-10 09:00:00	IWM	ETF	165.47	165.66	164.63	165.47	1751569.0
2020-01-10 10:00:00	IWM	ETF	165.46	165.69	164.83	165.3	2056614.0
2020-01-10 11:00:00	IWM	ETF	165.3	165.365	164.51	164.74	1335002.0
2020-01-10 12:00:00	IWM	ETF	164.75	164.87	164.2	164.84	1251219.0
2020-01-10 13:00:00	IWM	ETF	164.83	165.41	164.82	165.35	1124410.0
2020-01-10 14:00:00	IWM	ETF	165.332	165.34	164.89	165.03	800582.0
2020-01-10 15:00:00	IWM	ETF	165.03	165.04	164.475	164.83	2512072.0
2020-01-10 16:00:00	IWM	ETF	164.82	164.89	164.62	164.62	1281462.0
2020-01-10 17:00:00	IWM	ETF	164.65	164.7	164.61	164.7	2242.0
2020-01-10 18:00:00	IWM	ETF	164.68	164.72	164.68	164.72	2850.0
2020-01-10 19:00:00	IWM	ETF	164.72	164.72	164.59	164.61	6948.0
2020-01-10 06:00:00	DIA	ETF	290.26	290.26	290.26	290.26	270.0
2020-01-10 07:00:00	DIA	ETF	290.26	290.26	290.07	290.07	1000.0

> showing 50 of 11,667 rows — these rows as CSV

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