PREVIEW / stock_30min / 2018-04-27

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-27.parquet
  size:    1.6 MB
  rows:    81,144
  symbols: 2,848

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-04-27 05:00:00	AAPL	Stock	41.2	41.2025	41.175	41.2025	13644.0
2018-04-27 05:30:00	AAPL	Stock	41.205	41.205	41.205	41.205	400.0
2018-04-27 06:00:00	AAPL	Stock	41.2	41.2275	41.2	41.2275	800.0
2018-04-27 06:30:00	AAPL	Stock	41.2425	41.2425	41.2225	41.225	4828.0
2018-04-27 07:00:00	AAPL	Stock	41.225	41.225	41.18	41.1975	38024.0
2018-04-27 07:30:00	AAPL	Stock	41.1975	41.2175	41.175	41.2175	18176.0
2018-04-27 08:00:00	AAPL	Stock	41.205	41.29	41.1775	41.2	135620.0
2018-04-27 08:30:00	AAPL	Stock	41.2325	41.245	41.1525	41.235	141096.0
2018-04-27 09:00:00	AAPL	Stock	41.2325	41.2375	40.95	41.0175	256052.0
2018-04-27 09:30:00	AAPL	Stock	41.0	41.0825	40.485	40.51	24412504.0
2018-04-27 10:00:00	AAPL	Stock	40.505	40.545	40.1575	40.4035	21550424.0
2018-04-27 10:30:00	AAPL	Stock	40.4075	40.4925	40.2525	40.4275	11203896.0
2018-04-27 11:00:00	AAPL	Stock	40.4238	40.6475	40.4125	40.62	9618268.0
2018-04-27 11:30:00	AAPL	Stock	40.6175	40.6175	40.3825	40.4225	6271572.0
2018-04-27 12:00:00	AAPL	Stock	40.4225	40.555	40.405	40.44	5245492.0
2018-04-27 12:30:00	AAPL	Stock	40.44	40.58	40.36	40.5775	5101900.0
2018-04-27 13:00:00	AAPL	Stock	40.58	40.7025	40.55	40.6012	4168120.0
2018-04-27 13:30:00	AAPL	Stock	40.6025	40.6612	40.525	40.5513	3579604.0
2018-04-27 14:00:00	AAPL	Stock	40.5525	40.665	40.5325	40.66	3995756.0
2018-04-27 14:30:00	AAPL	Stock	40.66	40.8025	40.635	40.7125	5721620.0
2018-04-27 15:00:00	AAPL	Stock	40.7125	40.7825	40.6375	40.6625	5193928.0
2018-04-27 15:30:00	AAPL	Stock	40.6625	40.7975	40.5625	40.5825	14477616.0
2018-04-27 16:00:00	AAPL	Stock	40.58	40.615	40.5075	40.6025	7796444.0
2018-04-27 16:30:00	AAPL	Stock	40.6025	40.62	40.55	40.6	192960.0
2018-04-27 17:00:00	AAPL	Stock	40.6225	40.625	40.5925	40.6	24360.0
2018-04-27 17:30:00	AAPL	Stock	40.575	40.61	40.555	40.605	3756.0
2018-04-27 18:00:00	AAPL	Stock	40.6125	40.625	40.5875	40.5875	44972.0
2018-04-27 18:30:00	AAPL	Stock	40.59	40.6225	40.5525	40.575	33160.0
2018-04-27 19:00:00	AAPL	Stock	40.575	40.575	40.555	40.5625	16540.0
2018-04-27 19:30:00	AAPL	Stock	40.5375	40.5725	40.535	40.5425	33292.0
2018-04-27 04:00:00	MSFT	Stock	96.03	96.09	96.03	96.05	1414.0
2018-04-27 04:30:00	MSFT	Stock	96.05	96.99	96.05	96.99	10818.0
2018-04-27 05:00:00	MSFT	Stock	97.05	97.4	97.05	97.1	6619.0
2018-04-27 05:30:00	MSFT	Stock	97.2	97.7	97.2	97.6	6088.0
2018-04-27 06:00:00	MSFT	Stock	97.61	97.61	97.58	97.58	688.0
2018-04-27 06:30:00	MSFT	Stock	97.35	97.54	97.25	97.54	1550.0
2018-04-27 07:00:00	MSFT	Stock	97.35	98.3	97.0	98.1	88663.0
2018-04-27 07:30:00	MSFT	Stock	98.17	98.24	97.6	97.6	57080.0
2018-04-27 08:00:00	MSFT	Stock	97.7	98.4	97.25	97.66	193273.0
2018-04-27 08:30:00	MSFT	Stock	97.65	97.92	97.2	97.5	212295.0
2018-04-27 09:00:00	MSFT	Stock	97.5	98.0	97.41	97.55	384175.0
2018-04-27 09:30:00	MSFT	Stock	97.56	97.9	95.01	95.165	11948398.0
2018-04-27 10:00:00	MSFT	Stock	95.18	95.85	94.56	94.71	5177474.0
2018-04-27 10:30:00	MSFT	Stock	94.7	94.81	93.91	94.22	3946797.0
2018-04-27 11:00:00	MSFT	Stock	94.21	95.59	94.16	95.57	3075967.0
2018-04-27 11:30:00	MSFT	Stock	95.565	95.63	94.89	95.0	2274579.0
2018-04-27 12:00:00	MSFT	Stock	95.0	95.615	94.98	95.315	1746796.0
2018-04-27 12:30:00	MSFT	Stock	95.31	95.47	94.85	95.34	1381780.0
2018-04-27 13:00:00	MSFT	Stock	95.34	95.53	95.14	95.165	975610.0
2018-04-27 13:30:00	MSFT	Stock	95.17	95.47	95.1	95.15	1051302.0

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

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