PREVIEW / etf_30min / 2016-09-29

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-29.parquet
  size:    407 KB
  rows:    13,973

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
2016-09-29 04:00:00	SPY	ETF	216.82	216.87	216.7	216.7	81795.0
2016-09-29 04:30:00	SPY	ETF	216.7	216.71	216.6	216.66	10717.0
2016-09-29 05:00:00	SPY	ETF	216.73	216.76	216.66	216.66	2017.0
2016-09-29 05:30:00	SPY	ETF	216.57	216.68	216.57	216.63	3907.0
2016-09-29 06:00:00	SPY	ETF	216.66	216.66	216.5	216.54	2203.0
2016-09-29 06:30:00	SPY	ETF	216.56	216.56	216.35	216.46	5566.0
2016-09-29 07:00:00	SPY	ETF	216.46	216.56	216.4	216.51	34906.0
2016-09-29 07:30:00	SPY	ETF	216.51	216.62	216.46	216.46	75302.0
2016-09-29 08:00:00	SPY	ETF	216.53	217.0	216.12	216.14	647979.0
2016-09-29 08:30:00	SPY	ETF	216.15	216.34	216.08	216.31	298224.0
2016-09-29 09:00:00	SPY	ETF	216.31	216.41	216.15	216.41	435990.0
2016-09-29 09:30:00	SPY	ETF	216.4	216.59	216.26	216.59	6514368.0
2016-09-29 10:00:00	SPY	ETF	216.58	216.87	216.31	216.73	6420394.0
2016-09-29 10:30:00	SPY	ETF	216.73	216.77	216.29	216.3	4310879.0
2016-09-29 11:00:00	SPY	ETF	216.31	216.4	215.87	216.23	6485168.0
2016-09-29 11:30:00	SPY	ETF	216.225	216.4	216.16	216.25	3474018.0
2016-09-29 12:00:00	SPY	ETF	216.26	216.62	216.18	216.4	3892304.0
2016-09-29 12:30:00	SPY	ETF	216.403	216.46	214.71	214.99	14187474.0
2016-09-29 13:00:00	SPY	ETF	214.999	215.25	214.4048	215.0	13605446.0
2016-09-29 13:30:00	SPY	ETF	215.0	215.18	214.04	214.3	9623125.0
2016-09-29 14:00:00	SPY	ETF	214.3	215.46	214.14	215.39	11964088.0
2016-09-29 14:30:00	SPY	ETF	215.405	215.69	215.09	215.16	10725971.0
2016-09-29 15:00:00	SPY	ETF	215.16	215.322	214.64	215.18	9121147.0
2016-09-29 15:30:00	SPY	ETF	215.18	215.47	214.64	214.6863	14233356.0
2016-09-29 16:00:00	SPY	ETF	214.69	215.2	214.68	215.16	5943872.0
2016-09-29 16:30:00	SPY	ETF	215.18	215.21	215.02	215.04	3505033.0
2016-09-29 17:00:00	SPY	ETF	215.08	215.08	214.91	214.97	190092.0
2016-09-29 17:30:00	SPY	ETF	214.96	214.99	214.79	214.84	429017.0
2016-09-29 18:00:00	SPY	ETF	214.85	214.85	214.68	214.77	232231.0
2016-09-29 18:30:00	SPY	ETF	214.77	214.89	214.74	214.82	84206.0
2016-09-29 19:00:00	SPY	ETF	214.82	214.86	214.63	214.73	62639.0
2016-09-29 19:30:00	SPY	ETF	214.72	214.81	214.6	214.76	41482.0
2016-09-29 04:00:00	QQQ	ETF	118.79	118.79	118.79	118.79	100.0
2016-09-29 05:30:00	QQQ	ETF	118.66	118.68	118.66	118.68	999.0
2016-09-29 06:00:00	QQQ	ETF	118.64	118.64	118.62	118.62	500.0
2016-09-29 06:30:00	QQQ	ETF	118.57	118.57	118.53	118.53	10200.0
2016-09-29 07:00:00	QQQ	ETF	118.53	118.56	118.52	118.54	12400.0
2016-09-29 07:30:00	QQQ	ETF	118.53	118.58	118.53	118.54	8999.0
2016-09-29 08:00:00	QQQ	ETF	118.51	118.53	118.34	118.39	69677.0
2016-09-29 08:30:00	QQQ	ETF	118.36	118.48	118.36	118.46	82404.0
2016-09-29 09:00:00	QQQ	ETF	118.47	118.52	118.41	118.52	93463.0
2016-09-29 09:30:00	QQQ	ETF	118.52	118.635	118.46	118.62	1322233.0
2016-09-29 10:00:00	QQQ	ETF	118.62	118.72	118.15	118.43	2296316.0
2016-09-29 10:30:00	QQQ	ETF	118.44	118.44	118.15	118.23	1127176.0
2016-09-29 11:00:00	QQQ	ETF	118.235	118.32	118.01	118.168	1267474.0
2016-09-29 11:30:00	QQQ	ETF	118.165	118.2748	118.13	118.24	693362.0
2016-09-29 12:00:00	QQQ	ETF	118.245	118.47	118.205	118.36	670572.0
2016-09-29 12:30:00	QQQ	ETF	118.35	118.39	117.5	117.615	2413214.0
2016-09-29 13:00:00	QQQ	ETF	117.6	118.005	117.3338	117.935	3683152.0
2016-09-29 13:30:00	QQQ	ETF	117.93	118.0	117.42	117.5899	1607792.0

> showing 50 of 13,973 rows — these rows as CSV

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