PREVIEW / stock_30min / 2016-10-10

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-10.parquet
  size:    1.5 MB
  rows:    79,207
  symbols: 3,177

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-10-10 04:00:00	AAPL	Stock	28.5625	28.5625	28.5625	28.5625	400.0
2016-10-10 04:30:00	AAPL	Stock	28.5875	28.6	28.5875	28.6	8280.0
2016-10-10 05:30:00	AAPL	Stock	28.6	28.6125	28.6	28.6	10680.0
2016-10-10 06:00:00	AAPL	Stock	28.6175	28.67	28.6175	28.6625	22684.0
2016-10-10 06:30:00	AAPL	Stock	28.665	28.725	28.66	28.6975	59160.0
2016-10-10 07:00:00	AAPL	Stock	28.6975	28.7475	28.6975	28.725	98972.0
2016-10-10 07:30:00	AAPL	Stock	28.7275	28.7875	28.725	28.745	204588.0
2016-10-10 08:00:00	AAPL	Stock	28.75	28.8	28.7	28.7925	602128.0
2016-10-10 08:30:00	AAPL	Stock	28.7975	28.85	28.7925	28.8375	453648.0
2016-10-10 09:00:00	AAPL	Stock	28.84	28.8875	28.7525	28.755	1191916.0
2016-10-10 09:30:00	AAPL	Stock	28.765	28.9925	28.68	28.955	27123728.0
2016-10-10 10:00:00	AAPL	Stock	28.9538	28.99	28.9202	28.9828	11734252.0
2016-10-10 10:30:00	AAPL	Stock	28.985	29.105	28.9838	29.0725	16000988.0
2016-10-10 11:00:00	AAPL	Stock	29.0712	29.0825	29.016	29.0275	7508252.0
2016-10-10 11:30:00	AAPL	Stock	29.0275	29.1175	29.0275	29.0925	6785756.0
2016-10-10 12:00:00	AAPL	Stock	29.0902	29.095	29.0425	29.0515	5804900.0
2016-10-10 12:30:00	AAPL	Stock	29.051	29.0838	29.0425	29.078	4001380.0
2016-10-10 13:00:00	AAPL	Stock	29.0788	29.155	29.0725	29.1188	8623520.0
2016-10-10 13:30:00	AAPL	Stock	29.1175	29.135	29.1	29.1262	4947852.0
2016-10-10 14:00:00	AAPL	Stock	29.1275	29.15	29.1088	29.1475	4077032.0
2016-10-10 14:30:00	AAPL	Stock	29.1475	29.1875	29.1425	29.15	6882520.0
2016-10-10 15:00:00	AAPL	Stock	29.1475	29.1525	29.045	29.075	8053856.0
2016-10-10 15:30:00	AAPL	Stock	29.075	29.075	29.0	29.0125	12926388.0
2016-10-10 16:00:00	AAPL	Stock	29.0125	29.0538	29.0	29.025	7173556.0
2016-10-10 16:30:00	AAPL	Stock	29.025	29.0425	29.0125	29.0425	94304.0
2016-10-10 17:00:00	AAPL	Stock	29.035	29.035	29.0125	29.035	508976.0
2016-10-10 17:30:00	AAPL	Stock	29.035	29.0375	29.0125	29.0375	184908.0
2016-10-10 18:00:00	AAPL	Stock	29.0375	29.0875	29.03	29.0875	112872.0
2016-10-10 18:30:00	AAPL	Stock	29.085	29.1075	29.0625	29.09	89296.0
2016-10-10 19:00:00	AAPL	Stock	29.0825	29.0975	29.08	29.0975	69976.0
2016-10-10 19:30:00	AAPL	Stock	29.0975	29.1125	29.0875	29.09	91672.0
2016-10-10 07:00:00	MSFT	Stock	57.7	57.7	57.7	57.7	150.0
2016-10-10 07:30:00	MSFT	Stock	58.0	58.0	58.0	58.0	450.0
2016-10-10 08:00:00	MSFT	Stock	57.93	57.93	57.93	57.93	200.0
2016-10-10 08:30:00	MSFT	Stock	57.96	58.04	57.96	58.04	6203.0
2016-10-10 09:00:00	MSFT	Stock	58.06	58.06	57.92	57.92	13624.0
2016-10-10 09:30:00	MSFT	Stock	57.92	58.3	57.91	58.29	2689977.0
2016-10-10 10:00:00	MSFT	Stock	58.3	58.34	58.215	58.265	1485089.0
2016-10-10 10:30:00	MSFT	Stock	58.27	58.39	58.27	58.299	1007502.0
2016-10-10 11:00:00	MSFT	Stock	58.29	58.32	58.075	58.083	1451378.0
2016-10-10 11:30:00	MSFT	Stock	58.09	58.19	58.06	58.13	959432.0
2016-10-10 12:00:00	MSFT	Stock	58.125	58.14	58.03	58.06	663960.0
2016-10-10 12:30:00	MSFT	Stock	58.055	58.07	57.97	58.03	859531.0
2016-10-10 13:00:00	MSFT	Stock	58.03	58.06	57.96	57.985	974413.0
2016-10-10 13:30:00	MSFT	Stock	57.99	58.02	57.87	58.01	926024.0
2016-10-10 14:00:00	MSFT	Stock	58.01	58.09	57.98	58.09	763571.0
2016-10-10 14:30:00	MSFT	Stock	58.09	58.16	58.06	58.1	1039918.0
2016-10-10 15:00:00	MSFT	Stock	58.11	58.16	58.08	58.14	1383223.0
2016-10-10 15:30:00	MSFT	Stock	58.14	58.14	58.04	58.05	1802310.0
2016-10-10 16:00:00	MSFT	Stock	58.04	58.1	58.04	58.1	1092110.0

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

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