PREVIEW / etf_30min / 2017-06-27

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-27.parquet
  size:    443 KB
  rows:    15,278

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
2017-06-27 04:00:00	SPY	ETF	243.03	243.03	242.66	242.66	1900.0
2017-06-27 04:30:00	SPY	ETF	242.85	243.03	242.85	242.98	3100.0
2017-06-27 05:00:00	SPY	ETF	243.06	243.22	243.06	243.22	600.0
2017-06-27 05:30:00	SPY	ETF	243.08	243.08	242.99	243.01	1003.0
2017-06-27 06:00:00	SPY	ETF	243.01	243.04	242.94	243.04	51800.0
2017-06-27 06:30:00	SPY	ETF	243.06	243.12	243.06	243.1	5755.0
2017-06-27 07:00:00	SPY	ETF	243.07	243.07	242.89	242.94	125690.0
2017-06-27 07:30:00	SPY	ETF	242.92	243.1	242.88	243.1	39559.0
2017-06-27 08:00:00	SPY	ETF	242.92	243.14	242.92	243.14	76278.0
2017-06-27 08:30:00	SPY	ETF	243.14	243.16	243.08	243.1	60922.0
2017-06-27 09:00:00	SPY	ETF	243.06	243.1	242.95	243.02	256101.0
2017-06-27 09:30:00	SPY	ETF	243.04	243.06	242.6	242.82	5657582.0
2017-06-27 10:00:00	SPY	ETF	242.82	243.11	242.7783	242.78	5373724.0
2017-06-27 10:30:00	SPY	ETF	242.78	243.33	242.78	243.23	3556717.0
2017-06-27 11:00:00	SPY	ETF	243.22	243.38	243.14	243.17	2597786.0
2017-06-27 11:30:00	SPY	ETF	243.175	243.36	243.14	243.21	1699838.0
2017-06-27 12:00:00	SPY	ETF	243.21	243.27	243.07	243.1029	1592982.0
2017-06-27 12:30:00	SPY	ETF	243.1	243.13	242.68	242.76	3384186.0
2017-06-27 13:00:00	SPY	ETF	242.765	242.8	242.51	242.665	3178451.0
2017-06-27 13:30:00	SPY	ETF	242.665	242.72	241.76	242.13	10103509.0
2017-06-27 14:00:00	SPY	ETF	242.135	242.34	241.72	242.27	7927736.0
2017-06-27 14:30:00	SPY	ETF	242.28	242.4	242.1	242.1642	4089494.0
2017-06-27 15:00:00	SPY	ETF	242.16	242.25	241.85	241.95	4354364.0
2017-06-27 15:30:00	SPY	ETF	241.95	241.99	241.31	241.36	17067307.0
2017-06-27 16:00:00	SPY	ETF	241.37	243.2538	241.3002	241.71	9102558.0
2017-06-27 16:30:00	SPY	ETF	241.71	242.5594	241.34	241.44	280047.0
2017-06-27 17:00:00	SPY	ETF	241.44	241.46	241.33	241.44	73161.0
2017-06-27 17:30:00	SPY	ETF	241.44	241.48	241.35	241.35	17681.0
2017-06-27 18:00:00	SPY	ETF	241.39	241.59	241.39	241.52	47433.0
2017-06-27 18:30:00	SPY	ETF	241.55	241.61	241.53	241.53	19592.0
2017-06-27 19:00:00	SPY	ETF	241.51	241.55	241.48	241.53	3800.0
2017-06-27 19:30:00	SPY	ETF	241.55	241.57	241.4	241.4	17157.0
2017-06-27 04:00:00	QQQ	ETF	140.25	140.25	139.74	139.74	7710.0
2017-06-27 04:30:00	QQQ	ETF	139.75	139.91	139.75	139.91	1750.0
2017-06-27 05:00:00	QQQ	ETF	139.94	140.12	139.94	140.05	26239.0
2017-06-27 05:30:00	QQQ	ETF	140.06	140.1	139.92	139.93	28524.0
2017-06-27 06:00:00	QQQ	ETF	139.94	139.96	139.86	139.96	27493.0
2017-06-27 06:30:00	QQQ	ETF	140.02	140.05	139.99	139.99	12652.0
2017-06-27 07:00:00	QQQ	ETF	139.9	139.95	139.87	139.87	15286.0
2017-06-27 07:30:00	QQQ	ETF	139.85	140.07	139.84	140.07	37084.0
2017-06-27 08:00:00	QQQ	ETF	139.92	140.09	139.92	140.04	114639.0
2017-06-27 08:30:00	QQQ	ETF	140.01	140.05	139.88	139.9	58995.0
2017-06-27 09:00:00	QQQ	ETF	139.9	140.08	139.84	140.07	153581.0
2017-06-27 09:30:00	QQQ	ETF	140.07	140.07	139.49	139.74	5231409.0
2017-06-27 10:00:00	QQQ	ETF	139.74	140.17	139.72	139.74	2368314.0
2017-06-27 10:30:00	QQQ	ETF	139.75	140.22	139.75	140.0599	2258919.0
2017-06-27 11:00:00	QQQ	ETF	140.05	140.19	139.84	139.8746	1540133.0
2017-06-27 11:30:00	QQQ	ETF	139.8747	140.06	139.76	139.8	1066065.0
2017-06-27 12:00:00	QQQ	ETF	139.8	139.905	139.69	139.79	713175.0
2017-06-27 12:30:00	QQQ	ETF	139.79	139.81	139.16	139.29	2907070.0

> showing 50 of 15,278 rows — these rows as CSV

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