PREVIEW / etf_1hour / 2020-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-14.parquet
  size:    353 KB
  rows:    11,548

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-14 04:00:00	SPY	ETF	337.75	337.85	337.61	337.78	14367.0
2020-02-14 05:00:00	SPY	ETF	337.86	338.04	337.86	337.91	17467.0
2020-02-14 06:00:00	SPY	ETF	337.95	337.98	337.8	337.98	5270.0
2020-02-14 07:00:00	SPY	ETF	337.91	338.24	337.91	338.14	350908.0
2020-02-14 08:00:00	SPY	ETF	338.13	338.2	337.27	337.48	413348.0
2020-02-14 09:00:00	SPY	ETF	337.48	337.69	336.92	337.03	3891965.0
2020-02-14 10:00:00	SPY	ETF	337.03	337.54	336.68	337.51	4459671.0
2020-02-14 11:00:00	SPY	ETF	337.51	337.73	337.23	337.29	3018070.0
2020-02-14 12:00:00	SPY	ETF	337.28	337.3667	336.655	336.8	5235276.0
2020-02-14 13:00:00	SPY	ETF	336.81	337.0	336.49	336.59	8606195.0
2020-02-14 14:00:00	SPY	ETF	336.58	337.24	336.2	336.88	13213048.0
2020-02-14 15:00:00	SPY	ETF	336.87	337.61	336.54	337.6	13159737.0
2020-02-14 16:00:00	SPY	ETF	337.6	337.86	337.56	337.7	11642692.0
2020-02-14 17:00:00	SPY	ETF	337.7	337.79	337.54	337.66	127638.0
2020-02-14 18:00:00	SPY	ETF	337.66	337.87	337.6	337.74	29876.0
2020-02-14 19:00:00	SPY	ETF	337.72	337.86	337.69	337.8	26586.0
2020-02-14 04:00:00	QQQ	ETF	234.62	234.72	234.47	234.72	20540.0
2020-02-14 05:00:00	QQQ	ETF	234.69	234.85	234.68	234.81	14895.0
2020-02-14 06:00:00	QQQ	ETF	234.78	234.78	234.6	234.72	19901.0
2020-02-14 07:00:00	QQQ	ETF	234.77	235.01	234.77	234.95	244074.0
2020-02-14 08:00:00	QQQ	ETF	234.85	234.98	234.2	234.44	414475.0
2020-02-14 09:00:00	QQQ	ETF	234.37	234.81	233.92	234.07	2178858.0
2020-02-14 10:00:00	QQQ	ETF	234.08	234.766	233.68	234.74	2631182.0
2020-02-14 11:00:00	QQQ	ETF	234.74	234.86	234.3646	234.43	1452995.0
2020-02-14 12:00:00	QQQ	ETF	234.42	234.5	233.74	233.9173	1721737.0
2020-02-14 13:00:00	QQQ	ETF	233.91	234.13	233.71	233.82	1540872.0
2020-02-14 14:00:00	QQQ	ETF	233.8	234.39	233.5501	234.145	2054866.0
2020-02-14 15:00:00	QQQ	ETF	234.135	234.57	233.83	234.56	3644833.0
2020-02-14 16:00:00	QQQ	ETF	234.56	234.7	234.48	234.6	1496656.0
2020-02-14 17:00:00	QQQ	ETF	234.66	234.68	234.52	234.6	157885.0
2020-02-14 18:00:00	QQQ	ETF	234.55	234.64	234.53	234.64	11002.0
2020-02-14 19:00:00	QQQ	ETF	234.64	234.64	234.58	234.5999	11640.0
2020-02-14 04:00:00	IWM	ETF	169.0	169.0	168.98	168.98	500.0
2020-02-14 05:00:00	IWM	ETF	169.07	169.1	169.06	169.1	3382.0
2020-02-14 06:00:00	IWM	ETF	168.99	168.99	168.99	168.99	1264.0
2020-02-14 07:00:00	IWM	ETF	169.11	169.21	169.1	169.21	15600.0
2020-02-14 08:00:00	IWM	ETF	169.18	169.18	168.64	168.82	28592.0
2020-02-14 09:00:00	IWM	ETF	168.82	168.8901	168.12	168.29	1984630.0
2020-02-14 10:00:00	IWM	ETF	168.27	168.46	167.86	168.18	2509277.0
2020-02-14 11:00:00	IWM	ETF	168.17	168.46	168.11	168.15	1031293.0
2020-02-14 12:00:00	IWM	ETF	168.14	168.23	167.74	167.86	1237285.0
2020-02-14 13:00:00	IWM	ETF	167.83	167.96	167.5	167.575	1514416.0
2020-02-14 14:00:00	IWM	ETF	167.58	167.86	167.34	167.53	1759413.0
2020-02-14 15:00:00	IWM	ETF	167.52	167.965	167.49	167.91	2387458.0
2020-02-14 16:00:00	IWM	ETF	167.91	167.97	167.83	167.9	653678.0
2020-02-14 17:00:00	IWM	ETF	167.95	167.95	167.87	167.87	13700.0
2020-02-14 18:00:00	IWM	ETF	167.82	167.9	167.81	167.87	2522.0
2020-02-14 19:00:00	IWM	ETF	167.91	167.91	167.91	167.91	100.0
2020-02-14 06:00:00	DIA	ETF	295.3	295.3	295.3	295.3	400.0
2020-02-14 07:00:00	DIA	ETF	295.41	295.48	295.27	295.45	1200.0

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

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