PREVIEW / stock_5min / 2020-01-24

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-01-24.parquet
  size:    6.0 MB
  rows:    368,963
  symbols: 2,440

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
2020-01-24 04:00:00	AAPL	Stock	80.0825	80.125	80.0825	80.125	2396.0
2020-01-24 04:05:00	AAPL	Stock	80.125	80.165	80.125	80.165	1232.0
2020-01-24 04:20:00	AAPL	Stock	80.13	80.13	80.13	80.13	400.0
2020-01-24 04:25:00	AAPL	Stock	80.14	80.14	80.14	80.14	400.0
2020-01-24 04:30:00	AAPL	Stock	80.14	80.16	80.14	80.14	6788.0
2020-01-24 04:50:00	AAPL	Stock	80.1225	80.1225	80.1225	80.1225	500.0
2020-01-24 05:15:00	AAPL	Stock	80.0975	80.0975	80.0975	80.0975	800.0
2020-01-24 05:20:00	AAPL	Stock	80.1	80.1	80.1	80.1	1908.0
2020-01-24 05:25:00	AAPL	Stock	80.075	80.075	80.075	80.075	2000.0
2020-01-24 05:30:00	AAPL	Stock	80.0525	80.0525	80.0475	80.0475	11644.0
2020-01-24 05:40:00	AAPL	Stock	80.05	80.05	80.0475	80.0475	800.0
2020-01-24 05:45:00	AAPL	Stock	80.0475	80.05	80.0475	80.05	1000.0
2020-01-24 05:55:00	AAPL	Stock	80.0475	80.0475	80.04	80.04	2428.0
2020-01-24 06:05:00	AAPL	Stock	80.095	80.095	80.095	80.095	1272.0
2020-01-24 06:10:00	AAPL	Stock	80.05	80.05	80.05	80.05	5200.0
2020-01-24 06:20:00	AAPL	Stock	80.07	80.0725	80.0475	80.0475	3508.0
2020-01-24 06:35:00	AAPL	Stock	80.05	80.075	80.025	80.025	6932.0
2020-01-24 06:40:00	AAPL	Stock	80.05	80.05	80.05	80.05	6216.0
2020-01-24 06:50:00	AAPL	Stock	80.05	80.05	80.05	80.05	2000.0
2020-01-24 06:55:00	AAPL	Stock	80.075	80.075	80.075	80.075	2240.0
2020-01-24 07:00:00	AAPL	Stock	80.075	80.075	79.94	79.995	102764.0
2020-01-24 07:05:00	AAPL	Stock	79.995	80.0	79.9875	79.995	19508.0
2020-01-24 07:10:00	AAPL	Stock	79.99	79.995	79.97	79.97	18968.0
2020-01-24 07:15:00	AAPL	Stock	79.95	79.95	79.95	79.95	3580.0
2020-01-24 07:20:00	AAPL	Stock	79.94	79.9625	79.925	79.9625	50048.0
2020-01-24 07:25:00	AAPL	Stock	79.9625	80.0	79.9425	79.9525	28648.0
2020-01-24 07:30:00	AAPL	Stock	79.9575	79.975	79.9525	79.97	10860.0
2020-01-24 07:35:00	AAPL	Stock	79.97	79.9725	79.95	79.9725	13212.0
2020-01-24 07:40:00	AAPL	Stock	79.9725	79.975	79.9725	79.975	4200.0
2020-01-24 07:45:00	AAPL	Stock	79.9725	79.975	79.9625	79.975	10024.0
2020-01-24 07:50:00	AAPL	Stock	79.97	79.97	79.9325	79.9325	26140.0
2020-01-24 07:55:00	AAPL	Stock	79.9325	79.955	79.9325	79.955	11068.0
2020-01-24 08:00:00	AAPL	Stock	79.945	80.0475	79.93	79.95	157344.0
2020-01-24 08:05:00	AAPL	Stock	79.9575	79.9725	79.95	79.95	22140.0
2020-01-24 08:10:00	AAPL	Stock	79.9725	79.9725	79.9375	79.97	38184.0
2020-01-24 08:15:00	AAPL	Stock	79.975	79.985	79.9525	79.9825	15860.0
2020-01-24 08:20:00	AAPL	Stock	79.9825	79.9825	79.975	79.975	18612.0
2020-01-24 08:25:00	AAPL	Stock	79.955	79.9825	79.95	79.95	30452.0
2020-01-24 08:30:00	AAPL	Stock	79.9625	79.985	79.9525	79.975	40992.0
2020-01-24 08:35:00	AAPL	Stock	79.9825	80.075	79.9825	80.06	215860.0
2020-01-24 08:40:00	AAPL	Stock	80.04	80.065	80.0375	80.0475	70976.0
2020-01-24 08:45:00	AAPL	Stock	80.055	80.075	80.055	80.0625	14764.0
2020-01-24 08:50:00	AAPL	Stock	80.05	80.065	80.031	80.065	37976.0
2020-01-24 08:55:00	AAPL	Stock	80.05	80.0725	80.025	80.055	33392.0
2020-01-24 09:00:00	AAPL	Stock	80.055	80.072	80.0075	80.045	47056.0
2020-01-24 09:05:00	AAPL	Stock	80.02	80.045	80.02	80.045	6080.0
2020-01-24 09:10:00	AAPL	Stock	80.05	80.0725	80.05	80.0525	17360.0
2020-01-24 09:15:00	AAPL	Stock	80.06	80.07	80.0375	80.06	19168.0
2020-01-24 09:20:00	AAPL	Stock	80.0625	80.075	80.0375	80.05	31080.0
2020-01-24 09:25:00	AAPL	Stock	80.05	80.0825	79.975	80.0425	112908.0

> showing 50 of 368,963 rows — these rows as CSV

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