PREVIEW / etf_30min / 2019-08-02

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-02.parquet
  size:    520 KB
  rows:    18,336

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-08-02 04:00:00	SPY	ETF	293.26	293.63	293.26	293.31	5090.0
2019-08-02 04:30:00	SPY	ETF	293.5	293.54	293.1	293.34	4552.0
2019-08-02 05:00:00	SPY	ETF	293.39	293.5	292.99	293.5	7048.0
2019-08-02 05:30:00	SPY	ETF	293.5	293.6	293.39	293.49	8579.0
2019-08-02 06:00:00	SPY	ETF	293.52	294.09	293.52	293.96	36492.0
2019-08-02 06:30:00	SPY	ETF	293.96	294.19	293.74	293.96	27639.0
2019-08-02 07:00:00	SPY	ETF	294.0	294.0	293.6	293.69	57025.0
2019-08-02 07:30:00	SPY	ETF	293.69	293.85	293.54	293.68	325529.0
2019-08-02 08:00:00	SPY	ETF	294.525	294.84	293.2	293.96	628299.0
2019-08-02 08:30:00	SPY	ETF	293.82	293.94	292.9	293.91	988416.0
2019-08-02 09:00:00	SPY	ETF	293.92	295.6	293.71	293.87	2320287.0
2019-08-02 09:30:00	SPY	ETF	293.85	294.12	292.7	292.95	11043089.0
2019-08-02 10:00:00	SPY	ETF	292.93	293.32	291.92	292.43	9707178.0
2019-08-02 10:30:00	SPY	ETF	292.42	292.44	290.97	291.02	7782091.0
2019-08-02 11:00:00	SPY	ETF	291.02	292.46	290.9	291.81	7344593.0
2019-08-02 11:30:00	SPY	ETF	291.81	292.14	291.22	292.02	5616705.0
2019-08-02 12:00:00	SPY	ETF	292.02	292.89	291.83	292.83	5011096.0
2019-08-02 12:30:00	SPY	ETF	292.82	292.8884	291.8	291.83	3811785.0
2019-08-02 13:00:00	SPY	ETF	291.82	291.89	291.34	291.52	4298756.0
2019-08-02 13:30:00	SPY	ETF	291.525	291.82	291.2	291.52	3323290.0
2019-08-02 14:00:00	SPY	ETF	291.52	292.67	291.34	292.22	5561283.0
2019-08-02 14:30:00	SPY	ETF	292.22	292.55	291.87	292.275	5480222.0
2019-08-02 15:00:00	SPY	ETF	292.275	293.03	291.68	292.84	5506076.0
2019-08-02 15:30:00	SPY	ETF	292.84	294.01	292.26	292.76	21143602.0
2019-08-02 16:00:00	SPY	ETF	292.73	292.99	292.43	292.7	13621907.0
2019-08-02 16:30:00	SPY	ETF	292.71	293.05	292.62	292.99	930541.0
2019-08-02 17:00:00	SPY	ETF	292.95	293.02	292.8	292.85	63514.0
2019-08-02 17:30:00	SPY	ETF	292.88	292.88	292.67	292.85	105285.0
2019-08-02 18:00:00	SPY	ETF	292.85	292.88	292.76	292.88	57465.0
2019-08-02 18:30:00	SPY	ETF	292.88	292.88	292.8	292.85	3042.0
2019-08-02 19:00:00	SPY	ETF	292.88	292.89	292.81	292.89	7882.0
2019-08-02 19:30:00	SPY	ETF	292.89	292.95	292.83	292.95	14415.0
2019-08-02 04:00:00	QQQ	ETF	188.8	188.84	188.43	188.54	22545.0
2019-08-02 04:30:00	QQQ	ETF	188.6	188.92	188.39	188.65	23079.0
2019-08-02 05:00:00	QQQ	ETF	188.54	188.65	188.25	188.65	43250.0
2019-08-02 05:30:00	QQQ	ETF	188.69	188.8	188.53	188.65	7600.0
2019-08-02 06:00:00	QQQ	ETF	188.64	189.18	188.64	188.99	36236.0
2019-08-02 06:30:00	QQQ	ETF	189.01	189.24	188.91	189.04	45354.0
2019-08-02 07:00:00	QQQ	ETF	189.06	189.06	188.72	188.89	30744.0
2019-08-02 07:30:00	QQQ	ETF	188.83	188.89	188.65	188.75	84592.0
2019-08-02 08:00:00	QQQ	ETF	188.72	189.61	188.6001	188.89	151448.0
2019-08-02 08:30:00	QQQ	ETF	188.91	189.0	188.02	188.79	530826.0
2019-08-02 09:00:00	QQQ	ETF	188.79	189.89	188.6	188.83	1958643.0
2019-08-02 09:30:00	QQQ	ETF	188.82	188.99	187.86	188.08	5509819.0
2019-08-02 10:00:00	QQQ	ETF	188.1	188.48	187.125	187.4484	5167702.0
2019-08-02 10:30:00	QQQ	ETF	187.43	187.43	186.26	186.32	4584780.0
2019-08-02 11:00:00	QQQ	ETF	186.32	187.4	186.3	186.98	3491072.0
2019-08-02 11:30:00	QQQ	ETF	186.99	187.21	186.36	186.95	2142835.0
2019-08-02 12:00:00	QQQ	ETF	186.94	187.6	186.72	187.57	2961453.0
2019-08-02 12:30:00	QQQ	ETF	187.56	187.6253	186.7	186.76	2541991.0

> showing 50 of 18,336 rows — these rows as CSV

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