PREVIEW / stock_30min / 2015-05-12

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-12.parquet
  size:    1.6 MB
  rows:    83,156
  symbols: 3,482

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
2015-05-12 04:00:00	AAPL	Stock	31.535	31.535	31.355	31.43	9980.0
2015-05-12 04:30:00	AAPL	Stock	31.425	31.425	31.335	31.335	15364.0
2015-05-12 05:00:00	AAPL	Stock	31.3225	31.3625	31.3	31.32	21208.0
2015-05-12 05:30:00	AAPL	Stock	31.375	31.375	31.3	31.3	10600.0
2015-05-12 06:00:00	AAPL	Stock	31.3	31.31	31.285	31.3	30864.0
2015-05-12 06:30:00	AAPL	Stock	31.3	31.34	31.2775	31.3375	50664.0
2015-05-12 07:00:00	AAPL	Stock	31.3275	31.4175	31.3275	31.3525	59804.0
2015-05-12 07:30:00	AAPL	Stock	31.3675	31.4375	31.33	31.4	159624.0
2015-05-12 08:00:00	AAPL	Stock	31.4	31.455	31.3	31.39	476736.0
2015-05-12 08:30:00	AAPL	Stock	31.3925	31.425	31.3925	31.42	320288.0
2015-05-12 09:00:00	AAPL	Stock	31.4225	31.4325	31.37	31.4025	424988.0
2015-05-12 09:30:00	AAPL	Stock	31.4	31.4525	31.205	31.2775	29174752.0
2015-05-12 10:00:00	AAPL	Stock	31.2775	31.3122	31.2175	31.285	14240880.0
2015-05-12 10:30:00	AAPL	Stock	31.28	31.505	31.2725	31.4175	16873648.0
2015-05-12 11:00:00	AAPL	Stock	31.4175	31.5625	31.4025	31.52	12555052.0
2015-05-12 11:30:00	AAPL	Stock	31.5175	31.6225	31.51	31.5625	10296476.0
2015-05-12 12:00:00	AAPL	Stock	31.5625	31.5975	31.4425	31.5192	9238760.0
2015-05-12 12:30:00	AAPL	Stock	31.5225	31.5975	31.4745	31.5832	6579364.0
2015-05-12 13:00:00	AAPL	Stock	31.585	31.72	31.573	31.6762	10685132.0
2015-05-12 13:30:00	AAPL	Stock	31.675	31.6825	31.59	31.6272	7139464.0
2015-05-12 14:00:00	AAPL	Stock	31.6275	31.6775	31.5875	31.6385	6580468.0
2015-05-12 14:30:00	AAPL	Stock	31.64	31.6975	31.5338	31.56	7901324.0
2015-05-12 15:00:00	AAPL	Stock	31.5625	31.61	31.5175	31.55	7524516.0
2015-05-12 15:30:00	AAPL	Stock	31.5488	31.5825	31.465	31.465	15362796.0
2015-05-12 16:00:00	AAPL	Stock	31.4662	31.5832	31.1898	31.48	19469672.0
2015-05-12 16:30:00	AAPL	Stock	31.48	31.485	31.4575	31.4575	3168932.0
2015-05-12 17:00:00	AAPL	Stock	31.455	31.4725	31.445	31.4675	106840.0
2015-05-12 17:30:00	AAPL	Stock	31.47	31.485	31.46	31.4725	45556.0
2015-05-12 18:00:00	AAPL	Stock	31.475	31.4825	31.475	31.4798	79624.0
2015-05-12 18:30:00	AAPL	Stock	31.475	31.4925	31.475	31.4898	61536.0
2015-05-12 19:00:00	AAPL	Stock	31.49	31.4925	31.4875	31.4925	12404.0
2015-05-12 19:30:00	AAPL	Stock	31.495	31.5175	31.495	31.51	66832.0
2015-05-12 04:00:00	MSFT	Stock	47.14	47.14	47.14	47.14	200.0
2015-05-12 05:30:00	MSFT	Stock	46.86	46.86	46.85	46.85	1170.0
2015-05-12 06:00:00	MSFT	Stock	46.85	46.85	46.85	46.85	100.0
2015-05-12 07:00:00	MSFT	Stock	46.91	46.92	46.9	46.92	1100.0
2015-05-12 07:30:00	MSFT	Stock	46.92	46.92	46.84	46.86	5670.0
2015-05-12 08:00:00	MSFT	Stock	47.05	47.06	46.92	47.0	13520.0
2015-05-12 08:30:00	MSFT	Stock	46.96	47.12	46.9	47.1	13150.0
2015-05-12 09:00:00	MSFT	Stock	47.1	47.1	46.85	46.85	52035.0
2015-05-12 09:30:00	MSFT	Stock	46.85	47.0	46.42	46.575	4410462.0
2015-05-12 10:00:00	MSFT	Stock	46.575	46.72	46.5	46.64	2432667.0
2015-05-12 10:30:00	MSFT	Stock	46.64	47.03	46.63	46.99	2205401.0
2015-05-12 11:00:00	MSFT	Stock	46.99	47.29	46.99	47.23	1751084.0
2015-05-12 11:30:00	MSFT	Stock	47.23	47.45	47.22	47.34	1180111.0
2015-05-12 12:00:00	MSFT	Stock	47.34	47.37	47.22	47.25	861101.0
2015-05-12 12:30:00	MSFT	Stock	47.245	47.49	47.24	47.47	1190724.0
2015-05-12 13:00:00	MSFT	Stock	47.47	47.61	47.42	47.51	1315172.0
2015-05-12 13:30:00	MSFT	Stock	47.52	47.53	47.36	47.48	1066644.0
2015-05-12 14:00:00	MSFT	Stock	47.49	47.62	47.45	47.61	1259691.0

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

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