PREVIEW / etf_30min / 2019-08-22

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-22.parquet
  size:    498 KB
  rows:    17,328

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-22 04:00:00	SPY	ETF	293.17	293.24	292.49	292.49	16178.0
2019-08-22 04:30:00	SPY	ETF	292.44	292.8	292.22	292.6	30062.0
2019-08-22 05:00:00	SPY	ETF	292.52	292.61	292.0	292.01	15795.0
2019-08-22 05:30:00	SPY	ETF	292.07	292.13	291.85	292.08	7338.0
2019-08-22 06:00:00	SPY	ETF	292.24	292.5	292.16	292.37	4644.0
2019-08-22 06:30:00	SPY	ETF	292.4	292.52	292.32	292.32	76905.0
2019-08-22 07:00:00	SPY	ETF	292.42	293.05	292.37	292.98	91630.0
2019-08-22 07:30:00	SPY	ETF	292.97	293.4	292.89	293.27	134320.0
2019-08-22 08:00:00	SPY	ETF	292.39	293.45	291.95	293.39	290889.0
2019-08-22 08:30:00	SPY	ETF	293.36	293.73	293.18	293.5	224755.0
2019-08-22 09:00:00	SPY	ETF	293.5499	293.55	293.17	293.25	291497.0
2019-08-22 09:30:00	SPY	ETF	293.23	293.93	293.16	293.47	5311649.0
2019-08-22 10:00:00	SPY	ETF	293.47	293.5	291.98	292.1399	4369559.0
2019-08-22 10:30:00	SPY	ETF	292.13	292.13	290.4	290.58	7371684.0
2019-08-22 11:00:00	SPY	ETF	290.58	291.68	290.57	291.3099	4212820.0
2019-08-22 11:30:00	SPY	ETF	291.31	291.89	291.28	291.49	2156655.0
2019-08-22 12:00:00	SPY	ETF	291.5	292.2385	291.45	291.97	2453731.0
2019-08-22 12:30:00	SPY	ETF	291.99	292.34	291.8206	292.015	2471905.0
2019-08-22 13:00:00	SPY	ETF	292.015	292.73	292.005	292.61	2223616.0
2019-08-22 13:30:00	SPY	ETF	292.61	292.84	292.53	292.6	2319571.0
2019-08-22 14:00:00	SPY	ETF	292.61	292.76	292.311	292.34	1676638.0
2019-08-22 14:30:00	SPY	ETF	292.36	292.96	292.2738	292.86	2531735.0
2019-08-22 15:00:00	SPY	ETF	292.865	292.93	292.2	292.5	2169049.0
2019-08-22 15:30:00	SPY	ETF	292.48	293.24	292.13	292.31	6598359.0
2019-08-22 16:00:00	SPY	ETF	292.3	292.46	292.08	292.12	2884680.0
2019-08-22 16:30:00	SPY	ETF	292.11	292.4285	291.96	292.01	568005.0
2019-08-22 17:00:00	SPY	ETF	292.04	292.15	291.95	292.08	41192.0
2019-08-22 17:30:00	SPY	ETF	292.09	292.09	292.0	292.02	33482.0
2019-08-22 18:00:00	SPY	ETF	292.06	292.36	292.06	292.24	81137.0
2019-08-22 18:30:00	SPY	ETF	292.24	292.35	292.11	292.11	17224.0
2019-08-22 19:00:00	SPY	ETF	292.2	292.25	292.07	292.07	5357.0
2019-08-22 19:30:00	SPY	ETF	292.02	292.24	291.88	292.18	23422.0
2019-08-22 04:00:00	QQQ	ETF	189.04	189.04	188.48	188.48	23137.0
2019-08-22 04:30:00	QQQ	ETF	188.43	188.47	188.24	188.46	12122.0
2019-08-22 05:00:00	QQQ	ETF	188.48	188.48	187.97	187.99	29945.0
2019-08-22 05:30:00	QQQ	ETF	187.98	188.1	187.83	188.1	25110.0
2019-08-22 06:00:00	QQQ	ETF	188.09	188.39	188.09	188.35	22922.0
2019-08-22 06:30:00	QQQ	ETF	188.35	188.45	188.25	188.31	13789.0
2019-08-22 07:00:00	QQQ	ETF	188.35	188.84	188.27	188.8	78592.0
2019-08-22 07:30:00	QQQ	ETF	188.8	189.17	188.75	189.12	70484.0
2019-08-22 08:00:00	QQQ	ETF	188.3299	189.5	188.28	189.06	128729.0
2019-08-22 08:30:00	QQQ	ETF	189.07	189.42	188.94	189.21	117317.0
2019-08-22 09:00:00	QQQ	ETF	189.24	189.27	188.9	188.98	89666.0
2019-08-22 09:30:00	QQQ	ETF	188.98	189.46	188.92	189.21	1938059.0
2019-08-22 10:00:00	QQQ	ETF	189.23	189.23	187.75	187.91	1619094.0
2019-08-22 10:30:00	QQQ	ETF	187.9	187.9	186.54	186.68	4217522.0
2019-08-22 11:00:00	QQQ	ETF	186.71	187.54	186.64	187.27	1684273.0
2019-08-22 11:30:00	QQQ	ETF	187.275	187.69	187.21	187.2701	959397.0
2019-08-22 12:00:00	QQQ	ETF	187.28	187.82	187.24	187.67	665521.0
2019-08-22 12:30:00	QQQ	ETF	187.68	187.94	187.51	187.7	1609597.0

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

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