PREVIEW / stock_30min / 2015-09-28

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-28.parquet
  size:    1.6 MB
  rows:    82,805
  symbols: 3,459

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-09-28 04:00:00	AAPL	Stock	28.6775	28.7625	28.6775	28.7625	1200.0
2015-09-28 04:30:00	AAPL	Stock	28.7425	28.7425	28.6525	28.6525	18416.0
2015-09-28 05:00:00	AAPL	Stock	28.575	28.6125	28.575	28.6	4000.0
2015-09-28 05:30:00	AAPL	Stock	28.59	28.59	28.5275	28.55	36000.0
2015-09-28 06:00:00	AAPL	Stock	28.55	28.55	28.55	28.55	760.0
2015-09-28 07:00:00	AAPL	Stock	28.475	28.525	28.475	28.525	19872.0
2015-09-28 07:30:00	AAPL	Stock	28.5625	28.5625	28.47	28.515	101924.0
2015-09-28 08:00:00	AAPL	Stock	28.5225	28.5725	28.455	28.4625	565100.0
2015-09-28 08:30:00	AAPL	Stock	28.4625	28.7925	28.4575	28.65	3885600.0
2015-09-28 09:00:00	AAPL	Stock	28.6675	28.75	28.425	28.46	1431200.0
2015-09-28 09:30:00	AAPL	Stock	28.4625	28.6425	28.1575	28.17	34148072.0
2015-09-28 10:00:00	AAPL	Stock	28.163	28.3225	28.115	28.3075	19868240.0
2015-09-28 10:30:00	AAPL	Stock	28.3075	28.42	28.245	28.41	12456604.0
2015-09-28 11:00:00	AAPL	Stock	28.41	28.455	28.2525	28.2782	10135288.0
2015-09-28 11:30:00	AAPL	Stock	28.28	28.3525	28.2552	28.2552	8397628.0
2015-09-28 12:00:00	AAPL	Stock	28.2575	28.32	28.2075	28.2848	9275452.0
2015-09-28 12:30:00	AAPL	Stock	28.2838	28.33	28.2192	28.2888	8429948.0
2015-09-28 13:00:00	AAPL	Stock	28.2925	28.3762	28.2575	28.3125	7526692.0
2015-09-28 13:30:00	AAPL	Stock	28.3125	28.3925	28.275	28.2875	7822908.0
2015-09-28 14:00:00	AAPL	Stock	28.2875	28.3225	28.1925	28.2975	10438676.0
2015-09-28 14:30:00	AAPL	Stock	28.295	28.31	28.1475	28.1888	9500028.0
2015-09-28 15:00:00	AAPL	Stock	28.1875	28.2248	28.1125	28.1575	11236264.0
2015-09-28 15:30:00	AAPL	Stock	28.1575	28.32	28.1125	28.115	22845284.0
2015-09-28 16:00:00	AAPL	Stock	28.125	28.287	28.085	28.14	16693132.0
2015-09-28 16:30:00	AAPL	Stock	28.14	28.155	28.135	28.155	66864.0
2015-09-28 17:00:00	AAPL	Stock	28.1625	28.1625	28.125	28.1275	177744.0
2015-09-28 17:30:00	AAPL	Stock	28.125	28.145	28.115	28.125	72464.0
2015-09-28 18:00:00	AAPL	Stock	28.125	28.175	28.125	28.1675	83592.0
2015-09-28 18:30:00	AAPL	Stock	28.15	28.185	28.14	28.175	40784.0
2015-09-28 19:00:00	AAPL	Stock	28.18	28.195	28.175	28.185	26500.0
2015-09-28 19:30:00	AAPL	Stock	28.18	28.195	28.1725	28.19	100144.0
2015-09-28 05:00:00	MSFT	Stock	43.9	43.9	43.81	43.81	400.0
2015-09-28 07:00:00	MSFT	Stock	43.6	43.78	43.6	43.78	1000.0
2015-09-28 07:30:00	MSFT	Stock	43.6	43.6	43.6	43.6	800.0
2015-09-28 08:00:00	MSFT	Stock	43.65	43.66	43.65	43.65	3400.0
2015-09-28 08:30:00	MSFT	Stock	43.69	43.75	43.65	43.72	4728.0
2015-09-28 09:00:00	MSFT	Stock	43.75	43.82	43.7	43.82	6513.0
2015-09-28 09:30:00	MSFT	Stock	43.83	44.03	43.67	43.91	3091818.0
2015-09-28 10:00:00	MSFT	Stock	43.9	44.075	43.81	44.07	1858404.0
2015-09-28 10:30:00	MSFT	Stock	44.065	44.085	43.75	43.915	1959224.0
2015-09-28 11:00:00	MSFT	Stock	43.91	43.985	43.65	43.69	1182965.0
2015-09-28 11:30:00	MSFT	Stock	43.685	43.72	43.61	43.66	970535.0
2015-09-28 12:00:00	MSFT	Stock	43.65	43.72	43.61	43.64	1063147.0
2015-09-28 12:30:00	MSFT	Stock	43.64	43.7	43.51	43.61	1328653.0
2015-09-28 13:00:00	MSFT	Stock	43.62	43.78	43.45	43.585	1211847.0
2015-09-28 13:30:00	MSFT	Stock	43.59	43.725	43.565	43.61	993189.0
2015-09-28 14:00:00	MSFT	Stock	43.6	43.64	43.505	43.64	1312856.0
2015-09-28 14:30:00	MSFT	Stock	43.64	43.65	43.314	43.395	2449577.0
2015-09-28 15:00:00	MSFT	Stock	43.4	43.4	43.205	43.235	2098564.0
2015-09-28 15:30:00	MSFT	Stock	43.23	43.505	43.23	43.3	4435012.0

> showing 50 of 82,805 rows — these rows as CSV

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