PREVIEW / etf_30min / 2018-12-27

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-27.parquet
  size:    543 KB
  rows:    19,178

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-27 04:00:00	SPY	ETF	243.88	243.99	242.5	242.75	37885.0
2018-12-27 04:30:00	SPY	ETF	242.78	242.78	241.77	241.78	81379.0
2018-12-27 05:00:00	SPY	ETF	241.72	243.08	241.6	242.85	100103.0
2018-12-27 05:30:00	SPY	ETF	242.92	243.21	241.98	242.24	137497.0
2018-12-27 06:00:00	SPY	ETF	242.21	242.94	241.96	242.79	60888.0
2018-12-27 06:30:00	SPY	ETF	242.73	243.05	242.43	242.58	97422.0
2018-12-27 07:00:00	SPY	ETF	242.72	242.89	242.18	242.56	485682.0
2018-12-27 07:30:00	SPY	ETF	242.64	243.2	242.41	242.63	358399.0
2018-12-27 08:00:00	SPY	ETF	242.83	247.12	242.08	243.05	846938.0
2018-12-27 08:30:00	SPY	ETF	243.36	243.36	242.47	242.52	616740.0
2018-12-27 09:00:00	SPY	ETF	242.52	242.99	242.13	242.58	1240772.0
2018-12-27 09:30:00	SPY	ETF	242.57	243.81	241.16	241.9954	18220123.0
2018-12-27 10:00:00	SPY	ETF	241.97	242.98	240.62	240.9885	13513129.0
2018-12-27 10:30:00	SPY	ETF	240.99	242.91	240.48	241.64	12687174.0
2018-12-27 11:00:00	SPY	ETF	241.63	243.19	241.03	242.94	7094445.0
2018-12-27 11:30:00	SPY	ETF	242.93	243.63	241.8	242.5323	8610857.0
2018-12-27 12:00:00	SPY	ETF	242.55	242.6	240.82	241.2	7210290.0
2018-12-27 12:30:00	SPY	ETF	241.2	241.8399	240.81	241.7	5413290.0
2018-12-27 13:00:00	SPY	ETF	241.68	242.07	241.0	241.05	5250291.0
2018-12-27 13:30:00	SPY	ETF	241.041	241.38	239.57	239.99	9937476.0
2018-12-27 14:00:00	SPY	ETF	239.9936	240.28	238.96	239.85	10788546.0
2018-12-27 14:30:00	SPY	ETF	239.83	242.19	239.31	242.07	9884996.0
2018-12-27 15:00:00	SPY	ETF	242.065	244.97	241.08	244.76	14159413.0
2018-12-27 15:30:00	SPY	ETF	244.76	248.2	244.02	248.17	35676413.0
2018-12-27 16:00:00	SPY	ETF	248.18	248.97	248.0512	248.35	15678207.0
2018-12-27 16:30:00	SPY	ETF	248.34	248.34	247.64	248.08	1095897.0
2018-12-27 17:00:00	SPY	ETF	248.1	248.5	248.02	248.34	183465.0
2018-12-27 17:30:00	SPY	ETF	248.35	248.5	248.07	248.34	202376.0
2018-12-27 18:00:00	SPY	ETF	248.32	248.36	247.22	247.32	288810.0
2018-12-27 18:30:00	SPY	ETF	247.33	248.07	247.1	247.57	1009554.0
2018-12-27 19:00:00	SPY	ETF	247.55	248.07	247.5	247.88	98019.0
2018-12-27 19:30:00	SPY	ETF	247.95	248.17	247.9	248.01	61816.0
2018-12-27 04:00:00	QQQ	ETF	151.23	151.54	149.8	149.9	36199.0
2018-12-27 04:30:00	QQQ	ETF	149.88	149.94	149.31	149.31	24897.0
2018-12-27 05:00:00	QQQ	ETF	149.33	150.25	149.33	150.18	52435.0
2018-12-27 05:30:00	QQQ	ETF	150.04	150.34	149.49	149.55	26731.0
2018-12-27 06:00:00	QQQ	ETF	149.65	150.23	149.58	150.23	25412.0
2018-12-27 06:30:00	QQQ	ETF	150.21	150.6	149.92	150.19	23781.0
2018-12-27 07:00:00	QQQ	ETF	150.2	150.48	150.09	150.23	95323.0
2018-12-27 07:30:00	QQQ	ETF	150.27	150.75	150.19	150.39	110510.0
2018-12-27 08:00:00	QQQ	ETF	150.6	153.05	149.95	150.63	343312.0
2018-12-27 08:30:00	QQQ	ETF	150.62	150.73	150.25	150.37	138453.0
2018-12-27 09:00:00	QQQ	ETF	150.35	150.84	150.19	150.55	313604.0
2018-12-27 09:30:00	QQQ	ETF	150.56	151.3	149.33	149.95	7811620.0
2018-12-27 10:00:00	QQQ	ETF	149.95	150.51	148.5002	148.655	5347258.0
2018-12-27 10:30:00	QQQ	ETF	148.66	149.8	148.35	148.99	5543622.0
2018-12-27 11:00:00	QQQ	ETF	148.97	149.97	148.56	149.84	3268263.0
2018-12-27 11:30:00	QQQ	ETF	149.85	150.22	148.97	149.44	4105641.0
2018-12-27 12:00:00	QQQ	ETF	149.4351	149.49	148.19	148.44	3046627.0
2018-12-27 12:30:00	QQQ	ETF	148.45	149.05	148.26	148.92	2887231.0

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

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