PREVIEW / etf_30min / 2018-12-20

all etf 30-min files

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

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-20 04:00:00	SPY	ETF	250.0	250.37	249.48	250.28	32495.0
2018-12-20 04:30:00	SPY	ETF	250.23	250.6	250.23	250.58	21783.0
2018-12-20 05:00:00	SPY	ETF	250.64	251.01	250.35	250.77	40252.0
2018-12-20 05:30:00	SPY	ETF	250.97	250.97	250.19	250.59	32084.0
2018-12-20 06:00:00	SPY	ETF	250.68	251.28	250.68	251.28	19160.0
2018-12-20 06:30:00	SPY	ETF	251.35	251.67	251.24	251.6	55772.0
2018-12-20 07:00:00	SPY	ETF	251.57	252.26	251.26	251.4	154595.0
2018-12-20 07:30:00	SPY	ETF	251.35	251.85	251.15	251.61	268739.0
2018-12-20 08:00:00	SPY	ETF	251.6	251.96	248.42	251.35	670058.0
2018-12-20 08:30:00	SPY	ETF	251.4	251.4	250.2	250.25	581654.0
2018-12-20 09:00:00	SPY	ETF	250.24	250.61	249.77	249.85	1209379.0
2018-12-20 09:30:00	SPY	ETF	249.86	250.83	248.89	250.41	21928540.0
2018-12-20 10:00:00	SPY	ETF	250.41	251.62	249.88	250.3	15376793.0
2018-12-20 10:30:00	SPY	ETF	250.29	251.55	250.05	250.59	11431623.0
2018-12-20 11:00:00	SPY	ETF	250.58	250.72	248.56	248.98	12430055.0
2018-12-20 11:30:00	SPY	ETF	248.985	249.28	246.7875	247.66	17314641.0
2018-12-20 12:00:00	SPY	ETF	247.66	249.1	246.91	249.03	14893840.0
2018-12-20 12:30:00	SPY	ETF	249.0301	249.23	247.42	248.3064	10027820.0
2018-12-20 13:00:00	SPY	ETF	248.31	248.37	247.05	247.685	8508581.0
2018-12-20 13:30:00	SPY	ETF	247.675	247.83	246.63	246.78	9608147.0
2018-12-20 14:00:00	SPY	ETF	246.785	248.3	244.65	247.04	21457146.0
2018-12-20 14:30:00	SPY	ETF	247.04	249.47	246.69	247.92	22279588.0
2018-12-20 15:00:00	SPY	ETF	247.92	249.1	246.45	247.8062	19904316.0
2018-12-20 15:30:00	SPY	ETF	247.8	248.75	246.13	247.24	35650512.0
2018-12-20 16:00:00	SPY	ETF	247.22	249.19	247.07	248.7	18381206.0
2018-12-20 16:30:00	SPY	ETF	248.72	249.19	247.3177	249.14	1309871.0
2018-12-20 17:00:00	SPY	ETF	249.09	249.2	247.17	249.0	1221014.0
2018-12-20 17:30:00	SPY	ETF	249.0	249.09	247.17	248.85	1438935.0
2018-12-20 18:00:00	SPY	ETF	248.92	249.49	248.76	249.37	343901.0
2018-12-20 18:30:00	SPY	ETF	249.35	249.4	248.65	248.65	2958962.0
2018-12-20 19:00:00	SPY	ETF	248.65	248.65	248.05	248.13	143074.0
2018-12-20 19:30:00	SPY	ETF	248.34	248.62	247.17	248.54	179943.0
2018-12-20 20:00:00	SPY	ETF	247.17	247.17	247.1	247.1	270.0
2018-12-20 04:00:00	QQQ	ETF	154.17	154.4	153.8	154.4	9443.0
2018-12-20 04:30:00	QQQ	ETF	154.35	154.59	154.28	154.54	12107.0
2018-12-20 05:00:00	QQQ	ETF	154.59	154.84	154.31	154.75	11600.0
2018-12-20 05:30:00	QQQ	ETF	154.67	154.81	154.29	154.64	65891.0
2018-12-20 06:00:00	QQQ	ETF	154.65	155.05	154.65	155.05	36179.0
2018-12-20 06:30:00	QQQ	ETF	155.08	155.34	155.01	155.28	22290.0
2018-12-20 07:00:00	QQQ	ETF	155.26	155.58	155.12	155.23	48958.0
2018-12-20 07:30:00	QQQ	ETF	155.13	155.5	155.01	155.43	50960.0
2018-12-20 08:00:00	QQQ	ETF	155.5	155.5599	153.49	155.03	152116.0
2018-12-20 08:30:00	QQQ	ETF	154.99	155.0	154.04	154.1	286670.0
2018-12-20 09:00:00	QQQ	ETF	154.1	154.51	153.97	154.17	262225.0
2018-12-20 09:30:00	QQQ	ETF	154.17	155.3	153.79	155.13	9906044.0
2018-12-20 10:00:00	QQQ	ETF	155.14	155.87	154.37	154.6501	5905802.0
2018-12-20 10:30:00	QQQ	ETF	154.66	155.31	154.12	154.49	4424172.0
2018-12-20 11:00:00	QQQ	ETF	154.48	154.53	152.64	152.93	7601029.0
2018-12-20 11:30:00	QQQ	ETF	152.94	153.19	151.26	152.2698	9319380.0
2018-12-20 12:00:00	QQQ	ETF	152.27	153.12	151.54	153.05	5959665.0

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

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