PREVIEW / stock_30min / 2018-08-27

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-27.parquet
  size:    1.7 MB
  rows:    84,112
  symbols: 2,810

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-08-27 04:00:00	AAPL	Stock	54.195	54.2625	54.195	54.2625	14456.0
2018-08-27 04:30:00	AAPL	Stock	54.2175	54.2175	54.2175	54.2175	400.0
2018-08-27 05:00:00	AAPL	Stock	54.2625	54.2625	54.2625	54.2625	400.0
2018-08-27 06:00:00	AAPL	Stock	54.26	54.2875	54.25	54.25	6444.0
2018-08-27 06:30:00	AAPL	Stock	54.25	54.2725	54.2475	54.2475	6308.0
2018-08-27 07:00:00	AAPL	Stock	54.225	54.2625	54.215	54.25	75440.0
2018-08-27 07:30:00	AAPL	Stock	54.25	54.25	54.1975	54.205	66552.0
2018-08-27 08:00:00	AAPL	Stock	54.25	54.2775	54.1975	54.275	210520.0
2018-08-27 08:30:00	AAPL	Stock	54.275	54.285	54.2275	54.2475	85256.0
2018-08-27 09:00:00	AAPL	Stock	54.24	54.3225	54.24	54.295	136600.0
2018-08-27 09:30:00	AAPL	Stock	54.2875	54.43	54.0825	54.245	11897668.0
2018-08-27 10:00:00	AAPL	Stock	54.2525	54.4375	54.1775	54.4275	8128344.0
2018-08-27 10:30:00	AAPL	Stock	54.4225	54.48	54.36	54.4785	4796608.0
2018-08-27 11:00:00	AAPL	Stock	54.4775	54.575	54.4475	54.5175	5167552.0
2018-08-27 11:30:00	AAPL	Stock	54.5125	54.685	54.4325	54.6388	5734324.0
2018-08-27 12:00:00	AAPL	Stock	54.64	54.66	54.5882	54.615	3367256.0
2018-08-27 12:30:00	AAPL	Stock	54.6175	54.62	54.4922	54.575	3037308.0
2018-08-27 13:00:00	AAPL	Stock	54.5732	54.5775	54.505	54.525	2021900.0
2018-08-27 13:30:00	AAPL	Stock	54.5245	54.595	54.515	54.5525	1908740.0
2018-08-27 14:00:00	AAPL	Stock	54.5538	54.5875	54.5275	54.5775	2043732.0
2018-08-27 14:30:00	AAPL	Stock	54.5775	54.605	54.5325	54.5762	2305940.0
2018-08-27 15:00:00	AAPL	Stock	54.5762	54.5775	54.43	54.5325	4445684.0
2018-08-27 15:30:00	AAPL	Stock	54.53	54.53	54.3875	54.4975	7710060.0
2018-08-27 16:00:00	AAPL	Stock	54.485	54.5	54.465	54.47	7783228.0
2018-08-27 16:30:00	AAPL	Stock	54.4925	54.4925	54.4675	54.4875	18616.0
2018-08-27 17:00:00	AAPL	Stock	54.4875	54.5	54.475	54.5	12284.0
2018-08-27 17:30:00	AAPL	Stock	54.5	54.5	54.49	54.5	9412.0
2018-08-27 18:00:00	AAPL	Stock	54.5	54.5025	54.49	54.5025	21400.0
2018-08-27 18:30:00	AAPL	Stock	54.51	54.515	54.5	54.5025	4768.0
2018-08-27 19:00:00	AAPL	Stock	54.515	54.54	54.515	54.525	21884.0
2018-08-27 19:30:00	AAPL	Stock	54.53	54.54	54.5275	54.54	14560.0
2018-08-27 04:00:00	MSFT	Stock	108.46	108.5	108.46	108.5	300.0
2018-08-27 04:30:00	MSFT	Stock	108.95	108.95	108.95	108.95	100.0
2018-08-27 06:00:00	MSFT	Stock	108.9	108.9	108.9	108.9	300.0
2018-08-27 07:00:00	MSFT	Stock	108.9	108.98	108.63	108.98	2060.0
2018-08-27 07:30:00	MSFT	Stock	108.71	108.96	108.66	108.9	5057.0
2018-08-27 08:00:00	MSFT	Stock	108.99	109.0	108.65	109.0	17416.0
2018-08-27 08:30:00	MSFT	Stock	109.04	109.1	108.99	109.08	4950.0
2018-08-27 09:00:00	MSFT	Stock	109.0	109.24	108.94	109.2	13706.0
2018-08-27 09:30:00	MSFT	Stock	109.27	109.28	108.51	108.75	2319904.0
2018-08-27 10:00:00	MSFT	Stock	108.75	109.07	108.59	109.03	1332566.0
2018-08-27 10:30:00	MSFT	Stock	109.04	109.32	108.99	109.255	1425526.0
2018-08-27 11:00:00	MSFT	Stock	109.251	109.28	108.96	109.05	959556.0
2018-08-27 11:30:00	MSFT	Stock	109.055	109.27	108.86	109.215	820917.0
2018-08-27 12:00:00	MSFT	Stock	109.22	109.34	109.125	109.305	774617.0
2018-08-27 12:30:00	MSFT	Stock	109.31	109.36	109.13	109.215	704727.0
2018-08-27 13:00:00	MSFT	Stock	109.211	109.225	109.075	109.165	508656.0
2018-08-27 13:30:00	MSFT	Stock	109.162	109.38	109.162	109.345	537013.0
2018-08-27 14:00:00	MSFT	Stock	109.345	109.41	109.29	109.37	653583.0
2018-08-27 14:30:00	MSFT	Stock	109.374	109.42	109.25	109.34	560321.0

> showing 50 of 84,112 rows — these rows as CSV

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