PREVIEW / stock_5min / 2019-06-21

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-06-21.parquet
  size:    5.7 MB
  rows:    362,020
  symbols: 2,597

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
2019-06-21 04:00:00	AAPL	Stock	49.6875	49.6875	49.625	49.625	2000.0
2019-06-21 04:05:00	AAPL	Stock	49.615	49.615	49.565	49.565	2400.0
2019-06-21 04:15:00	AAPL	Stock	49.65	49.65	49.65	49.65	2400.0
2019-06-21 04:25:00	AAPL	Stock	49.65	49.65	49.65	49.65	1168.0
2019-06-21 04:30:00	AAPL	Stock	49.65	49.675	49.65	49.675	1200.0
2019-06-21 05:25:00	AAPL	Stock	49.625	49.65	49.625	49.65	4120.0
2019-06-21 05:30:00	AAPL	Stock	49.6525	49.655	49.6525	49.655	1600.0
2019-06-21 06:10:00	AAPL	Stock	49.5375	49.5375	49.5375	49.5375	400.0
2019-06-21 06:30:00	AAPL	Stock	49.5225	49.525	49.5025	49.525	1952.0
2019-06-21 06:35:00	AAPL	Stock	49.505	49.505	49.5	49.5	6548.0
2019-06-21 06:55:00	AAPL	Stock	49.5725	49.5725	49.5725	49.5725	2428.0
2019-06-21 07:00:00	AAPL	Stock	49.5525	49.6725	49.5525	49.5925	10180.0
2019-06-21 07:05:00	AAPL	Stock	49.6125	49.625	49.6	49.6125	7232.0
2019-06-21 07:10:00	AAPL	Stock	49.625	49.675	49.625	49.625	3600.0
2019-06-21 07:15:00	AAPL	Stock	49.6625	49.6625	49.6475	49.6475	4196.0
2019-06-21 07:20:00	AAPL	Stock	49.6425	49.6425	49.615	49.625	8808.0
2019-06-21 07:25:00	AAPL	Stock	49.605	49.605	49.495	49.5	39496.0
2019-06-21 07:30:00	AAPL	Stock	49.47	49.5	49.47	49.5	24428.0
2019-06-21 07:35:00	AAPL	Stock	49.5	49.5	49.4925	49.5	12292.0
2019-06-21 07:40:00	AAPL	Stock	49.4975	49.5025	49.465	49.5	18136.0
2019-06-21 07:45:00	AAPL	Stock	49.5075	49.525	49.5025	49.5075	17160.0
2019-06-21 07:50:00	AAPL	Stock	49.54	49.54	49.505	49.515	9560.0
2019-06-21 07:55:00	AAPL	Stock	49.54	49.54	49.5	49.515	31464.0
2019-06-21 08:00:00	AAPL	Stock	49.515	49.6625	49.4375	49.5625	104912.0
2019-06-21 08:05:00	AAPL	Stock	49.56	49.56	49.515	49.515	22960.0
2019-06-21 08:10:00	AAPL	Stock	49.5	49.5625	49.5	49.5025	19300.0
2019-06-21 08:15:00	AAPL	Stock	49.515	49.5725	49.5125	49.5725	4800.0
2019-06-21 08:20:00	AAPL	Stock	49.525	49.57	49.51	49.51	4048.0
2019-06-21 08:25:00	AAPL	Stock	49.54	49.5725	49.51	49.53	17200.0
2019-06-21 08:30:00	AAPL	Stock	49.5425	49.62	49.5425	49.5875	21056.0
2019-06-21 08:35:00	AAPL	Stock	49.5575	49.59	49.5125	49.575	14048.0
2019-06-21 08:40:00	AAPL	Stock	49.58	49.6125	49.58	49.6125	2800.0
2019-06-21 08:45:00	AAPL	Stock	49.62	49.625	49.5875	49.6125	6620.0
2019-06-21 08:50:00	AAPL	Stock	49.6225	49.63	49.575	49.6225	22512.0
2019-06-21 08:55:00	AAPL	Stock	49.62	49.6425	49.62	49.6225	13296.0
2019-06-21 09:00:00	AAPL	Stock	49.625	49.625	49.575	49.5775	23464.0
2019-06-21 09:05:00	AAPL	Stock	49.585	49.619	49.585	49.5875	9036.0
2019-06-21 09:10:00	AAPL	Stock	49.59	49.6425	49.59	49.6275	20488.0
2019-06-21 09:15:00	AAPL	Stock	49.6275	49.7	49.625	49.655	38344.0
2019-06-21 09:20:00	AAPL	Stock	49.695	49.6975	49.6475	49.6475	4952.0
2019-06-21 09:25:00	AAPL	Stock	49.6475	49.75	49.62	49.6225	339956.0
2019-06-21 09:30:00	AAPL	Stock	49.615	49.815	49.5375	49.72	20035644.0
2019-06-21 09:35:00	AAPL	Stock	49.7125	49.7725	49.58	49.6552	2040804.0
2019-06-21 09:40:00	AAPL	Stock	49.6575	49.77	49.645	49.669	1138052.0
2019-06-21 09:45:00	AAPL	Stock	49.675	49.765	49.6525	49.6625	1003484.0
2019-06-21 09:50:00	AAPL	Stock	49.6675	49.7575	49.63	49.7315	1326024.0
2019-06-21 09:55:00	AAPL	Stock	49.725	49.8325	49.7225	49.7625	1266580.0
2019-06-21 10:00:00	AAPL	Stock	49.7625	49.875	49.7575	49.8575	1047628.0
2019-06-21 10:05:00	AAPL	Stock	49.8575	49.955	49.8425	49.931	1231288.0
2019-06-21 10:10:00	AAPL	Stock	49.9275	49.94	49.865	49.895	640272.0

> showing 50 of 362,020 rows — these rows as CSV

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