PREVIEW / stock_30min / 2015-03-19

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-19.parquet
  size:    1.6 MB
  rows:    84,383
  symbols: 3,509

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-03-19 04:00:00	AAPL	Stock	32.0	32.125	31.9925	32.1	116584.0
2015-03-19 04:30:00	AAPL	Stock	32.0975	32.11	32.0625	32.0625	13400.0
2015-03-19 05:00:00	AAPL	Stock	32.0625	32.0975	32.0625	32.0975	5600.0
2015-03-19 05:30:00	AAPL	Stock	32.075	32.0875	32.0625	32.075	10400.0
2015-03-19 06:00:00	AAPL	Stock	32.075	32.1875	32.075	32.1875	57800.0
2015-03-19 06:30:00	AAPL	Stock	32.2225	32.225	32.1525	32.1525	18900.0
2015-03-19 07:00:00	AAPL	Stock	32.175	32.1875	32.1375	32.175	87956.0
2015-03-19 07:30:00	AAPL	Stock	32.1625	32.1625	32.135	32.15	53204.0
2015-03-19 08:00:00	AAPL	Stock	32.15	32.215	32.1175	32.185	468260.0
2015-03-19 08:30:00	AAPL	Stock	32.19	32.19	32.15	32.17	250776.0
2015-03-19 09:00:00	AAPL	Stock	32.1825	32.22	32.1675	32.1875	800988.0
2015-03-19 09:30:00	AAPL	Stock	32.1875	32.3112	32.075	32.1305	30227784.0
2015-03-19 10:00:00	AAPL	Stock	32.13	32.1575	32.015	32.07	17448748.0
2015-03-19 10:30:00	AAPL	Stock	32.0675	32.1075	32.03	32.0925	10812524.0
2015-03-19 11:00:00	AAPL	Stock	32.09	32.1225	32.0025	32.0135	9918948.0
2015-03-19 11:30:00	AAPL	Stock	32.0138	32.0675	31.955	32.045	12050800.0
2015-03-19 12:00:00	AAPL	Stock	32.0462	32.055	31.97	32.005	7023540.0
2015-03-19 12:30:00	AAPL	Stock	32.0037	32.005	31.875	31.875	8096108.0
2015-03-19 13:00:00	AAPL	Stock	31.875	32.025	31.85	32.0075	10448332.0
2015-03-19 13:30:00	AAPL	Stock	32.0075	32.0475	31.895	31.9235	7089704.0
2015-03-19 14:00:00	AAPL	Stock	31.9228	32.0025	31.915	31.9675	5782648.0
2015-03-19 14:30:00	AAPL	Stock	31.9675	32.0475	31.9625	32.0438	7062308.0
2015-03-19 15:00:00	AAPL	Stock	32.0448	32.0625	31.915	31.9625	9823660.0
2015-03-19 15:30:00	AAPL	Stock	31.96	31.9975	31.8575	31.8725	18387316.0
2015-03-19 16:00:00	AAPL	Stock	31.8738	32.0315	31.84	31.8575	15475840.0
2015-03-19 16:30:00	AAPL	Stock	31.8575	32.0275	31.835	31.84	171732.0
2015-03-19 17:00:00	AAPL	Stock	31.84	31.8738	31.825	31.8325	83872.0
2015-03-19 17:30:00	AAPL	Stock	31.8375	31.8738	31.83	31.84	212180.0
2015-03-19 18:00:00	AAPL	Stock	31.835	31.8738	31.8325	31.8325	65996.0
2015-03-19 18:30:00	AAPL	Stock	31.8325	31.8425	31.8325	31.8425	46012.0
2015-03-19 19:00:00	AAPL	Stock	31.8375	31.8425	31.835	31.8375	43760.0
2015-03-19 19:30:00	AAPL	Stock	31.84	31.8425	31.825	31.84	154732.0
2015-03-19 05:30:00	MSFT	Stock	42.47	42.47	42.47	42.47	800.0
2015-03-19 07:00:00	MSFT	Stock	42.42	42.44	42.42	42.44	500.0
2015-03-19 07:30:00	MSFT	Stock	42.45	42.45	42.44	42.45	400.0
2015-03-19 08:00:00	MSFT	Stock	42.44	42.44	42.39	42.39	6309.0
2015-03-19 08:30:00	MSFT	Stock	42.36	42.36	42.33	42.33	1150.0
2015-03-19 09:00:00	MSFT	Stock	42.39	42.39	42.22	42.28	24716.0
2015-03-19 09:30:00	MSFT	Stock	42.26	42.49	42.22	42.4	3270965.0
2015-03-19 10:00:00	MSFT	Stock	42.39	42.57	42.36	42.555	1890524.0
2015-03-19 10:30:00	MSFT	Stock	42.55	42.59	42.5	42.58	1458984.0
2015-03-19 11:00:00	MSFT	Stock	42.58	42.59	42.435	42.505	1426109.0
2015-03-19 11:30:00	MSFT	Stock	42.505	42.52	42.4	42.476	1395822.0
2015-03-19 12:00:00	MSFT	Stock	42.48	42.53	42.44	42.515	1215720.0
2015-03-19 12:30:00	MSFT	Stock	42.52	42.52	42.4	42.425	906134.0
2015-03-19 13:00:00	MSFT	Stock	42.42	42.55	42.41	42.54	811524.0
2015-03-19 13:30:00	MSFT	Stock	42.535	42.55	42.4	42.417	1207711.0
2015-03-19 14:00:00	MSFT	Stock	42.42	42.505	42.39	42.44	1861325.0
2015-03-19 14:30:00	MSFT	Stock	42.43	42.47	42.34	42.35	1804773.0
2015-03-19 15:00:00	MSFT	Stock	42.355	42.41	42.32	42.39	2467539.0

> showing 50 of 84,383 rows — these rows as CSV

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