PREVIEW / stock_30min / 2016-06-30

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-30.parquet
  size:    1.6 MB
  rows:    83,936
  symbols: 3,306

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-06-30 04:00:00	AAPL	Stock	23.5875	23.5875	23.5875	23.5875	1000.0
2016-06-30 04:30:00	AAPL	Stock	23.5875	23.5875	23.5875	23.5875	1120.0
2016-06-30 05:00:00	AAPL	Stock	23.5875	23.5875	23.5875	23.5875	1188.0
2016-06-30 05:30:00	AAPL	Stock	23.5875	23.5875	23.5875	23.5875	8000.0
2016-06-30 06:30:00	AAPL	Stock	23.6	23.6	23.5975	23.6	3024.0
2016-06-30 07:00:00	AAPL	Stock	23.585	23.5875	23.575	23.5875	17160.0
2016-06-30 07:30:00	AAPL	Stock	23.575	23.58	23.525	23.525	13504.0
2016-06-30 08:00:00	AAPL	Stock	23.575	23.585	23.5	23.5225	125532.0
2016-06-30 08:30:00	AAPL	Stock	23.5225	23.5625	23.52	23.5525	76184.0
2016-06-30 09:00:00	AAPL	Stock	23.5425	23.6125	23.5375	23.6125	180048.0
2016-06-30 09:30:00	AAPL	Stock	23.6125	23.7025	23.575	23.63	16184424.0
2016-06-30 10:00:00	AAPL	Stock	23.631	23.7125	23.5925	23.6275	9273320.0
2016-06-30 10:30:00	AAPL	Stock	23.6275	23.755	23.6262	23.7512	8983612.0
2016-06-30 11:00:00	AAPL	Stock	23.7525	23.853	23.7375	23.8425	9615000.0
2016-06-30 11:30:00	AAPL	Stock	23.8425	23.8725	23.815	23.865	7065640.0
2016-06-30 12:00:00	AAPL	Stock	23.865	23.895	23.8075	23.8592	9138944.0
2016-06-30 12:30:00	AAPL	Stock	23.86	23.895	23.835	23.8725	6835392.0
2016-06-30 13:00:00	AAPL	Stock	23.874	23.89	23.8375	23.86	4960144.0
2016-06-30 13:30:00	AAPL	Stock	23.8625	23.8725	23.835	23.8675	5383064.0
2016-06-30 14:00:00	AAPL	Stock	23.87	23.9375	23.8662	23.9075	6405672.0
2016-06-30 14:30:00	AAPL	Stock	23.91	23.9358	23.8985	23.92	5248620.0
2016-06-30 15:00:00	AAPL	Stock	23.9225	23.9425	23.8825	23.9225	6932416.0
2016-06-30 15:30:00	AAPL	Stock	23.9237	23.9325	23.8425	23.9025	14383052.0
2016-06-30 16:00:00	AAPL	Stock	23.9025	23.9025	23.8625	23.875	16400628.0
2016-06-30 16:30:00	AAPL	Stock	23.9	23.9	23.8525	23.8675	142944.0
2016-06-30 17:00:00	AAPL	Stock	23.897	23.9	23.845	23.8525	2419472.0
2016-06-30 17:30:00	AAPL	Stock	23.8525	23.875	23.8425	23.86	31300.0
2016-06-30 18:00:00	AAPL	Stock	23.86	23.9	23.86	23.9	13336.0
2016-06-30 18:30:00	AAPL	Stock	23.9	23.9	23.875	23.875	14800.0
2016-06-30 19:00:00	AAPL	Stock	23.8925	23.8925	23.8475	23.8875	18056.0
2016-06-30 19:30:00	AAPL	Stock	23.875	23.89	23.8475	23.85	12600.0
2016-06-30 07:30:00	MSFT	Stock	50.62	50.63	50.43	50.43	1425.0
2016-06-30 08:30:00	MSFT	Stock	50.56	50.66	50.55	50.66	2688.0
2016-06-30 09:00:00	MSFT	Stock	50.69	50.69	50.53	50.64	11438.0
2016-06-30 09:30:00	MSFT	Stock	50.72	50.83	50.5	50.52	2354100.0
2016-06-30 10:00:00	MSFT	Stock	50.525	50.78	50.5	50.61	1204319.0
2016-06-30 10:30:00	MSFT	Stock	50.6	50.96	50.6	50.92	1159611.0
2016-06-30 11:00:00	MSFT	Stock	50.925	51.08	50.85	51.06	1420448.0
2016-06-30 11:30:00	MSFT	Stock	51.05	51.175	50.995	51.075	1209601.0
2016-06-30 12:00:00	MSFT	Stock	51.08	51.3	51.065	51.27	1657626.0
2016-06-30 12:30:00	MSFT	Stock	51.27	51.3	51.06	51.09	1556691.0
2016-06-30 13:00:00	MSFT	Stock	51.09	51.13	50.85	50.925	1401660.0
2016-06-30 13:30:00	MSFT	Stock	50.93	51.05	50.93	51.0	1344618.0
2016-06-30 14:00:00	MSFT	Stock	51.0	51.13	50.97	51.02	1168409.0
2016-06-30 14:30:00	MSFT	Stock	51.02	51.13	50.97	51.08	1003678.0
2016-06-30 15:00:00	MSFT	Stock	51.08	51.18	50.98	51.18	1832120.0
2016-06-30 15:30:00	MSFT	Stock	51.18	51.19	50.96	51.17	3734914.0
2016-06-30 16:00:00	MSFT	Stock	51.17	51.2	51.07	51.2	5759072.0
2016-06-30 16:30:00	MSFT	Stock	51.17	51.17	51.17	51.17	33013.0
2016-06-30 17:00:00	MSFT	Stock	51.164	51.17	51.164	51.17	125643.0

> showing 50 of 83,936 rows — these rows as CSV

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