PREVIEW / etf_30min / 2019-07-02

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-02.parquet
  size:    500 KB
  rows:    17,623

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
2019-07-02 04:00:00	SPY	ETF	295.2	295.2	295.05	295.14	1500.0
2019-07-02 04:30:00	SPY	ETF	295.16	295.16	294.95	295.14	4206.0
2019-07-02 05:00:00	SPY	ETF	295.19	295.26	295.14	295.23	2000.0
2019-07-02 05:30:00	SPY	ETF	295.26	295.31	295.06	295.16	19474.0
2019-07-02 06:00:00	SPY	ETF	295.16	295.43	295.16	295.43	1115.0
2019-07-02 06:30:00	SPY	ETF	295.42	295.43	295.38	295.4	10545.0
2019-07-02 07:00:00	SPY	ETF	295.34	295.5	295.2	295.2	30545.0
2019-07-02 07:30:00	SPY	ETF	295.21	295.39	295.17	295.37	44560.0
2019-07-02 08:00:00	SPY	ETF	295.41	295.96	295.24	295.38	409813.0
2019-07-02 08:30:00	SPY	ETF	295.45	295.66	295.26	295.4	64192.0
2019-07-02 09:00:00	SPY	ETF	295.34	295.68	295.34	295.62	211325.0
2019-07-02 09:30:00	SPY	ETF	295.61	295.69	295.13	295.29	5082084.0
2019-07-02 10:00:00	SPY	ETF	295.3	295.92	295.24	295.91	3871536.0
2019-07-02 10:30:00	SPY	ETF	295.91	296.15	295.76	295.8765	3321674.0
2019-07-02 11:00:00	SPY	ETF	295.87	295.96	295.55	295.6001	4222464.0
2019-07-02 11:30:00	SPY	ETF	295.6	295.62	294.98	295.44	4177459.0
2019-07-02 12:00:00	SPY	ETF	295.43	295.53	294.9	294.99	2909290.0
2019-07-02 12:30:00	SPY	ETF	294.99	295.135	294.68	295.0873	4262570.0
2019-07-02 13:00:00	SPY	ETF	295.08	295.45	294.905	295.44	2016428.0
2019-07-02 13:30:00	SPY	ETF	295.445	295.67	295.3386	295.5665	3242741.0
2019-07-02 14:00:00	SPY	ETF	295.57	295.785	295.52	295.7	4357486.0
2019-07-02 14:30:00	SPY	ETF	295.7	295.88	295.44	295.52	2821813.0
2019-07-02 15:00:00	SPY	ETF	295.52	295.97	295.45	295.74	4490836.0
2019-07-02 15:30:00	SPY	ETF	295.74	296.49	295.73	296.46	8391559.0
2019-07-02 16:00:00	SPY	ETF	296.46	296.84	296.1257	296.79	5932764.0
2019-07-02 16:30:00	SPY	ETF	296.79	296.79	296.7	296.7	413212.0
2019-07-02 17:00:00	SPY	ETF	296.71	296.76	296.66	296.7	38138.0
2019-07-02 17:30:00	SPY	ETF	296.78	296.78	296.71	296.73	349103.0
2019-07-02 18:00:00	SPY	ETF	296.72	296.79	296.59	296.61	61580.0
2019-07-02 18:30:00	SPY	ETF	296.61	296.66	296.5	296.61	14532.0
2019-07-02 19:00:00	SPY	ETF	296.64	296.65	296.6	296.63	16079.0
2019-07-02 19:30:00	SPY	ETF	296.66	296.74	296.53	296.61	30852.0
2019-07-02 04:00:00	QQQ	ETF	188.85	188.86	188.65	188.65	3300.0
2019-07-02 04:30:00	QQQ	ETF	188.73	188.73	188.56	188.7	11174.0
2019-07-02 05:00:00	QQQ	ETF	188.7	188.8	188.7	188.8	4271.0
2019-07-02 05:30:00	QQQ	ETF	188.75	188.76	188.66	188.68	2171.0
2019-07-02 06:00:00	QQQ	ETF	188.64	188.87	188.64	188.87	2427.0
2019-07-02 06:30:00	QQQ	ETF	188.95	188.95	188.81	188.84	9409.0
2019-07-02 07:00:00	QQQ	ETF	188.85	188.94	188.71	188.77	18208.0
2019-07-02 07:30:00	QQQ	ETF	188.77	188.91	188.73	188.91	44030.0
2019-07-02 08:00:00	QQQ	ETF	188.94	189.35	188.79	188.9	20903.0
2019-07-02 08:30:00	QQQ	ETF	188.97	189.26	188.87	189.04	27077.0
2019-07-02 09:00:00	QQQ	ETF	189.03	189.2	189.03	189.19	91711.0
2019-07-02 09:30:00	QQQ	ETF	189.19	189.33	188.8725	189.08	1568942.0
2019-07-02 10:00:00	QQQ	ETF	189.08	189.37	188.96	189.37	1443655.0
2019-07-02 10:30:00	QQQ	ETF	189.36	189.61	189.3	189.43	1076269.0
2019-07-02 11:00:00	QQQ	ETF	189.43	189.55	189.26	189.31	862412.0
2019-07-02 11:30:00	QQQ	ETF	189.31	189.34	188.85	189.07	1060373.0
2019-07-02 12:00:00	QQQ	ETF	189.06	189.24	188.86	188.9299	899102.0
2019-07-02 12:30:00	QQQ	ETF	188.92	189.0	188.66	188.88	1157328.0

> showing 50 of 17,623 rows — these rows as CSV

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