PREVIEW / etf_30min / 2020-07-02

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-02.parquet
  size:    549 KB
  rows:    20,589

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-07-02 04:00:00	SPY	ETF	312.0	312.93	312.0	312.74	35665.0
2020-07-02 04:30:00	SPY	ETF	312.74	313.13	312.53	312.53	16246.0
2020-07-02 05:00:00	SPY	ETF	312.51	312.68	312.33	312.62	15878.0
2020-07-02 05:30:00	SPY	ETF	312.36	312.36	312.02	312.31	9561.0
2020-07-02 06:00:00	SPY	ETF	312.3	312.3	311.96	312.18	10876.0
2020-07-02 06:30:00	SPY	ETF	312.08	312.63	312.06	312.6	110020.0
2020-07-02 07:00:00	SPY	ETF	312.55	312.95	312.5	312.67	75674.0
2020-07-02 07:30:00	SPY	ETF	312.74	312.88	312.7	312.85	71921.0
2020-07-02 08:00:00	SPY	ETF	312.6001	312.94	309.7733	312.66	528977.0
2020-07-02 08:30:00	SPY	ETF	312.69	314.74	312.6	314.7	1751473.0
2020-07-02 09:00:00	SPY	ETF	314.67	314.79	314.21	314.251	432570.0
2020-07-02 09:30:00	SPY	ETF	314.24	315.4767	314.14	315.37	7848935.0
2020-07-02 10:00:00	SPY	ETF	315.385	315.7	313.56	313.61	5581854.0
2020-07-02 10:30:00	SPY	ETF	313.612	314.33	312.78	312.91	5523499.0
2020-07-02 11:00:00	SPY	ETF	312.91	313.13	312.04	312.83	4036305.0
2020-07-02 11:30:00	SPY	ETF	312.86	313.85	312.79	313.61	2840773.0
2020-07-02 12:00:00	SPY	ETF	313.61	313.71	312.86	313.69	2542928.0
2020-07-02 12:30:00	SPY	ETF	313.7	313.8	313.23	313.7075	2227282.0
2020-07-02 13:00:00	SPY	ETF	313.7	313.76	313.38	313.63	1473775.0
2020-07-02 13:30:00	SPY	ETF	313.6212	314.2	313.57	313.76	3379068.0
2020-07-02 14:00:00	SPY	ETF	313.76	314.16	313.51	314.06	2744073.0
2020-07-02 14:30:00	SPY	ETF	314.07	314.4	313.94	314.09	3116219.0
2020-07-02 15:00:00	SPY	ETF	314.09	314.21	313.25	313.3001	3821997.0
2020-07-02 15:30:00	SPY	ETF	313.32	313.47	311.51	312.18	13813086.0
2020-07-02 16:00:00	SPY	ETF	312.18	313.02	311.8239	312.74	5396025.0
2020-07-02 16:30:00	SPY	ETF	312.87	312.95	312.23	312.58	290061.0
2020-07-02 17:00:00	SPY	ETF	312.52	312.61	312.38	312.58	522057.0
2020-07-02 17:30:00	SPY	ETF	312.57	312.69	312.45	312.45	46920.0
2020-07-02 18:00:00	SPY	ETF	312.5	312.95	312.43	312.89	62614.0
2020-07-02 18:30:00	SPY	ETF	312.82	313.18	312.78	312.98	57217.0
2020-07-02 19:00:00	SPY	ETF	313.03	313.15	312.9	312.9	22692.0
2020-07-02 19:30:00	SPY	ETF	312.9	313.08	312.7	312.8	34216.0
2020-07-02 04:00:00	QQQ	ETF	250.59	252.0	250.32	252.0	17386.0
2020-07-02 04:30:00	QQQ	ETF	251.95	252.03	251.84	251.88	7387.0
2020-07-02 05:00:00	QQQ	ETF	251.74	251.87	251.7	251.78	5920.0
2020-07-02 05:30:00	QQQ	ETF	251.61	251.62	251.45	251.52	2023.0
2020-07-02 06:00:00	QQQ	ETF	251.65	251.65	251.41	251.43	4335.0
2020-07-02 06:30:00	QQQ	ETF	251.37	251.63	251.37	251.62	9720.0
2020-07-02 07:00:00	QQQ	ETF	251.61	251.95	251.58	251.76	55788.0
2020-07-02 07:30:00	QQQ	ETF	251.77	252.24	251.76	252.22	36838.0
2020-07-02 08:00:00	QQQ	ETF	251.5204	252.32	250.92	251.95	159450.0
2020-07-02 08:30:00	QQQ	ETF	252.14	253.25	252.14	253.1	529217.0
2020-07-02 09:00:00	QQQ	ETF	253.1	253.24	252.91	252.95	144213.0
2020-07-02 09:30:00	QQQ	ETF	252.97	254.22	252.93	254.08	3817286.0
2020-07-02 10:00:00	QQQ	ETF	254.075	254.27	252.79	252.855	2629661.0
2020-07-02 10:30:00	QQQ	ETF	252.86	253.84	252.705	253.04	2636313.0
2020-07-02 11:00:00	QQQ	ETF	253.03	253.135	251.99	252.21	2150041.0
2020-07-02 11:30:00	QQQ	ETF	252.23	253.41	252.13	253.3	1581699.0
2020-07-02 12:00:00	QQQ	ETF	253.3	253.55	252.74	253.45	1442216.0
2020-07-02 12:30:00	QQQ	ETF	253.46	253.55	253.02	253.43	874566.0

> showing 50 of 20,589 rows — these rows as CSV

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