PREVIEW / stock_30min / 2017-09-26

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-26.parquet
  size:    1.6 MB
  rows:    80,621
  symbols: 2,951

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-09-26 04:00:00	AAPL	Stock	37.6475	37.72	37.6475	37.72	10044.0
2017-09-26 04:30:00	AAPL	Stock	37.735	37.8	37.735	37.7925	8336.0
2017-09-26 05:00:00	AAPL	Stock	37.795	37.8375	37.775	37.8375	22060.0
2017-09-26 05:30:00	AAPL	Stock	37.8375	37.885	37.8325	37.8625	34828.0
2017-09-26 06:00:00	AAPL	Stock	37.86	37.86	37.8175	37.8475	15548.0
2017-09-26 06:30:00	AAPL	Stock	37.8475	37.895	37.8475	37.875	62892.0
2017-09-26 07:00:00	AAPL	Stock	37.88	37.9475	37.8275	37.9275	132604.0
2017-09-26 07:30:00	AAPL	Stock	37.9275	38.0	37.9	37.9	323876.0
2017-09-26 08:00:00	AAPL	Stock	37.9475	37.9975	37.8275	37.9275	416004.0
2017-09-26 08:30:00	AAPL	Stock	37.9575	38.0	37.94	37.975	307764.0
2017-09-26 09:00:00	AAPL	Stock	37.9625	37.985	37.9375	37.9625	335660.0
2017-09-26 09:30:00	AAPL	Stock	37.9475	38.1925	37.9225	38.04	20412604.0
2017-09-26 10:00:00	AAPL	Stock	38.0418	38.2375	38.035	38.145	10157456.0
2017-09-26 10:30:00	AAPL	Stock	38.147	38.255	38.0875	38.13	10525228.0
2017-09-26 11:00:00	AAPL	Stock	38.13	38.13	37.945	38.0198	11426424.0
2017-09-26 11:30:00	AAPL	Stock	38.02	38.13	37.992	38.13	6173332.0
2017-09-26 12:00:00	AAPL	Stock	38.13	38.1925	38.0788	38.125	5726788.0
2017-09-26 12:30:00	AAPL	Stock	38.1262	38.1725	38.025	38.14	5313480.0
2017-09-26 13:00:00	AAPL	Stock	38.1425	38.38	38.1405	38.3525	8991892.0
2017-09-26 13:30:00	AAPL	Stock	38.3525	38.4525	38.335	38.4275	6808948.0
2017-09-26 14:00:00	AAPL	Stock	38.4275	38.48	38.3775	38.4475	6556356.0
2017-09-26 14:30:00	AAPL	Stock	38.4425	38.4625	38.328	38.3412	6006008.0
2017-09-26 15:00:00	AAPL	Stock	38.3425	38.4525	38.3425	38.4235	5658672.0
2017-09-26 15:30:00	AAPL	Stock	38.4225	38.4275	38.26	38.305	12511116.0
2017-09-26 16:00:00	AAPL	Stock	38.3175	38.3275	38.275	38.3225	8342972.0
2017-09-26 16:30:00	AAPL	Stock	38.285	38.325	38.285	38.315	64088.0
2017-09-26 17:00:00	AAPL	Stock	38.295	38.3175	38.28	38.295	24604.0
2017-09-26 17:30:00	AAPL	Stock	38.2975	38.3	38.285	38.2975	7940.0
2017-09-26 18:00:00	AAPL	Stock	38.2975	38.3225	38.2825	38.3013	28120.0
2017-09-26 18:30:00	AAPL	Stock	38.3025	38.315	38.295	38.315	10480.0
2017-09-26 19:00:00	AAPL	Stock	38.305	38.3175	38.3	38.315	11600.0
2017-09-26 19:30:00	AAPL	Stock	38.3225	38.3425	38.3175	38.3425	67484.0
2017-09-26 04:00:00	MSFT	Stock	73.5	73.77	73.5	73.77	2958.0
2017-09-26 04:30:00	MSFT	Stock	73.67	73.68	73.67	73.67	800.0
2017-09-26 06:00:00	MSFT	Stock	73.7	73.7	73.68	73.68	200.0
2017-09-26 06:30:00	MSFT	Stock	73.51	73.7	73.51	73.51	3063.0
2017-09-26 07:00:00	MSFT	Stock	73.61	73.61	73.61	73.61	5000.0
2017-09-26 07:30:00	MSFT	Stock	73.6	73.6	73.52	73.54	3760.0
2017-09-26 08:00:00	MSFT	Stock	73.67	73.67	73.5	73.58	2878.0
2017-09-26 08:30:00	MSFT	Stock	73.58	73.71	73.58	73.71	2200.0
2017-09-26 09:00:00	MSFT	Stock	73.71	73.71	73.65	73.68	2411.0
2017-09-26 09:30:00	MSFT	Stock	73.67	73.739	73.475	73.66	1544467.0
2017-09-26 10:00:00	MSFT	Stock	73.66	73.81	73.54	73.67	794859.0
2017-09-26 10:30:00	MSFT	Stock	73.665	73.69	73.31	73.38	955913.0
2017-09-26 11:00:00	MSFT	Stock	73.39	73.396	73.04	73.07	1547020.0
2017-09-26 11:30:00	MSFT	Stock	73.07	73.16	72.99	73.025	855893.0
2017-09-26 12:00:00	MSFT	Stock	73.025	73.21	73.02	73.21	517647.0
2017-09-26 12:30:00	MSFT	Stock	73.21	73.32	73.01	73.25	688066.0
2017-09-26 13:00:00	MSFT	Stock	73.24	73.45	73.22	73.36	741583.0
2017-09-26 13:30:00	MSFT	Stock	73.351	73.54	73.35	73.43	816715.0

> showing 50 of 80,621 rows — these rows as CSV

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