PREVIEW / etf_30min / 2019-06-27

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-27.parquet
  size:    488 KB
  rows:    17,130

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-06-27 04:00:00	SPY	ETF	291.79	291.83	291.66	291.8	5919.0
2019-06-27 04:30:00	SPY	ETF	291.82	291.82	291.54	291.63	8683.0
2019-06-27 05:00:00	SPY	ETF	291.61	291.8	291.56	291.8	3732.0
2019-06-27 05:30:00	SPY	ETF	291.8	292.26	290.98	291.02	53949.0
2019-06-27 06:00:00	SPY	ETF	291.04	291.11	290.45	290.94	37963.0
2019-06-27 06:30:00	SPY	ETF	290.91	291.08	290.85	291.08	9048.0
2019-06-27 07:00:00	SPY	ETF	291.03	291.12	290.93	290.93	50610.0
2019-06-27 07:30:00	SPY	ETF	290.9	291.0	290.7	290.92	92823.0
2019-06-27 08:00:00	SPY	ETF	291.0199	292.0	290.82	291.17	163696.0
2019-06-27 08:30:00	SPY	ETF	291.15	291.32	291.0	291.32	129645.0
2019-06-27 09:00:00	SPY	ETF	291.32	291.44	291.19	291.32	205914.0
2019-06-27 09:30:00	SPY	ETF	291.31	291.96	291.22	291.78	4636722.0
2019-06-27 10:00:00	SPY	ETF	291.79	291.86	291.36	291.62	2412566.0
2019-06-27 10:30:00	SPY	ETF	291.63	291.83	291.26	291.54	1918018.0
2019-06-27 11:00:00	SPY	ETF	291.53	291.69	290.89	291.11	4550844.0
2019-06-27 11:30:00	SPY	ETF	291.11	291.39	290.98	291.36	1952368.0
2019-06-27 12:00:00	SPY	ETF	291.36	291.825	291.25	291.62	1696245.0
2019-06-27 12:30:00	SPY	ETF	291.63	291.9	291.63	291.72	1728141.0
2019-06-27 13:00:00	SPY	ETF	291.72	291.93	291.71	291.92	1044092.0
2019-06-27 13:30:00	SPY	ETF	291.92	292.06	291.83	291.87	1653984.0
2019-06-27 14:00:00	SPY	ETF	291.87	292.02	291.78	291.945	2066207.0
2019-06-27 14:30:00	SPY	ETF	291.945	292.05	291.63	291.68	1565866.0
2019-06-27 15:00:00	SPY	ETF	291.6733	291.81	291.56	291.6625	1578818.0
2019-06-27 15:30:00	SPY	ETF	291.66	291.93	291.47	291.54	6529859.0
2019-06-27 16:00:00	SPY	ETF	291.54	291.92	291.5	291.8	4498261.0
2019-06-27 16:30:00	SPY	ETF	291.81	292.09	291.72	292.05	653344.0
2019-06-27 17:00:00	SPY	ETF	292.06	292.17	291.5	292.13	126464.0
2019-06-27 17:30:00	SPY	ETF	292.14	292.17	292.05	292.1	30880.0
2019-06-27 18:00:00	SPY	ETF	292.06	292.42	292.06	292.3	58572.0
2019-06-27 18:30:00	SPY	ETF	292.29	292.31	292.23	292.31	22164.0
2019-06-27 19:00:00	SPY	ETF	292.29	292.29	292.21	292.23	13524.0
2019-06-27 19:30:00	SPY	ETF	292.23	292.33	292.0	292.31	70082.0
2019-06-27 04:00:00	QQQ	ETF	186.86	186.92	186.8	186.85	45020.0
2019-06-27 04:30:00	QQQ	ETF	186.89	186.89	186.59	186.68	20456.0
2019-06-27 05:00:00	QQQ	ETF	186.67	186.84	186.66	186.82	2743.0
2019-06-27 05:30:00	QQQ	ETF	186.83	187.2	186.24	186.39	45775.0
2019-06-27 06:00:00	QQQ	ETF	186.33	186.33	185.73	186.12	42896.0
2019-06-27 06:30:00	QQQ	ETF	186.1	186.21	186.01	186.18	16200.0
2019-06-27 07:00:00	QQQ	ETF	186.18	186.29	186.15	186.17	224093.0
2019-06-27 07:30:00	QQQ	ETF	186.17	186.25	185.89	186.19	44701.0
2019-06-27 08:00:00	QQQ	ETF	186.23	186.86	186.0601	186.38	89909.0
2019-06-27 08:30:00	QQQ	ETF	186.44	186.69	186.32	186.67	116352.0
2019-06-27 09:00:00	QQQ	ETF	186.66	186.68	186.47	186.47	69566.0
2019-06-27 09:30:00	QQQ	ETF	186.47	186.94	186.31	186.722	2420180.0
2019-06-27 10:00:00	QQQ	ETF	186.73	186.89	186.4308	186.68	1404303.0
2019-06-27 10:30:00	QQQ	ETF	186.68	186.8	186.35	186.63	1020667.0
2019-06-27 11:00:00	QQQ	ETF	186.63	186.7631	186.08	186.17	1882688.0
2019-06-27 11:30:00	QQQ	ETF	186.17	186.29	185.99	186.28	825198.0
2019-06-27 12:00:00	QQQ	ETF	186.28	186.69	186.2	186.58	836035.0
2019-06-27 12:30:00	QQQ	ETF	186.59	186.8199	186.57	186.62	433234.0

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

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