PREVIEW / etf_30min / 2019-08-30

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-30.parquet
  size:    497 KB
  rows:    17,282

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-30 04:00:00	SPY	ETF	293.52	293.74	293.51	293.7	5811.0
2019-08-30 04:30:00	SPY	ETF	293.7	294.24	293.7	294.15	28402.0
2019-08-30 05:00:00	SPY	ETF	294.12	294.36	294.1	294.36	14582.0
2019-08-30 05:30:00	SPY	ETF	294.38	294.71	294.29	294.71	29962.0
2019-08-30 06:00:00	SPY	ETF	294.61	294.67	294.41	294.54	43834.0
2019-08-30 06:30:00	SPY	ETF	294.51	294.64	294.48	294.61	41666.0
2019-08-30 07:00:00	SPY	ETF	294.58	294.67	294.17	294.22	200776.0
2019-08-30 07:30:00	SPY	ETF	294.22	294.56	294.18	294.54	112575.0
2019-08-30 08:00:00	SPY	ETF	294.64	294.66	292.65	294.5	203616.0
2019-08-30 08:30:00	SPY	ETF	294.47	294.5658	294.32	294.39	109849.0
2019-08-30 09:00:00	SPY	ETF	294.38	294.44	294.08	294.19	285859.0
2019-08-30 09:30:00	SPY	ETF	294.22	294.2399	293.46	293.66	5292978.0
2019-08-30 10:00:00	SPY	ETF	293.67	294.18	293.28	293.44	4235272.0
2019-08-30 10:30:00	SPY	ETF	293.4328	293.725	293.07	293.07	2515804.0
2019-08-30 11:00:00	SPY	ETF	293.05	293.18	291.42	291.7799	6186958.0
2019-08-30 11:30:00	SPY	ETF	291.775	292.63	291.75	292.39	3337087.0
2019-08-30 12:00:00	SPY	ETF	292.38	292.75	292.165	292.695	2142423.0
2019-08-30 12:30:00	SPY	ETF	292.695	293.02	292.49	292.87	2494404.0
2019-08-30 13:00:00	SPY	ETF	292.86	292.97	292.37	292.49	2479421.0
2019-08-30 13:30:00	SPY	ETF	292.5	292.59	292.18	292.3921	2222735.0
2019-08-30 14:00:00	SPY	ETF	292.38	292.79	292.38	292.675	2684387.0
2019-08-30 14:30:00	SPY	ETF	292.675	292.78	292.0	292.15	2940001.0
2019-08-30 15:00:00	SPY	ETF	292.16	292.45	291.72	292.33	4003785.0
2019-08-30 15:30:00	SPY	ETF	292.34	293.06	292.18	292.46	11206679.0
2019-08-30 16:00:00	SPY	ETF	292.48	292.7613	292.08	292.22	7361395.0
2019-08-30 16:30:00	SPY	ETF	292.22	292.5	292.17	292.48	332003.0
2019-08-30 17:00:00	SPY	ETF	292.45	292.45	292.19	292.36	648299.0
2019-08-30 17:30:00	SPY	ETF	292.36	292.75	292.36	292.57	86485.0
2019-08-30 18:00:00	SPY	ETF	292.57	292.57	292.29	292.4	64746.0
2019-08-30 18:30:00	SPY	ETF	292.42	292.42	292.34	292.39	37356.0
2019-08-30 19:00:00	SPY	ETF	292.36	292.42	292.34	292.42	3999.0
2019-08-30 19:30:00	SPY	ETF	292.36	292.43	292.3	292.3	14853.0
2019-08-30 04:00:00	QQQ	ETF	188.6	188.79	188.53	188.79	11957.0
2019-08-30 04:30:00	QQQ	ETF	188.75	189.02	188.73	189.0	49224.0
2019-08-30 05:00:00	QQQ	ETF	189.04	189.2	189.01	189.2	29118.0
2019-08-30 05:30:00	QQQ	ETF	189.2	189.44	189.1	189.43	30316.0
2019-08-30 06:00:00	QQQ	ETF	189.4	189.41	189.16	189.28	26580.0
2019-08-30 06:30:00	QQQ	ETF	189.2	189.37	189.13	189.37	10650.0
2019-08-30 07:00:00	QQQ	ETF	189.36	189.36	188.97	189.0	148981.0
2019-08-30 07:30:00	QQQ	ETF	189.02	189.25	188.97	189.19	173773.0
2019-08-30 08:00:00	QQQ	ETF	189.06	189.35	187.62	189.1799	43335.0
2019-08-30 08:30:00	QQQ	ETF	189.13	189.21	189.01	189.08	46406.0
2019-08-30 09:00:00	QQQ	ETF	189.04	189.1	188.83	188.94	81504.0
2019-08-30 09:30:00	QQQ	ETF	188.94	188.97	188.24	188.41	2159984.0
2019-08-30 10:00:00	QQQ	ETF	188.42	188.7	187.765	187.92	1528409.0
2019-08-30 10:30:00	QQQ	ETF	187.93	188.23	187.767	187.767	994259.0
2019-08-30 11:00:00	QQQ	ETF	187.75	187.87	186.41	186.7899	4250608.0
2019-08-30 11:30:00	QQQ	ETF	186.78	187.305	186.77	187.14	1339335.0
2019-08-30 12:00:00	QQQ	ETF	187.15	187.3	186.83	187.22	1231516.0
2019-08-30 12:30:00	QQQ	ETF	187.23	187.36	187.02	187.2165	1018809.0

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

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