PREVIEW / stock_30min / 2017-10-18

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-18.parquet
  size:    1.6 MB
  rows:    81,576
  symbols: 2,933

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-10-18 07:00:00	AAPL	Stock	40.1575	40.22	40.1575	40.2175	15812.0
2017-10-18 07:30:00	AAPL	Stock	40.2125	40.2125	40.1775	40.1775	34796.0
2017-10-18 08:00:00	AAPL	Stock	40.22	40.22	40.1625	40.185	114772.0
2017-10-18 08:30:00	AAPL	Stock	40.185	40.2	40.175	40.1825	86724.0
2017-10-18 09:00:00	AAPL	Stock	40.185	40.225	40.0825	40.1075	332788.0
2017-10-18 09:30:00	AAPL	Stock	40.1125	40.1775	39.9525	40.0675	11384516.0
2017-10-18 10:00:00	AAPL	Stock	40.07	40.1112	40.0312	40.07	5511912.0
2017-10-18 10:30:00	AAPL	Stock	40.07	40.1	40.03	40.03	3025892.0
2017-10-18 11:00:00	AAPL	Stock	40.03	40.0425	39.9812	40.0	3393256.0
2017-10-18 11:30:00	AAPL	Stock	40.0	40.025	39.9375	39.9475	3009364.0
2017-10-18 12:00:00	AAPL	Stock	39.9487	40.005	39.945	39.9993	2887004.0
2017-10-18 12:30:00	AAPL	Stock	40.0	40.12	39.9963	40.0925	3410488.0
2017-10-18 13:00:00	AAPL	Stock	40.091	40.0975	39.9975	40.039	2594212.0
2017-10-18 13:30:00	AAPL	Stock	40.04	40.0888	40.04	40.08	1887272.0
2017-10-18 14:00:00	AAPL	Stock	40.08	40.09	40.0475	40.0638	1627556.0
2017-10-18 14:30:00	AAPL	Stock	40.0638	40.08	39.9975	40.02	3969636.0
2017-10-18 15:00:00	AAPL	Stock	40.0188	40.0425	39.99	40.015	3360908.0
2017-10-18 15:30:00	AAPL	Stock	40.015	40.015	39.9	39.9425	8622456.0
2017-10-18 16:00:00	AAPL	Stock	39.94	39.94	39.9125	39.94	3313456.0
2017-10-18 16:30:00	AAPL	Stock	39.93	39.94	39.925	39.9375	30072.0
2017-10-18 17:00:00	AAPL	Stock	39.925	39.94	39.92	39.925	13304.0
2017-10-18 17:30:00	AAPL	Stock	39.92	39.925	39.905	39.9125	17308.0
2017-10-18 18:00:00	AAPL	Stock	39.915	39.915	39.9	39.9	8060.0
2017-10-18 18:30:00	AAPL	Stock	39.9125	39.9225	39.9	39.9225	11860.0
2017-10-18 19:00:00	AAPL	Stock	39.9125	39.925	39.6825	39.7125	89872.0
2017-10-18 19:30:00	AAPL	Stock	39.7125	39.7125	39.5025	39.575	288456.0
2017-10-18 07:00:00	MSFT	Stock	77.78	77.82	77.78	77.82	381.0
2017-10-18 07:30:00	MSFT	Stock	77.82	77.82	77.76	77.77	1350.0
2017-10-18 08:00:00	MSFT	Stock	77.87	77.87	77.77	77.82	10392.0
2017-10-18 08:30:00	MSFT	Stock	77.81	77.81	77.76	77.76	1100.0
2017-10-18 09:00:00	MSFT	Stock	77.76	77.87	77.62	77.65	24378.0
2017-10-18 09:30:00	MSFT	Stock	77.65	77.7	77.37	77.53	1646336.0
2017-10-18 10:00:00	MSFT	Stock	77.54	77.78	77.47	77.73	912363.0
2017-10-18 10:30:00	MSFT	Stock	77.73	77.85	77.725	77.745	621055.0
2017-10-18 11:00:00	MSFT	Stock	77.743	77.75	77.64	77.74	848903.0
2017-10-18 11:30:00	MSFT	Stock	77.75	77.77	77.66	77.66	596635.0
2017-10-18 12:00:00	MSFT	Stock	77.66	77.725	77.66	77.674	351388.0
2017-10-18 12:30:00	MSFT	Stock	77.67	77.709	77.615	77.645	424336.0
2017-10-18 13:00:00	MSFT	Stock	77.65	77.7	77.625	77.67	502550.0
2017-10-18 13:30:00	MSFT	Stock	77.67	77.8	77.64	77.79	910287.0
2017-10-18 14:00:00	MSFT	Stock	77.78	77.79	77.72	77.755	688365.0
2017-10-18 14:30:00	MSFT	Stock	77.755	77.77	77.64	77.695	627046.0
2017-10-18 15:00:00	MSFT	Stock	77.7	77.77	77.65	77.75	667676.0
2017-10-18 15:30:00	MSFT	Stock	77.752	77.82	77.51	77.64	1996548.0
2017-10-18 16:00:00	MSFT	Stock	77.61	77.67	77.61	77.67	1232899.0
2017-10-18 16:30:00	MSFT	Stock	77.65	77.7	77.61	77.7	4385.0
2017-10-18 17:00:00	MSFT	Stock	77.65	77.73	77.65	77.66	1902.0
2017-10-18 17:30:00	MSFT	Stock	77.66	77.66	77.66	77.66	200.0
2017-10-18 04:00:00	NVDA	Stock	4.95	4.95	4.95	4.95	4000.0
2017-10-18 05:30:00	NVDA	Stock	4.9495	4.95	4.9495	4.95	23120.0

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

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