PREVIEW / stock_5min / 2020-07-08

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-07-08.parquet
  size:    6.5 MB
  rows:    411,732
  symbols: 2,421

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-07-08 04:05:00	AAPL	Stock	93.715	93.715	93.715	93.715	400.0
2020-07-08 04:15:00	AAPL	Stock	93.77	93.77	93.77	93.77	800.0
2020-07-08 04:20:00	AAPL	Stock	93.7975	93.85	93.7975	93.85	812.0
2020-07-08 04:30:00	AAPL	Stock	93.85	93.85	93.67	93.67	1600.0
2020-07-08 04:35:00	AAPL	Stock	94.0475	94.0475	94.0475	94.0475	400.0
2020-07-08 04:40:00	AAPL	Stock	93.95	93.95	93.95	93.95	592.0
2020-07-08 04:45:00	AAPL	Stock	94.005	94.005	94.005	94.005	448.0
2020-07-08 04:50:00	AAPL	Stock	94.0125	94.05	94.0125	94.05	1748.0
2020-07-08 04:55:00	AAPL	Stock	93.9375	93.975	93.9375	93.975	800.0
2020-07-08 05:00:00	AAPL	Stock	93.95	93.9525	93.9375	93.9375	2240.0
2020-07-08 05:10:00	AAPL	Stock	93.7875	93.7875	93.7875	93.7875	2608.0
2020-07-08 05:15:00	AAPL	Stock	93.6475	93.6475	93.625	93.625	1272.0
2020-07-08 05:20:00	AAPL	Stock	93.5475	93.5475	93.5	93.5	2000.0
2020-07-08 05:25:00	AAPL	Stock	93.45	93.45	93.45	93.45	400.0
2020-07-08 05:40:00	AAPL	Stock	93.4125	93.4125	93.3875	93.3875	1200.0
2020-07-08 05:55:00	AAPL	Stock	93.44	93.44	93.44	93.44	2800.0
2020-07-08 06:00:00	AAPL	Stock	93.375	93.375	93.375	93.375	496.0
2020-07-08 06:10:00	AAPL	Stock	93.525	93.53	93.525	93.53	2568.0
2020-07-08 06:15:00	AAPL	Stock	93.6	93.625	93.6	93.625	1936.0
2020-07-08 06:20:00	AAPL	Stock	93.605	93.605	93.605	93.605	400.0
2020-07-08 06:30:00	AAPL	Stock	93.72	93.8025	93.715	93.8025	4736.0
2020-07-08 06:35:00	AAPL	Stock	93.8125	93.8125	93.8125	93.8125	720.0
2020-07-08 06:45:00	AAPL	Stock	93.8125	93.8125	93.8125	93.8125	552.0
2020-07-08 06:50:00	AAPL	Stock	93.8425	93.8425	93.8425	93.8425	1160.0
2020-07-08 06:55:00	AAPL	Stock	93.75	93.75	93.75	93.75	400.0
2020-07-08 07:00:00	AAPL	Stock	93.82	94.03	93.82	94.0	47128.0
2020-07-08 07:05:00	AAPL	Stock	93.9925	94.025	93.925	93.925	17580.0
2020-07-08 07:10:00	AAPL	Stock	93.905	93.9975	93.875	93.95	16068.0
2020-07-08 07:15:00	AAPL	Stock	93.9375	93.99	93.9375	93.9825	5964.0
2020-07-08 07:20:00	AAPL	Stock	93.9875	93.9925	93.925	93.9275	16120.0
2020-07-08 07:25:00	AAPL	Stock	93.9275	93.97	93.9275	93.9525	9988.0
2020-07-08 07:30:00	AAPL	Stock	93.95	94.06	93.95	94.06	49572.0
2020-07-08 07:35:00	AAPL	Stock	94.035	94.035	93.9875	93.9875	29804.0
2020-07-08 07:40:00	AAPL	Stock	93.9875	94.0	93.9875	94.0	3344.0
2020-07-08 07:45:00	AAPL	Stock	94.0525	94.0625	94.0325	94.0325	11428.0
2020-07-08 07:50:00	AAPL	Stock	94.0225	94.0525	94.0225	94.05	3900.0
2020-07-08 07:55:00	AAPL	Stock	94.0525	94.075	94.0	94.0	10924.0
2020-07-08 08:00:00	AAPL	Stock	93.75	94.0625	93.405	93.97	149904.0
2020-07-08 08:05:00	AAPL	Stock	93.97	93.9975	93.9375	93.945	21980.0
2020-07-08 08:10:00	AAPL	Stock	93.9375	93.9375	93.9375	93.9375	7152.0
2020-07-08 08:15:00	AAPL	Stock	93.925	93.925	93.7975	93.83	25204.0
2020-07-08 08:20:00	AAPL	Stock	93.8375	93.9052	93.8375	93.9052	8480.0
2020-07-08 08:25:00	AAPL	Stock	93.9225	93.975	93.91	93.925	25360.0
2020-07-08 08:30:00	AAPL	Stock	93.925	93.9625	93.925	93.9625	4060.0
2020-07-08 08:35:00	AAPL	Stock	93.92	93.925	93.8075	93.8575	50560.0
2020-07-08 08:40:00	AAPL	Stock	93.855	93.925	93.8	93.88	14784.0
2020-07-08 08:45:00	AAPL	Stock	93.8825	93.975	93.875	93.97	12240.0
2020-07-08 08:50:00	AAPL	Stock	93.9875	94.115	93.965	94.1	43624.0
2020-07-08 08:55:00	AAPL	Stock	94.085	94.1875	94.075	94.1	32836.0
2020-07-08 09:00:00	AAPL	Stock	94.09	94.185	94.09	94.105	43972.0

> showing 50 of 411,732 rows — these rows as CSV

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