PREVIEW / etf_30min / 2018-12-28

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-28.parquet
  size:    543 KB
  rows:    18,959

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-28 04:00:00	SPY	ETF	248.9	248.95	248.58	248.77	27029.0
2018-12-28 04:30:00	SPY	ETF	248.82	249.28	248.66	249.28	22136.0
2018-12-28 05:00:00	SPY	ETF	249.25	249.9	249.25	249.77	81297.0
2018-12-28 05:30:00	SPY	ETF	249.82	250.32	249.76	250.09	77006.0
2018-12-28 06:00:00	SPY	ETF	250.1	250.74	249.39	250.72	128092.0
2018-12-28 06:30:00	SPY	ETF	250.77	251.16	250.02	250.02	163230.0
2018-12-28 07:00:00	SPY	ETF	250.02	250.31	249.37	249.93	306382.0
2018-12-28 07:30:00	SPY	ETF	249.9	250.14	249.14	249.81	134604.0
2018-12-28 08:00:00	SPY	ETF	249.55	250.14	247.6	249.47	343049.0
2018-12-28 08:30:00	SPY	ETF	249.4599	249.93	249.24	249.92	349891.0
2018-12-28 09:00:00	SPY	ETF	249.88	249.89	249.25	249.54	837772.0
2018-12-28 09:30:00	SPY	ETF	249.58	250.11	248.31	249.46	17601366.0
2018-12-28 10:00:00	SPY	ETF	249.47	249.72	247.46	247.63	10154707.0
2018-12-28 10:30:00	SPY	ETF	247.62	248.47	246.45	247.555	9141219.0
2018-12-28 11:00:00	SPY	ETF	247.56	248.53	247.05	248.0582	7204614.0
2018-12-28 11:30:00	SPY	ETF	248.07	249.02	247.7289	248.55	6196016.0
2018-12-28 12:00:00	SPY	ETF	248.55	249.32	248.1	248.7166	5721854.0
2018-12-28 12:30:00	SPY	ETF	248.71	249.32	248.04	248.17	4733682.0
2018-12-28 13:00:00	SPY	ETF	248.18	248.87	247.61	247.85	5293518.0
2018-12-28 13:30:00	SPY	ETF	247.83	249.0	247.37	248.57	6198669.0
2018-12-28 14:00:00	SPY	ETF	248.58	250.45	248.575	249.5	10291027.0
2018-12-28 14:30:00	SPY	ETF	249.495	251.4	249.4	251.04	12773006.0
2018-12-28 15:00:00	SPY	ETF	251.06	251.255	247.38	247.92	17891449.0
2018-12-28 15:30:00	SPY	ETF	247.93	250.4074	246.9	247.81	23032586.0
2018-12-28 16:00:00	SPY	ETF	247.81	248.02	247.27	247.75	9430488.0
2018-12-28 16:30:00	SPY	ETF	247.78	248.06	247.66	247.86	2848616.0
2018-12-28 17:00:00	SPY	ETF	247.86	247.99	247.77	247.89	55194.0
2018-12-28 17:30:00	SPY	ETF	247.9	247.95	247.34	247.58	133035.0
2018-12-28 18:00:00	SPY	ETF	247.57	247.75	247.52	247.59	7670.0
2018-12-28 18:30:00	SPY	ETF	247.53	247.65	247.51	247.55	6842.0
2018-12-28 19:00:00	SPY	ETF	247.52	247.66	247.52	247.56	9875.0
2018-12-28 19:30:00	SPY	ETF	247.65	247.66	247.5201	247.57	16966.0
2018-12-28 04:00:00	QQQ	ETF	153.7	153.73	153.41	153.66	10960.0
2018-12-28 04:30:00	QQQ	ETF	153.63	153.94	153.51	153.94	6700.0
2018-12-28 05:00:00	QQQ	ETF	154.0	154.36	153.96	154.26	35533.0
2018-12-28 05:30:00	QQQ	ETF	154.3	154.55	154.21	154.4	61661.0
2018-12-28 06:00:00	QQQ	ETF	154.35	154.82	153.97	154.81	45180.0
2018-12-28 06:30:00	QQQ	ETF	154.76	154.96	154.16	154.16	28882.0
2018-12-28 07:00:00	QQQ	ETF	154.19	154.48	154.0	154.21	91495.0
2018-12-28 07:30:00	QQQ	ETF	154.2	154.21	153.63	154.01	415018.0
2018-12-28 08:00:00	QQQ	ETF	154.36	154.5	153.05	153.84	160288.0
2018-12-28 08:30:00	QQQ	ETF	153.88	154.11	153.69	154.06	155391.0
2018-12-28 09:00:00	QQQ	ETF	154.07	154.07	153.75	153.99	239964.0
2018-12-28 09:30:00	QQQ	ETF	154.01	154.28	152.68	153.83	8444866.0
2018-12-28 10:00:00	QQQ	ETF	153.82	153.95	152.13	152.28	5211563.0
2018-12-28 10:30:00	QQQ	ETF	152.28	153.23	151.72	152.46	4342493.0
2018-12-28 11:00:00	QQQ	ETF	152.47	153.27	152.12	153.09	3402195.0
2018-12-28 11:30:00	QQQ	ETF	153.08	153.75	152.84	153.5	2707095.0
2018-12-28 12:00:00	QQQ	ETF	153.51	154.0	153.16	153.57	2570240.0
2018-12-28 12:30:00	QQQ	ETF	153.58	154.04	153.28	153.4	1850491.0

> showing 50 of 18,959 rows — these rows as CSV

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