PREVIEW / stock_30min / 2017-03-17

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-17.parquet
  size:    1.6 MB
  rows:    83,039
  symbols: 3,084

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
2017-03-17 04:30:00	AAPL	Stock	35.1375	35.1725	35.1375	35.1725	5800.0
2017-03-17 05:00:00	AAPL	Stock	35.1725	35.1725	35.1725	35.1725	2000.0
2017-03-17 05:30:00	AAPL	Stock	35.1725	35.1725	35.1725	35.1725	660.0
2017-03-17 06:30:00	AAPL	Stock	35.15	35.15	35.15	35.15	656.0
2017-03-17 07:00:00	AAPL	Stock	35.1525	35.1525	35.1525	35.1525	492.0
2017-03-17 07:30:00	AAPL	Stock	35.185	35.2025	35.165	35.165	13760.0
2017-03-17 08:00:00	AAPL	Stock	35.1875	35.1875	35.1425	35.165	15328.0
2017-03-17 08:30:00	AAPL	Stock	35.1725	35.225	35.1725	35.225	163844.0
2017-03-17 09:00:00	AAPL	Stock	35.2075	35.275	35.165	35.2375	601392.0
2017-03-17 09:30:00	AAPL	Stock	35.225	35.25	35.145	35.147	46277476.0
2017-03-17 10:00:00	AAPL	Stock	35.1475	35.1675	35.125	35.13	4475208.0
2017-03-17 10:30:00	AAPL	Stock	35.13	35.1725	35.1045	35.16	3720308.0
2017-03-17 11:00:00	AAPL	Stock	35.1612	35.17	35.1275	35.1425	2699060.0
2017-03-17 11:30:00	AAPL	Stock	35.145	35.1675	35.115	35.15	2709244.0
2017-03-17 12:00:00	AAPL	Stock	35.1502	35.17	35.1425	35.1652	2617032.0
2017-03-17 12:30:00	AAPL	Stock	35.1662	35.21	35.15	35.1875	3446672.0
2017-03-17 13:00:00	AAPL	Stock	35.1865	35.2175	35.1775	35.2142	2196576.0
2017-03-17 13:30:00	AAPL	Stock	35.2125	35.2225	35.18	35.18	1988664.0
2017-03-17 14:00:00	AAPL	Stock	35.18	35.2375	35.18	35.22	2994516.0
2017-03-17 14:30:00	AAPL	Stock	35.22	35.2275	35.1825	35.1925	2989972.0
2017-03-17 15:00:00	AAPL	Stock	35.1925	35.21	35.0925	35.1	5015408.0
2017-03-17 15:30:00	AAPL	Stock	35.098	35.1075	34.9725	34.9775	17966760.0
2017-03-17 16:00:00	AAPL	Stock	34.98	35.015	34.9775	35.0	61859096.0
2017-03-17 16:30:00	AAPL	Stock	35.0	35.03	34.9975	35.005	296036.0
2017-03-17 17:00:00	AAPL	Stock	35.005	35.0075	34.9975	35.0	221548.0
2017-03-17 17:30:00	AAPL	Stock	35.015	35.025	35.0125	35.0125	14800.0
2017-03-17 18:00:00	AAPL	Stock	35.0075	35.0125	35.0025	35.0075	8764.0
2017-03-17 18:30:00	AAPL	Stock	35.0075	35.01	35.0075	35.0075	3008.0
2017-03-17 19:00:00	AAPL	Stock	35.005	35.005	35.0	35.0	6012.0
2017-03-17 19:30:00	AAPL	Stock	35.0	35.0	34.99	35.0	41404.0
2017-03-17 08:30:00	MSFT	Stock	64.67	64.67	64.67	64.67	477.0
2017-03-17 09:00:00	MSFT	Stock	64.67	64.94	64.67	64.88	370688.0
2017-03-17 09:30:00	MSFT	Stock	64.87	65.05	64.68	64.99	16691686.0
2017-03-17 10:00:00	MSFT	Stock	64.98	64.987	64.86	64.94	1674416.0
2017-03-17 10:30:00	MSFT	Stock	64.93	65.08	64.912	65.025	2230862.0
2017-03-17 11:00:00	MSFT	Stock	65.03	65.03	64.885	64.94	1308795.0
2017-03-17 11:30:00	MSFT	Stock	64.94	65.04	64.89	65.03	1013070.0
2017-03-17 12:00:00	MSFT	Stock	65.032	65.07	65.005	65.03	885810.0
2017-03-17 12:30:00	MSFT	Stock	65.025	65.07	65.0	65.039	695006.0
2017-03-17 13:00:00	MSFT	Stock	65.035	65.08	65.02	65.07	606837.0
2017-03-17 13:30:00	MSFT	Stock	65.06	65.1	65.01	65.08	745659.0
2017-03-17 14:00:00	MSFT	Stock	65.08	65.24	65.075	65.175	1485229.0
2017-03-17 14:30:00	MSFT	Stock	65.18	65.19	65.08	65.105	889838.0
2017-03-17 15:00:00	MSFT	Stock	65.11	65.125	65.0	65.045	1091149.0
2017-03-17 15:30:00	MSFT	Stock	65.045	65.05	64.85	64.85	5250989.0
2017-03-17 16:00:00	MSFT	Stock	64.87	65.043	64.82	64.87	10522423.0
2017-03-17 16:30:00	MSFT	Stock	64.88	64.95	64.85	64.85	4447.0
2017-03-17 17:00:00	MSFT	Stock	64.95	64.95	64.83	64.83	75448.0
2017-03-17 17:30:00	MSFT	Stock	64.94	64.94	64.94	64.94	350.0
2017-03-17 19:00:00	MSFT	Stock	64.91	64.91	64.91	64.91	300.0

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

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