PREVIEW / etf_30min / 2018-12-26

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-26.parquet
  size:    552 KB
  rows:    19,228

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
2018-12-26 04:00:00	SPY	ETF	234.05	234.15	233.71	234.15	10461.0
2018-12-26 04:30:00	SPY	ETF	234.1	235.1	233.83	234.95	19032.0
2018-12-26 05:00:00	SPY	ETF	234.9	235.2	234.13	234.44	76333.0
2018-12-26 05:30:00	SPY	ETF	234.6	234.87	234.11	234.42	29233.0
2018-12-26 06:00:00	SPY	ETF	234.45	235.05	234.45	234.72	103438.0
2018-12-26 06:30:00	SPY	ETF	234.8	234.87	234.44	234.7	39003.0
2018-12-26 07:00:00	SPY	ETF	234.65	235.92	234.5	235.89	149610.0
2018-12-26 07:30:00	SPY	ETF	235.89	235.95	235.3	235.8	196295.0
2018-12-26 08:00:00	SPY	ETF	234.7	235.87	231.99	235.31	589876.0
2018-12-26 08:30:00	SPY	ETF	235.33	235.43	234.63	235.22	721739.0
2018-12-26 09:00:00	SPY	ETF	235.15	236.43	234.86	235.95	1601236.0
2018-12-26 09:30:00	SPY	ETF	235.97	237.85	235.55	235.59	19106392.0
2018-12-26 10:00:00	SPY	ETF	235.59	235.95	234.06	235.15	15903885.0
2018-12-26 10:30:00	SPY	ETF	235.145	235.56	233.76	234.1	11716257.0
2018-12-26 11:00:00	SPY	ETF	234.11	236.7	234.06	236.51	11293286.0
2018-12-26 11:30:00	SPY	ETF	236.5	238.38	236.13	238.32	10482474.0
2018-12-26 12:00:00	SPY	ETF	238.32	240.21	238.21	239.05	14299732.0
2018-12-26 12:30:00	SPY	ETF	239.05	240.63	238.8	240.3566	10783061.0
2018-12-26 13:00:00	SPY	ETF	240.36	240.59	238.53	239.25	11041019.0
2018-12-26 13:30:00	SPY	ETF	239.24	241.305	239.19	241.2721	10010513.0
2018-12-26 14:00:00	SPY	ETF	241.28	241.39	239.84	240.16	13153973.0
2018-12-26 14:30:00	SPY	ETF	240.1575	241.48	240.15	241.4	8200591.0
2018-12-26 15:00:00	SPY	ETF	241.42	242.72	241.06	242.6	10803616.0
2018-12-26 15:30:00	SPY	ETF	242.61	246.0	242.41	245.945	44002843.0
2018-12-26 16:00:00	SPY	ETF	245.97	246.9	244.0844	246.01	17715841.0
2018-12-26 16:30:00	SPY	ETF	246.01	246.49	245.84	245.93	922968.0
2018-12-26 17:00:00	SPY	ETF	245.94	246.05	245.85	246.05	178419.0
2018-12-26 17:30:00	SPY	ETF	246.07	246.24	246.02	246.17	224259.0
2018-12-26 18:00:00	SPY	ETF	246.2	246.26	245.79	246.18	250039.0
2018-12-26 18:30:00	SPY	ETF	245.89	245.93	245.4	245.5	149945.0
2018-12-26 19:00:00	SPY	ETF	245.5	245.68	245.22	245.28	164893.0
2018-12-26 19:30:00	SPY	ETF	245.35	245.43	244.9	245.05	186056.0
2018-12-26 04:00:00	QQQ	ETF	143.3	143.35	142.95	143.35	7375.0
2018-12-26 04:30:00	QQQ	ETF	143.35	143.92	143.19	143.88	6772.0
2018-12-26 05:00:00	QQQ	ETF	143.8	143.8	143.36	143.51	47582.0
2018-12-26 05:30:00	QQQ	ETF	143.65	143.78	143.36	143.45	12873.0
2018-12-26 06:00:00	QQQ	ETF	143.42	143.83	143.4	143.76	20476.0
2018-12-26 06:30:00	QQQ	ETF	143.76	143.76	143.5	143.71	14593.0
2018-12-26 07:00:00	QQQ	ETF	143.66	144.61	143.66	144.59	86146.0
2018-12-26 07:30:00	QQQ	ETF	144.6	144.67	144.28	144.67	79763.0
2018-12-26 08:00:00	QQQ	ETF	144.62	144.68	141.99	144.47	129563.0
2018-12-26 08:30:00	QQQ	ETF	144.47	144.74	144.11	144.56	151280.0
2018-12-26 09:00:00	QQQ	ETF	144.54	145.37	144.31	145.07	928684.0
2018-12-26 09:30:00	QQQ	ETF	145.1	146.95	145.08	145.47	10043654.0
2018-12-26 10:00:00	QQQ	ETF	145.47	145.95	144.35	145.01	6792462.0
2018-12-26 10:30:00	QQQ	ETF	145.01	145.34	144.09	144.24	4808928.0
2018-12-26 11:00:00	QQQ	ETF	144.28	146.08	144.13	145.97	4718522.0
2018-12-26 11:30:00	QQQ	ETF	145.97	147.36	145.77	147.33	5776533.0
2018-12-26 12:00:00	QQQ	ETF	147.32	148.54	147.17	147.87	6010350.0
2018-12-26 12:30:00	QQQ	ETF	147.87	149.16	147.7	148.9391	4641133.0

> showing 50 of 19,228 rows — these rows as CSV

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