PREVIEW / etf_1hour / 2020-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-19.parquet
  size:    359 KB
  rows:    11,923

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-02-19 04:00:00	SPY	ETF	337.35	337.54	337.34	337.38	24643.0
2020-02-19 05:00:00	SPY	ETF	337.42	337.45	337.4	337.43	1412.0
2020-02-19 06:00:00	SPY	ETF	337.45	337.5	337.3	337.5	22211.0
2020-02-19 07:00:00	SPY	ETF	337.46	337.71	337.45	337.66	175652.0
2020-02-19 08:00:00	SPY	ETF	337.47	337.77	336.73	337.73	315911.0
2020-02-19 09:00:00	SPY	ETF	337.7	338.415	337.48	338.14	5819394.0
2020-02-19 10:00:00	SPY	ETF	338.14	338.51	337.94	338.43	4284370.0
2020-02-19 11:00:00	SPY	ETF	338.425	338.84	338.4	338.67	4478387.0
2020-02-19 12:00:00	SPY	ETF	338.66	338.92	338.55	338.74	2640188.0
2020-02-19 13:00:00	SPY	ETF	338.74	338.84	338.54	338.64	3152096.0
2020-02-19 14:00:00	SPY	ETF	338.64	339.08	338.48	338.86	4770389.0
2020-02-19 15:00:00	SPY	ETF	338.86	339.0	338.21	338.31	11093647.0
2020-02-19 16:00:00	SPY	ETF	338.3	338.62	338.27	338.49	10449809.0
2020-02-19 17:00:00	SPY	ETF	338.44	338.77	338.36	338.67	391972.0
2020-02-19 18:00:00	SPY	ETF	338.74	338.86	338.55	338.82	92698.0
2020-02-19 19:00:00	SPY	ETF	338.89	339.38	338.89	339.22	130295.0
2020-02-19 04:00:00	QQQ	ETF	235.36	235.62	235.36	235.48	31624.0
2020-02-19 05:00:00	QQQ	ETF	235.41	235.58	235.41	235.56	8370.0
2020-02-19 06:00:00	QQQ	ETF	235.55	235.61	235.41	235.56	22993.0
2020-02-19 07:00:00	QQQ	ETF	235.57	235.93	235.55	235.91	61262.0
2020-02-19 08:00:00	QQQ	ETF	235.6	235.9396	234.73	235.89	168220.0
2020-02-19 09:00:00	QQQ	ETF	235.87	236.71	235.85	236.58	3474125.0
2020-02-19 10:00:00	QQQ	ETF	236.56	236.8699	236.43	236.815	2243513.0
2020-02-19 11:00:00	QQQ	ETF	236.815	237.24	236.79	237.13	2394545.0
2020-02-19 12:00:00	QQQ	ETF	237.13	237.353	237.0	237.2	1292221.0
2020-02-19 13:00:00	QQQ	ETF	237.2	237.24	237.07	237.14	1036275.0
2020-02-19 14:00:00	QQQ	ETF	237.135	237.47	237.01	237.31	1776490.0
2020-02-19 15:00:00	QQQ	ETF	237.3192	237.35	236.76	236.99	3905804.0
2020-02-19 16:00:00	QQQ	ETF	236.98	237.2	236.97	237.1	2490142.0
2020-02-19 17:00:00	QQQ	ETF	237.08	237.25	237.0	237.22	41578.0
2020-02-19 18:00:00	QQQ	ETF	237.21	237.36	237.12	237.34	69815.0
2020-02-19 19:00:00	QQQ	ETF	237.39	237.79	237.39	237.67	58901.0
2020-02-19 04:00:00	IWM	ETF	167.97	168.06	167.95	167.95	7500.0
2020-02-19 05:00:00	IWM	ETF	167.95	167.95	167.95	167.95	4300.0
2020-02-19 06:00:00	IWM	ETF	167.9	167.9	167.87	167.87	1700.0
2020-02-19 07:00:00	IWM	ETF	167.96	168.08	167.96	168.08	8056.0
2020-02-19 08:00:00	IWM	ETF	167.9596	168.17	167.9596	168.17	78001.0
2020-02-19 09:00:00	IWM	ETF	168.11	168.405	168.0152	168.13	1085906.0
2020-02-19 10:00:00	IWM	ETF	168.14	168.3577	167.835	168.335	1514360.0
2020-02-19 11:00:00	IWM	ETF	168.33	168.6199	168.27	168.48	974556.0
2020-02-19 12:00:00	IWM	ETF	168.48	168.74	168.37	168.63	462609.0
2020-02-19 13:00:00	IWM	ETF	168.635	168.75	168.59	168.63	436739.0
2020-02-19 14:00:00	IWM	ETF	168.64	169.14	168.485	168.9764	2270637.0
2020-02-19 15:00:00	IWM	ETF	168.98	169.02	168.33	168.37	2290464.0
2020-02-19 16:00:00	IWM	ETF	168.37	168.63	168.36	168.51	685119.0
2020-02-19 17:00:00	IWM	ETF	168.46	168.54	168.46	168.54	917.0
2020-02-19 18:00:00	IWM	ETF	168.6	168.75	168.58	168.75	5403.0
2020-02-19 19:00:00	IWM	ETF	168.8	168.99	168.79	168.93	7450.0
2020-02-19 05:00:00	DIA	ETF	293.59	293.59	293.59	293.59	100.0
2020-02-19 07:00:00	DIA	ETF	293.59	293.7	293.59	293.7	1500.0

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

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