PREVIEW / stock_5min / 2018-12-31

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-12-31.parquet
  size:    6.1 MB
  rows:    383,042
  symbols: 2,761

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-12-31 04:00:00	AAPL	Stock	39.32	39.39	39.32	39.375	3200.0
2018-12-31 04:35:00	AAPL	Stock	39.3525	39.3525	39.3525	39.3525	400.0
2018-12-31 04:50:00	AAPL	Stock	39.47	39.47	39.47	39.47	1216.0
2018-12-31 05:05:00	AAPL	Stock	39.455	39.455	39.455	39.455	800.0
2018-12-31 05:55:00	AAPL	Stock	39.4375	39.4375	39.4375	39.4375	3848.0
2018-12-31 06:10:00	AAPL	Stock	39.4125	39.4125	39.4125	39.4125	580.0
2018-12-31 06:15:00	AAPL	Stock	39.445	39.445	39.4375	39.4375	2400.0
2018-12-31 06:20:00	AAPL	Stock	39.45	39.495	39.45	39.495	2080.0
2018-12-31 06:30:00	AAPL	Stock	39.49	39.49	39.49	39.49	400.0
2018-12-31 06:40:00	AAPL	Stock	39.495	39.495	39.495	39.495	400.0
2018-12-31 07:00:00	AAPL	Stock	39.5	39.525	39.4875	39.525	6664.0
2018-12-31 07:05:00	AAPL	Stock	39.525	39.625	39.525	39.625	30348.0
2018-12-31 07:10:00	AAPL	Stock	39.6025	39.6925	39.6025	39.65	18972.0
2018-12-31 07:15:00	AAPL	Stock	39.6625	39.6625	39.6125	39.6275	14088.0
2018-12-31 07:20:00	AAPL	Stock	39.6025	39.6025	39.5575	39.5575	5544.0
2018-12-31 07:25:00	AAPL	Stock	39.5775	39.6725	39.5775	39.625	8540.0
2018-12-31 07:30:00	AAPL	Stock	39.595	39.66	39.5275	39.5325	19104.0
2018-12-31 07:35:00	AAPL	Stock	39.5375	39.6	39.5375	39.595	5112.0
2018-12-31 07:40:00	AAPL	Stock	39.6	39.6	39.555	39.575	6136.0
2018-12-31 07:45:00	AAPL	Stock	39.575	39.6	39.575	39.6	2000.0
2018-12-31 07:50:00	AAPL	Stock	39.6	39.6	39.58	39.5825	19200.0
2018-12-31 07:55:00	AAPL	Stock	39.585	39.625	39.585	39.6125	9468.0
2018-12-31 08:00:00	AAPL	Stock	39.4838	39.6975	39.4675	39.5875	108584.0
2018-12-31 08:05:00	AAPL	Stock	39.5825	39.585	39.49	39.49	41724.0
2018-12-31 08:10:00	AAPL	Stock	39.5	39.5	39.4325	39.48	33548.0
2018-12-31 08:15:00	AAPL	Stock	39.475	39.5	39.0575	39.5	620796.0
2018-12-31 08:20:00	AAPL	Stock	39.495	39.55	39.475	39.5375	26344.0
2018-12-31 08:25:00	AAPL	Stock	39.51	39.55	39.5	39.545	14164.0
2018-12-31 08:30:00	AAPL	Stock	39.51	39.51	39.455	39.4825	19248.0
2018-12-31 08:35:00	AAPL	Stock	39.5	39.5	39.47	39.475	22400.0
2018-12-31 08:40:00	AAPL	Stock	39.4925	39.5125	39.475	39.48	45384.0
2018-12-31 08:45:00	AAPL	Stock	39.485	39.5075	39.48	39.5	20904.0
2018-12-31 08:50:00	AAPL	Stock	39.5	39.5	39.48	39.48	20904.0
2018-12-31 08:55:00	AAPL	Stock	39.495	39.5	39.48	39.4875	31464.0
2018-12-31 09:00:00	AAPL	Stock	39.4975	39.4975	39.48	39.4875	23664.0
2018-12-31 09:05:00	AAPL	Stock	39.485	39.52	39.48	39.5075	42948.0
2018-12-31 09:10:00	AAPL	Stock	39.5075	39.5375	39.5075	39.5175	31512.0
2018-12-31 09:15:00	AAPL	Stock	39.525	39.5435	39.515	39.515	16060.0
2018-12-31 09:20:00	AAPL	Stock	39.525	39.545	39.5125	39.525	35596.0
2018-12-31 09:25:00	AAPL	Stock	39.5175	39.6775	39.5125	39.6275	104296.0
2018-12-31 09:30:00	AAPL	Stock	39.625	39.7125	39.49	39.6772	4594960.0
2018-12-31 09:35:00	AAPL	Stock	39.6725	39.84	39.67	39.76	3369148.0
2018-12-31 09:40:00	AAPL	Stock	39.761	39.7925	39.675	39.6932	1981856.0
2018-12-31 09:45:00	AAPL	Stock	39.695	39.7192	39.573	39.5775	1969196.0
2018-12-31 09:50:00	AAPL	Stock	39.5795	39.5825	39.4175	39.4375	2195444.0
2018-12-31 09:55:00	AAPL	Stock	39.435	39.485	39.37	39.4825	2458104.0
2018-12-31 10:00:00	AAPL	Stock	39.48	39.5575	39.4775	39.5028	1784052.0
2018-12-31 10:05:00	AAPL	Stock	39.4975	39.56	39.3625	39.3675	2041320.0
2018-12-31 10:10:00	AAPL	Stock	39.365	39.4225	39.25	39.2575	2346380.0
2018-12-31 10:15:00	AAPL	Stock	39.2575	39.2925	39.22	39.2712	1671304.0

> showing 50 of 383,042 rows — these rows as CSV

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