PREVIEW / stock_30min / 2016-09-26

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-26.parquet
  size:    1.6 MB
  rows:    80,595
  symbols: 3,229

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-26 04:00:00	AAPL	Stock	27.8225	27.9225	27.755	27.825	35768.0
2016-09-26 04:30:00	AAPL	Stock	27.86	27.92	27.85	27.85	26400.0
2016-09-26 05:00:00	AAPL	Stock	27.875	27.9075	27.84	27.84	14944.0
2016-09-26 05:30:00	AAPL	Stock	27.875	27.8775	27.85	27.8775	6024.0
2016-09-26 06:00:00	AAPL	Stock	27.8975	27.9625	27.8775	27.9625	50864.0
2016-09-26 06:30:00	AAPL	Stock	27.8975	27.9375	27.8975	27.93	17424.0
2016-09-26 07:00:00	AAPL	Stock	27.95	28.0375	27.8975	27.95	231252.0
2016-09-26 07:30:00	AAPL	Stock	27.95	28.0225	27.9275	27.975	264080.0
2016-09-26 08:00:00	AAPL	Stock	27.995	28.0125	27.8875	27.95	320224.0
2016-09-26 08:30:00	AAPL	Stock	27.9425	27.9575	27.9	27.9025	324676.0
2016-09-26 09:00:00	AAPL	Stock	27.925	27.96	27.8625	27.9125	823256.0
2016-09-26 09:30:00	AAPL	Stock	27.91	28.32	27.8875	28.27	26945908.0
2016-09-26 10:00:00	AAPL	Stock	28.2675	28.3475	28.2102	28.275	11686336.0
2016-09-26 10:30:00	AAPL	Stock	28.275	28.34	28.2475	28.2575	7309336.0
2016-09-26 11:00:00	AAPL	Stock	28.2575	28.28	28.205	28.245	6119184.0
2016-09-26 11:30:00	AAPL	Stock	28.246	28.255	28.19	28.2375	4379548.0
2016-09-26 12:00:00	AAPL	Stock	28.2375	28.2725	28.225	28.2562	3254112.0
2016-09-26 12:30:00	AAPL	Stock	28.2572	28.2732	28.215	28.2175	3681792.0
2016-09-26 13:00:00	AAPL	Stock	28.22	28.2475	28.2	28.22	3792640.0
2016-09-26 13:30:00	AAPL	Stock	28.2175	28.25	28.2025	28.25	4201304.0
2016-09-26 14:00:00	AAPL	Stock	28.25	28.2625	28.21	28.2262	4145708.0
2016-09-26 14:30:00	AAPL	Stock	28.2262	28.2475	28.2	28.2125	4098552.0
2016-09-26 15:00:00	AAPL	Stock	28.2112	28.245	28.195	28.2425	4428636.0
2016-09-26 15:30:00	AAPL	Stock	28.245	28.2975	28.21	28.2175	13457508.0
2016-09-26 16:00:00	AAPL	Stock	28.22	28.255	28.205	28.21	9940748.0
2016-09-26 16:30:00	AAPL	Stock	28.21	28.2625	28.205	28.215	1231204.0
2016-09-26 17:00:00	AAPL	Stock	28.215	28.22	28.2075	28.215	23072.0
2016-09-26 17:30:00	AAPL	Stock	28.215	28.23	28.215	28.23	2988.0
2016-09-26 18:00:00	AAPL	Stock	28.23	28.2575	28.215	28.2475	70380.0
2016-09-26 18:30:00	AAPL	Stock	28.2375	28.245	28.2275	28.24	34800.0
2016-09-26 19:00:00	AAPL	Stock	28.24	28.24	28.225	28.24	27952.0
2016-09-26 19:30:00	AAPL	Stock	28.24	28.24	28.22	28.2325	63256.0
2016-09-26 04:00:00	MSFT	Stock	57.29	57.29	57.29	57.29	600.0
2016-09-26 07:30:00	MSFT	Stock	57.16	57.16	57.16	57.16	100.0
2016-09-26 08:00:00	MSFT	Stock	57.42	57.42	57.0	57.33	1745.0
2016-09-26 08:30:00	MSFT	Stock	57.2	57.2	57.2	57.2	136.0
2016-09-26 09:00:00	MSFT	Stock	57.28	57.28	57.14	57.14	3132.0
2016-09-26 09:30:00	MSFT	Stock	57.08	57.14	56.83	56.91	2416553.0
2016-09-26 10:00:00	MSFT	Stock	56.92	57.0	56.85	56.98	1236847.0
2016-09-26 10:30:00	MSFT	Stock	56.99	57.05	56.955	56.995	1339551.0
2016-09-26 11:00:00	MSFT	Stock	57.0	57.02	56.84	56.95	1268376.0
2016-09-26 11:30:00	MSFT	Stock	56.96	56.98	56.84	56.9	899083.0
2016-09-26 12:00:00	MSFT	Stock	56.904	56.98	56.85	56.935	1009491.0
2016-09-26 12:30:00	MSFT	Stock	56.935	57.03	56.86	57.0	1041839.0
2016-09-26 13:00:00	MSFT	Stock	57.0	57.035	56.95	56.996	845750.0
2016-09-26 13:30:00	MSFT	Stock	56.995	57.05	56.96	57.03	651524.0
2016-09-26 14:00:00	MSFT	Stock	57.035	57.1	57.0	57.074	634844.0
2016-09-26 14:30:00	MSFT	Stock	57.07	57.08	56.945	56.96	682232.0
2016-09-26 15:00:00	MSFT	Stock	56.95	57.06	56.95	57.03	1002502.0
2016-09-26 15:30:00	MSFT	Stock	57.03	57.1	56.88	56.92	3623700.0

> showing 50 of 80,595 rows — these rows as CSV

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