PREVIEW / stock_30min / 2016-05-27

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-27.parquet
  size:    1.5 MB
  rows:    79,777
  symbols: 3,286

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-05-27 04:00:00	AAPL	Stock	25.1	25.115	25.1	25.115	1964.0
2016-05-27 05:00:00	AAPL	Stock	25.0875	25.0875	25.0875	25.0875	400.0
2016-05-27 05:30:00	AAPL	Stock	25.1125	25.1125	25.075	25.075	2300.0
2016-05-27 06:00:00	AAPL	Stock	25.09	25.09	25.075	25.075	8756.0
2016-05-27 06:30:00	AAPL	Stock	25.08	25.0875	25.075	25.08	5780.0
2016-05-27 07:00:00	AAPL	Stock	25.075	25.075	24.965	24.98	106624.0
2016-05-27 07:30:00	AAPL	Stock	24.965	24.98	24.9	24.92	176912.0
2016-05-27 08:00:00	AAPL	Stock	24.9725	25.0875	24.9	24.9375	403392.0
2016-05-27 08:30:00	AAPL	Stock	24.9375	24.94	24.8	24.8125	580160.0
2016-05-27 09:00:00	AAPL	Stock	24.8225	24.885	24.8125	24.8475	697076.0
2016-05-27 09:30:00	AAPL	Stock	24.86	25.015	24.8112	25.0123	27517832.0
2016-05-27 10:00:00	AAPL	Stock	25.0075	25.1175	24.9575	24.9838	18208008.0
2016-05-27 10:30:00	AAPL	Stock	24.985	25.0225	24.9275	24.9662	8472420.0
2016-05-27 11:00:00	AAPL	Stock	24.9675	25.0085	24.93	25.0025	7834132.0
2016-05-27 11:30:00	AAPL	Stock	25.005	25.05	24.9825	24.9925	7468096.0
2016-05-27 12:00:00	AAPL	Stock	24.9912	25.005	24.9775	25.0	4777608.0
2016-05-27 12:30:00	AAPL	Stock	25.0	25.0025	24.975	24.9988	4618088.0
2016-05-27 13:00:00	AAPL	Stock	24.9985	25.0	24.9718	25.0	5118588.0
2016-05-27 13:30:00	AAPL	Stock	24.9988	25.01	24.95	24.9575	5876032.0
2016-05-27 14:00:00	AAPL	Stock	24.9575	25.0025	24.9375	24.9938	5204304.0
2016-05-27 14:30:00	AAPL	Stock	24.9948	25.0225	24.98	25.02	4769928.0
2016-05-27 15:00:00	AAPL	Stock	25.0212	25.0225	24.9825	25.0012	5372800.0
2016-05-27 15:30:00	AAPL	Stock	25.0025	25.085	25.0012	25.085	13130128.0
2016-05-27 16:00:00	AAPL	Stock	25.085	25.0875	24.984	25.0475	8565572.0
2016-05-27 16:30:00	AAPL	Stock	25.0475	25.075	25.0475	25.0625	11700.0
2016-05-27 17:00:00	AAPL	Stock	25.04	25.045	25.02	25.03	51716.0
2016-05-27 17:30:00	AAPL	Stock	25.03	25.0625	25.03	25.055	22636.0
2016-05-27 18:00:00	AAPL	Stock	25.0375	25.045	25.035	25.045	11612.0
2016-05-27 18:30:00	AAPL	Stock	25.045	25.05	25.0375	25.0425	75180.0
2016-05-27 19:00:00	AAPL	Stock	25.04	25.04	25.035	25.0375	12468.0
2016-05-27 19:30:00	AAPL	Stock	25.045	25.06	25.04	25.06	17000.0
2016-05-27 05:30:00	MSFT	Stock	52.0	52.0	52.0	52.0	100.0
2016-05-27 07:30:00	MSFT	Stock	51.99	51.99	51.99	51.99	100.0
2016-05-27 08:00:00	MSFT	Stock	52.13	52.13	51.8	51.9	2487.0
2016-05-27 08:30:00	MSFT	Stock	51.9	51.95	51.9	51.95	772.0
2016-05-27 09:00:00	MSFT	Stock	51.93	51.99	51.93	51.99	15802.0
2016-05-27 09:30:00	MSFT	Stock	51.92	52.06	51.77	51.985	1803567.0
2016-05-27 10:00:00	MSFT	Stock	51.98	52.025	51.82	51.84	987274.0
2016-05-27 10:30:00	MSFT	Stock	51.85	52.06	51.85	51.96	812440.0
2016-05-27 11:00:00	MSFT	Stock	51.96	52.12	51.95	52.095	772447.0
2016-05-27 11:30:00	MSFT	Stock	52.1	52.215	52.09	52.15	785894.0
2016-05-27 12:00:00	MSFT	Stock	52.145	52.235	52.12	52.22	488586.0
2016-05-27 12:30:00	MSFT	Stock	52.22	52.3	52.19	52.21	801650.0
2016-05-27 13:00:00	MSFT	Stock	52.205	52.27	52.18	52.26	498630.0
2016-05-27 13:30:00	MSFT	Stock	52.25	52.27	52.11	52.15	711408.0
2016-05-27 14:00:00	MSFT	Stock	52.14	52.19	52.03	52.139	790831.0
2016-05-27 14:30:00	MSFT	Stock	52.135	52.21	52.08	52.173	620691.0
2016-05-27 15:00:00	MSFT	Stock	52.175	52.21	52.07	52.1	1043107.0
2016-05-27 15:30:00	MSFT	Stock	52.11	52.31	52.08	52.31	3541549.0
2016-05-27 16:00:00	MSFT	Stock	52.31	52.32	52.28	52.3	2957880.0

> showing 50 of 79,777 rows — these rows as CSV

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