PREVIEW / stock_30min / 2018-01-03

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-03.parquet
  size:    1.7 MB
  rows:    85,341
  symbols: 2,903

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-03 04:00:00	AAPL	Stock	43.165	43.165	43.165	43.165	2880.0
2018-01-03 05:00:00	AAPL	Stock	43.165	43.165	43.165	43.165	400.0
2018-01-03 06:00:00	AAPL	Stock	43.1975	43.1975	43.1875	43.1875	3008.0
2018-01-03 06:30:00	AAPL	Stock	43.1875	43.1875	43.1875	43.1875	18000.0
2018-01-03 07:00:00	AAPL	Stock	43.1875	43.1875	43.125	43.1275	63092.0
2018-01-03 07:30:00	AAPL	Stock	43.1275	43.15	43.125	43.1375	31020.0
2018-01-03 08:00:00	AAPL	Stock	43.1375	43.1625	43.105	43.1375	109228.0
2018-01-03 08:30:00	AAPL	Stock	43.1325	43.15	43.1125	43.125	94372.0
2018-01-03 09:00:00	AAPL	Stock	43.1375	43.185	43.1175	43.13	152008.0
2018-01-03 09:30:00	AAPL	Stock	43.13	43.475	43.045	43.4662	15826720.0
2018-01-03 10:00:00	AAPL	Stock	43.4725	43.6025	43.44	43.5075	10066768.0
2018-01-03 10:30:00	AAPL	Stock	43.51	43.6375	43.475	43.5375	7569984.0
2018-01-03 11:00:00	AAPL	Stock	43.54	43.5725	43.485	43.49	5354988.0
2018-01-03 11:30:00	AAPL	Stock	43.49	43.4925	43.375	43.415	6045952.0
2018-01-03 12:00:00	AAPL	Stock	43.4175	43.4325	43.3525	43.3725	3404840.0
2018-01-03 12:30:00	AAPL	Stock	43.3738	43.38	43.305	43.33	4818396.0
2018-01-03 13:00:00	AAPL	Stock	43.3325	43.3725	43.2725	43.3425	3545640.0
2018-01-03 13:30:00	AAPL	Stock	43.3425	43.3488	43.2325	43.243	3790732.0
2018-01-03 14:00:00	AAPL	Stock	43.245	43.2712	43.1925	43.2182	4467764.0
2018-01-03 14:30:00	AAPL	Stock	43.2192	43.225	43.0825	43.0975	5596404.0
2018-01-03 15:00:00	AAPL	Stock	43.0962	43.1475	43.04	43.065	7275164.0
2018-01-03 15:30:00	AAPL	Stock	43.0675	43.135	42.99	43.045	15045036.0
2018-01-03 16:00:00	AAPL	Stock	43.0625	43.0625	42.9775	43.0575	8936060.0
2018-01-03 16:30:00	AAPL	Stock	43.0	43.0175	42.9875	42.9975	32856.0
2018-01-03 17:00:00	AAPL	Stock	42.9975	43.035	42.985	43.02	121720.0
2018-01-03 17:30:00	AAPL	Stock	43.0175	43.025	43.0025	43.0175	24208.0
2018-01-03 18:00:00	AAPL	Stock	43.025	43.03	42.9875	42.99	94384.0
2018-01-03 18:30:00	AAPL	Stock	42.985	43.0	42.985	43.0	18720.0
2018-01-03 19:00:00	AAPL	Stock	43.0	43.0175	43.0	43.015	25832.0
2018-01-03 19:30:00	AAPL	Stock	43.015	43.015	42.99	43.0	47376.0
2018-01-03 04:00:00	MSFT	Stock	86.3	86.3	86.3	86.3	620.0
2018-01-03 07:00:00	MSFT	Stock	86.01	86.1	86.0	86.1	3090.0
2018-01-03 07:30:00	MSFT	Stock	85.97	86.1	85.97	86.05	2788.0
2018-01-03 08:00:00	MSFT	Stock	86.3	86.3	85.85	85.95	8104.0
2018-01-03 08:30:00	MSFT	Stock	85.95	86.0	85.95	86.0	8691.0
2018-01-03 09:00:00	MSFT	Stock	85.9	86.13	85.86	86.11	6295.0
2018-01-03 09:30:00	MSFT	Stock	86.055	86.505	85.97	86.43	3286555.0
2018-01-03 10:00:00	MSFT	Stock	86.43	86.51	86.31	86.33	1648197.0
2018-01-03 10:30:00	MSFT	Stock	86.33	86.38	86.21	86.225	1005439.0
2018-01-03 11:00:00	MSFT	Stock	86.225	86.33	86.18	86.215	863082.0
2018-01-03 11:30:00	MSFT	Stock	86.22	86.36	86.21	86.29	939833.0
2018-01-03 12:00:00	MSFT	Stock	86.285	86.32	86.06	86.295	1051515.0
2018-01-03 12:30:00	MSFT	Stock	86.295	86.45	86.264	86.38	1215790.0
2018-01-03 13:00:00	MSFT	Stock	86.385	86.43	86.35	86.37	1473573.0
2018-01-03 13:30:00	MSFT	Stock	86.365	86.37	86.22	86.27	657125.0
2018-01-03 14:00:00	MSFT	Stock	86.27	86.35	86.2	86.34	790977.0
2018-01-03 14:30:00	MSFT	Stock	86.34	86.41	86.24	86.4	1043470.0
2018-01-03 15:00:00	MSFT	Stock	86.4	86.42	86.31	86.41	881398.0
2018-01-03 15:30:00	MSFT	Stock	86.42	86.47	86.25	86.33	3368089.0
2018-01-03 16:00:00	MSFT	Stock	86.35	86.44	86.28	86.28	3456247.0

> showing 50 of 85,341 rows — these rows as CSV

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