PREVIEW / stock_30min / 2018-01-02

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-02.parquet
  size:    1.7 MB
  rows:    86,482
  symbols: 2,929

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
2018-01-02 04:00:00	AAPL	Stock	42.275	42.2775	42.275	42.2775	7348.0
2018-01-02 04:30:00	AAPL	Stock	42.3	42.3	42.275	42.295	25092.0
2018-01-02 05:00:00	AAPL	Stock	42.3125	42.3225	42.25	42.2975	19108.0
2018-01-02 05:30:00	AAPL	Stock	42.3375	42.3375	42.3375	42.3375	400.0
2018-01-02 06:00:00	AAPL	Stock	42.335	42.335	42.335	42.335	19456.0
2018-01-02 06:30:00	AAPL	Stock	42.37	42.4175	42.37	42.4175	26104.0
2018-01-02 07:00:00	AAPL	Stock	42.38	42.4625	42.3775	42.4625	51920.0
2018-01-02 07:30:00	AAPL	Stock	42.4875	42.55	42.4875	42.5125	83712.0
2018-01-02 08:00:00	AAPL	Stock	42.5025	42.53	42.3825	42.5125	222184.0
2018-01-02 08:30:00	AAPL	Stock	42.5225	42.5475	42.5	42.53	205244.0
2018-01-02 09:00:00	AAPL	Stock	42.5375	42.5825	42.5125	42.555	252100.0
2018-01-02 09:30:00	AAPL	Stock	42.54	42.7675	42.315	42.745	20464572.0
2018-01-02 10:00:00	AAPL	Stock	42.7425	42.895	42.715	42.89	9083088.0
2018-01-02 10:30:00	AAPL	Stock	42.885	42.9	42.8025	42.8762	6934684.0
2018-01-02 11:00:00	AAPL	Stock	42.875	42.8825	42.7925	42.8192	5606260.0
2018-01-02 11:30:00	AAPL	Stock	42.8188	42.835	42.775	42.8025	4042844.0
2018-01-02 12:00:00	AAPL	Stock	42.8013	42.875	42.7975	42.8425	3669948.0
2018-01-02 12:30:00	AAPL	Stock	42.8405	42.8525	42.805	42.82	2505568.0
2018-01-02 13:00:00	AAPL	Stock	42.8225	42.8975	42.821	42.885	3362496.0
2018-01-02 13:30:00	AAPL	Stock	42.8838	42.925	42.8725	42.9222	3452856.0
2018-01-02 14:00:00	AAPL	Stock	42.92	43.0275	42.915	42.9775	6411188.0
2018-01-02 14:30:00	AAPL	Stock	42.975	43.0225	42.975	42.995	3392520.0
2018-01-02 15:00:00	AAPL	Stock	42.995	42.9975	42.925	42.9625	4167192.0
2018-01-02 15:30:00	AAPL	Stock	42.965	43.075	42.9585	43.065	9043316.0
2018-01-02 16:00:00	AAPL	Stock	43.065	43.065	43.005	43.03	8016576.0
2018-01-02 16:30:00	AAPL	Stock	43.03	43.065	43.03	43.05	65384.0
2018-01-02 17:00:00	AAPL	Stock	43.035	43.065	43.01	43.025	893768.0
2018-01-02 17:30:00	AAPL	Stock	43.025	43.06	43.025	43.0275	50516.0
2018-01-02 18:00:00	AAPL	Stock	43.03	43.0575	43.01	43.0175	35692.0
2018-01-02 18:30:00	AAPL	Stock	43.0075	43.0375	43.0075	43.0375	12312.0
2018-01-02 19:00:00	AAPL	Stock	43.0125	43.0625	43.0125	43.0625	11104.0
2018-01-02 19:30:00	AAPL	Stock	43.045	43.075	43.045	43.075	28184.0
2018-01-02 04:30:00	MSFT	Stock	85.55	85.55	85.55	85.55	100.0
2018-01-02 07:00:00	MSFT	Stock	85.6	85.9	85.6	85.9	670.0
2018-01-02 07:30:00	MSFT	Stock	85.85	85.88	85.85	85.88	1800.0
2018-01-02 08:00:00	MSFT	Stock	85.6	86.0	85.6	85.95	9896.0
2018-01-02 08:30:00	MSFT	Stock	85.93	86.0	85.54	85.94	15394.0
2018-01-02 09:00:00	MSFT	Stock	85.9	86.24	85.88	86.2	43479.0
2018-01-02 09:30:00	MSFT	Stock	86.23	86.31	85.59	86.17	2607507.0
2018-01-02 10:00:00	MSFT	Stock	86.155	86.22	85.92	86.195	1558705.0
2018-01-02 10:30:00	MSFT	Stock	86.2	86.23	85.96	86.0	1661345.0
2018-01-02 11:00:00	MSFT	Stock	86.0	86.025	85.83	85.855	1344989.0
2018-01-02 11:30:00	MSFT	Stock	85.86	85.94	85.7	85.706	804128.0
2018-01-02 12:00:00	MSFT	Stock	85.71	85.75	85.6	85.61	747144.0
2018-01-02 12:30:00	MSFT	Stock	85.609	85.63	85.5	85.574	814296.0
2018-01-02 13:00:00	MSFT	Stock	85.58	85.73	85.555	85.715	985832.0
2018-01-02 13:30:00	MSFT	Stock	85.72	85.8	85.67	85.745	713226.0
2018-01-02 14:00:00	MSFT	Stock	85.74	85.89	85.72	85.793	987585.0
2018-01-02 14:30:00	MSFT	Stock	85.795	85.82	85.67	85.72	686176.0
2018-01-02 15:00:00	MSFT	Stock	85.725	85.83	85.71	85.83	790864.0

> showing 50 of 86,482 rows — these rows as CSV

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