PREVIEW / etf_30min / 2018-12-21

all etf 30-min files

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

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-21 04:00:00	SPY	ETF	246.31	246.49	245.81	246.19	55260.0
2018-12-21 04:30:00	SPY	ETF	246.14	246.4	245.97	246.36	11964.0
2018-12-21 05:00:00	SPY	ETF	246.35	246.37	245.67	246.05	47146.0
2018-12-21 05:30:00	SPY	ETF	246.0	246.61	246.0	246.6	35492.0
2018-12-21 06:00:00	SPY	ETF	246.55	246.8	246.43	246.63	44353.0
2018-12-21 06:30:00	SPY	ETF	246.6	247.06	246.6	246.7	36846.0
2018-12-21 07:00:00	SPY	ETF	246.71	246.9	246.19	246.36	162999.0
2018-12-21 07:30:00	SPY	ETF	246.35	246.75	246.14	246.65	205553.0
2018-12-21 08:00:00	SPY	ETF	246.65	247.65	246.0	247.12	481813.0
2018-12-21 08:30:00	SPY	ETF	247.2	248.24	247.2	247.6	920402.0
2018-12-21 09:00:00	SPY	ETF	247.64	248.25	246.33	246.7	3423216.0
2018-12-21 09:30:00	SPY	ETF	246.74	247.35	246.1	246.77	22547348.0
2018-12-21 10:00:00	SPY	ETF	246.8	249.71	246.01	248.49	19938895.0
2018-12-21 10:30:00	SPY	ETF	248.48	248.67	246.99	247.2	16459058.0
2018-12-21 11:00:00	SPY	ETF	247.21	247.23	245.02	246.84	13254776.0
2018-12-21 11:30:00	SPY	ETF	246.84	247.005	245.08	245.28	12105901.0
2018-12-21 12:00:00	SPY	ETF	245.28	245.58	243.37	243.53	16038381.0
2018-12-21 12:30:00	SPY	ETF	243.53	245.13	242.57	243.6	16328380.0
2018-12-21 13:00:00	SPY	ETF	243.61	244.44	243.067	243.88	9018710.0
2018-12-21 13:30:00	SPY	ETF	243.88	244.86	243.27	243.62	9977250.0
2018-12-21 14:00:00	SPY	ETF	243.62	244.13	242.68	243.34	9721087.0
2018-12-21 14:30:00	SPY	ETF	243.35	243.78	242.43	243.0	9230963.0
2018-12-21 15:00:00	SPY	ETF	242.99	243.42	240.75	240.76	14927825.0
2018-12-21 15:30:00	SPY	ETF	240.76	241.6	239.98	240.69	37599007.0
2018-12-21 16:00:00	SPY	ETF	240.62	240.99	240.11	240.45	30871678.0
2018-12-21 16:30:00	SPY	ETF	240.45	241.24	240.4	241.09	3407336.0
2018-12-21 17:00:00	SPY	ETF	241.1	241.1	240.7	240.91	1052036.0
2018-12-21 17:30:00	SPY	ETF	240.85	240.85	240.41	240.68	1981542.0
2018-12-21 18:00:00	SPY	ETF	240.6	240.6	240.26	240.34	174150.0
2018-12-21 18:30:00	SPY	ETF	240.3	240.7	240.18	240.3	285597.0
2018-12-21 19:00:00	SPY	ETF	240.3	240.7	240.26	240.5	133928.0
2018-12-21 19:30:00	SPY	ETF	240.44	240.47	240.32	240.35	39526.0
2018-12-21 04:00:00	QQQ	ETF	152.88	153.0	152.5	152.98	21518.0
2018-12-21 04:30:00	QQQ	ETF	152.91	153.09	152.89	153.09	13550.0
2018-12-21 05:00:00	QQQ	ETF	153.03	153.03	152.67	152.77	8839.0
2018-12-21 05:30:00	QQQ	ETF	153.06	153.22	152.98	153.16	13200.0
2018-12-21 06:00:00	QQQ	ETF	153.15	153.31	153.07	153.1	5980.0
2018-12-21 06:30:00	QQQ	ETF	153.1	153.54	153.1	153.19	20630.0
2018-12-21 07:00:00	QQQ	ETF	153.18	153.29	152.85	152.98	45605.0
2018-12-21 07:30:00	QQQ	ETF	152.94	153.13	152.73	153.0	44304.0
2018-12-21 08:00:00	QQQ	ETF	153.0	153.82	152.65	153.41	150948.0
2018-12-21 08:30:00	QQQ	ETF	153.5	154.11	152.29	153.75	437305.0
2018-12-21 09:00:00	QQQ	ETF	153.75	154.25	152.71	152.97	1390022.0
2018-12-21 09:30:00	QQQ	ETF	153.05	153.76	152.2	152.59	11109352.0
2018-12-21 10:00:00	QQQ	ETF	152.59	154.09	151.49	153.36	12093215.0
2018-12-21 10:30:00	QQQ	ETF	153.3445	153.47	152.03	152.29	6828425.0
2018-12-21 11:00:00	QQQ	ETF	152.29	152.31	150.8	151.77	7714943.0
2018-12-21 11:30:00	QQQ	ETF	151.76	151.94	150.34	150.4849	5204952.0
2018-12-21 12:00:00	QQQ	ETF	150.48	150.54	148.83	148.98	9953309.0
2018-12-21 12:30:00	QQQ	ETF	148.94	150.35	148.24	149.37	12444882.0

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

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