PREVIEW / etf_30min / 2018-12-24

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-24.parquet
  size:    352 KB
  rows:    11,612

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-24 04:00:00	SPY	ETF	241.7	241.86	241.32	241.36	20408.0
2018-12-24 04:30:00	SPY	ETF	241.48	241.6	241.17	241.6	45702.0
2018-12-24 05:00:00	SPY	ETF	241.52	241.78	241.4	241.78	5469.0
2018-12-24 05:30:00	SPY	ETF	241.54	241.71	241.43	241.71	37479.0
2018-12-24 06:00:00	SPY	ETF	241.72	241.85	241.62	241.62	34013.0
2018-12-24 06:30:00	SPY	ETF	241.56	241.72	241.15	241.15	16801.0
2018-12-24 07:00:00	SPY	ETF	241.06	241.06	238.76	239.2	548052.0
2018-12-24 07:30:00	SPY	ETF	239.2	239.67	238.44	238.44	274463.0
2018-12-24 08:00:00	SPY	ETF	240.63	242.45	238.25	239.75	1529374.0
2018-12-24 08:30:00	SPY	ETF	239.75	239.85	238.8	238.95	1063935.0
2018-12-24 09:00:00	SPY	ETF	238.96	239.7	238.88	239.06	990898.0
2018-12-24 09:30:00	SPY	ETF	239.04	240.0	236.57	237.3785	21915506.0
2018-12-24 10:00:00	SPY	ETF	237.37	238.0	235.9	237.66	18001819.0
2018-12-24 10:30:00	SPY	ETF	237.67	240.8355	237.67	238.6175	17629695.0
2018-12-24 11:00:00	SPY	ETF	238.63	239.16	236.671	236.97	15128085.0
2018-12-24 11:30:00	SPY	ETF	236.96	237.74	236.02	236.36	12257433.0
2018-12-24 12:00:00	SPY	ETF	236.36	240.8355	235.4811	236.205	15725646.0
2018-12-24 12:30:00	SPY	ETF	236.21	236.74	234.31	234.33	22637593.0
2018-12-24 13:00:00	SPY	ETF	234.41	240.8355	233.15	233.61	6414664.0
2018-12-24 13:30:00	SPY	ETF	233.65	234.34	233.16	233.2	2036422.0
2018-12-24 14:00:00	SPY	ETF	233.2	233.34	232.8	232.85	374086.0
2018-12-24 14:30:00	SPY	ETF	232.9	234.34	232.61	233.1	149764.0
2018-12-24 15:00:00	SPY	ETF	233.14	233.24	233.07	233.1	35059.0
2018-12-24 15:30:00	SPY	ETF	233.05	233.17	233.0	233.07	71783.0
2018-12-24 16:00:00	SPY	ETF	233.09	233.24	233.0	233.02	10351.0
2018-12-24 16:30:00	SPY	ETF	233.02	233.1	233.0	233.08	35744.0
2018-12-24 04:00:00	QQQ	ETF	148.0	148.32	147.85	147.85	7375.0
2018-12-24 04:30:00	QQQ	ETF	148.02	148.2	147.88	148.19	11300.0
2018-12-24 05:00:00	QQQ	ETF	148.16	148.29	148.06	148.17	5950.0
2018-12-24 05:30:00	QQQ	ETF	148.01	148.13	148.0	148.13	5150.0
2018-12-24 06:00:00	QQQ	ETF	148.18	148.47	148.18	148.26	6445.0
2018-12-24 06:30:00	QQQ	ETF	148.21	148.23	147.84	147.84	21300.0
2018-12-24 07:00:00	QQQ	ETF	147.82	147.84	146.27	146.47	115153.0
2018-12-24 07:30:00	QQQ	ETF	146.54	146.71	145.65	145.65	119512.0
2018-12-24 08:00:00	QQQ	ETF	147.56	148.5	145.59	146.37	217697.0
2018-12-24 08:30:00	QQQ	ETF	146.31	146.61	145.84	146.0	202258.0
2018-12-24 09:00:00	QQQ	ETF	146.01	146.61	145.96	146.15	527761.0
2018-12-24 09:30:00	QQQ	ETF	146.14	147.2	144.21	144.97	9238098.0
2018-12-24 10:00:00	QQQ	ETF	144.9688	145.98	144.25	145.86	6392721.0
2018-12-24 10:30:00	QQQ	ETF	145.87	147.98	145.78	146.99	5643376.0
2018-12-24 11:00:00	QQQ	ETF	147.0	147.37	145.68	145.8399	3492994.0
2018-12-24 11:30:00	QQQ	ETF	145.82	146.295	144.92	145.16	3736414.0
2018-12-24 12:00:00	QQQ	ETF	145.16	145.7	144.56	145.0	4896011.0
2018-12-24 12:30:00	QQQ	ETF	145.02	145.3532	143.52	143.53	7811452.0
2018-12-24 13:00:00	QQQ	ETF	143.54	144.0858	142.91	143.15	2646984.0
2018-12-24 13:30:00	QQQ	ETF	143.2	143.39	142.81	142.85	71003.0
2018-12-24 14:00:00	QQQ	ETF	142.85	143.5	142.61	142.65	87404.0
2018-12-24 14:30:00	QQQ	ETF	142.61	142.9	142.52	142.79	30279.0
2018-12-24 15:00:00	QQQ	ETF	142.9	142.92	142.65	142.92	13024.0
2018-12-24 15:30:00	QQQ	ETF	142.85	142.95	142.71	142.71	10575.0

> showing 50 of 11,612 rows — these rows as CSV

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