PREVIEW / stock_30min / 2016-07-08

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-08.parquet
  size:    1.6 MB
  rows:    81,973
  symbols: 3,277

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-07-08 04:00:00	AAPL	Stock	24.0125	24.025	24.0125	24.025	3840.0
2016-07-08 04:30:00	AAPL	Stock	24.025	24.05	24.025	24.05	5300.0
2016-07-08 05:00:00	AAPL	Stock	24.025	24.025	24.0225	24.0225	12580.0
2016-07-08 05:30:00	AAPL	Stock	23.96	23.96	23.95	23.95	8000.0
2016-07-08 06:00:00	AAPL	Stock	23.9975	23.9975	23.9975	23.9975	1644.0
2016-07-08 06:30:00	AAPL	Stock	23.9975	23.9975	23.9975	23.9975	400.0
2016-07-08 07:00:00	AAPL	Stock	24.0075	24.025	24.005	24.025	7192.0
2016-07-08 07:30:00	AAPL	Stock	24.0	24.005	23.9975	23.9975	7444.0
2016-07-08 08:00:00	AAPL	Stock	24.0	24.025	23.975	24.0	34712.0
2016-07-08 08:30:00	AAPL	Stock	23.9975	24.11	23.9675	24.09	308496.0
2016-07-08 09:00:00	AAPL	Stock	24.0975	24.125	24.07	24.125	180408.0
2016-07-08 09:30:00	AAPL	Stock	24.125	24.2225	24.0125	24.1838	16746492.0
2016-07-08 10:00:00	AAPL	Stock	24.1825	24.195	24.105	24.1485	8118864.0
2016-07-08 10:30:00	AAPL	Stock	24.15	24.175	24.13	24.16	6239112.0
2016-07-08 11:00:00	AAPL	Stock	24.1625	24.19	24.135	24.1788	6575468.0
2016-07-08 11:30:00	AAPL	Stock	24.1788	24.18	24.1325	24.135	5462212.0
2016-07-08 12:00:00	AAPL	Stock	24.135	24.1675	24.1127	24.1512	5726352.0
2016-07-08 12:30:00	AAPL	Stock	24.1525	24.185	24.145	24.1475	7487324.0
2016-07-08 13:00:00	AAPL	Stock	24.15	24.185	24.1438	24.1825	3753088.0
2016-07-08 13:30:00	AAPL	Stock	24.1825	24.1875	24.1475	24.16	3807496.0
2016-07-08 14:00:00	AAPL	Stock	24.1612	24.17	24.125	24.1525	4891244.0
2016-07-08 14:30:00	AAPL	Stock	24.15	24.1737	24.135	24.1562	5219528.0
2016-07-08 15:00:00	AAPL	Stock	24.155	24.1875	24.1485	24.1585	7320932.0
2016-07-08 15:30:00	AAPL	Stock	24.1598	24.1762	24.145	24.17	14144600.0
2016-07-08 16:00:00	AAPL	Stock	24.1678	24.1725	24.125	24.1475	10007772.0
2016-07-08 16:30:00	AAPL	Stock	24.17	24.17	24.14	24.15	37216.0
2016-07-08 17:00:00	AAPL	Stock	24.145	24.15	24.1425	24.15	47120.0
2016-07-08 17:30:00	AAPL	Stock	24.15	24.1575	24.1425	24.145	26440.0
2016-07-08 18:00:00	AAPL	Stock	24.145	24.15	24.145	24.145	35668.0
2016-07-08 18:30:00	AAPL	Stock	24.1525	24.1575	24.145	24.145	35400.0
2016-07-08 19:00:00	AAPL	Stock	24.155	24.155	24.15	24.15	1200.0
2016-07-08 19:30:00	AAPL	Stock	24.1575	24.1575	24.15	24.15	4516.0
2016-07-08 06:00:00	MSFT	Stock	51.42	51.42	51.42	51.42	300.0
2016-07-08 07:00:00	MSFT	Stock	51.56	51.56	51.56	51.56	240.0
2016-07-08 08:00:00	MSFT	Stock	51.56	51.56	51.45	51.45	1012.0
2016-07-08 08:30:00	MSFT	Stock	51.5	51.68	51.5	51.65	25527.0
2016-07-08 09:00:00	MSFT	Stock	51.6	51.72	51.6	51.72	21400.0
2016-07-08 09:30:00	MSFT	Stock	51.73	52.155	51.55	52.01	3351597.0
2016-07-08 10:00:00	MSFT	Stock	52.02	52.15	51.93	52.09	2106669.0
2016-07-08 10:30:00	MSFT	Stock	52.09	52.26	52.0	52.24	1661764.0
2016-07-08 11:00:00	MSFT	Stock	52.25	52.3	52.19	52.25	2090187.0
2016-07-08 11:30:00	MSFT	Stock	52.255	52.36	52.24	52.315	1342141.0
2016-07-08 12:00:00	MSFT	Stock	52.32	52.355	52.21	52.23	1225996.0
2016-07-08 12:30:00	MSFT	Stock	52.23	52.33	52.21	52.26	1169372.0
2016-07-08 13:00:00	MSFT	Stock	52.26	52.31	52.23	52.284	794210.0
2016-07-08 13:30:00	MSFT	Stock	52.28	52.32	52.23	52.235	892006.0
2016-07-08 14:00:00	MSFT	Stock	52.235	52.36	52.21	52.307	1280470.0
2016-07-08 14:30:00	MSFT	Stock	52.305	52.35	52.26	52.3	1612958.0
2016-07-08 15:00:00	MSFT	Stock	52.3	52.35	52.25	52.255	2049690.0
2016-07-08 15:30:00	MSFT	Stock	52.25	52.31	52.18	52.3	3962346.0

> showing 50 of 81,973 rows — these rows as CSV

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