PREVIEW / stock_5min / 2020-04-20

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-04-20.parquet
  size:    6.4 MB
  rows:    402,338
  symbols: 2,395

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-04-20 04:00:00	AAPL	Stock	70.68	70.68	70.375	70.425	5388.0
2020-04-20 04:05:00	AAPL	Stock	70.3	70.3725	70.3	70.3725	1688.0
2020-04-20 04:10:00	AAPL	Stock	70.26	70.26	70.25	70.25	3012.0
2020-04-20 04:15:00	AAPL	Stock	70.175	70.175	70.125	70.125	2644.0
2020-04-20 04:20:00	AAPL	Stock	70.125	70.125	70.0	70.0	6328.0
2020-04-20 04:30:00	AAPL	Stock	70.0025	70.0025	70.0025	70.0025	400.0
2020-04-20 04:35:00	AAPL	Stock	70.025	70.075	70.025	70.075	1340.0
2020-04-20 04:40:00	AAPL	Stock	70.0875	70.0875	70.025	70.025	800.0
2020-04-20 04:45:00	AAPL	Stock	70.0875	70.0875	70.0875	70.0875	400.0
2020-04-20 05:05:00	AAPL	Stock	70.25	70.25	70.09	70.105	3656.0
2020-04-20 05:15:00	AAPL	Stock	70.1575	70.1575	70.1575	70.1575	400.0
2020-04-20 05:30:00	AAPL	Stock	70.0875	70.0875	70.0875	70.0875	532.0
2020-04-20 05:35:00	AAPL	Stock	70.0875	70.0875	70.0875	70.0875	800.0
2020-04-20 05:40:00	AAPL	Stock	70.0875	70.0875	70.0875	70.0875	696.0
2020-04-20 05:50:00	AAPL	Stock	70.075	70.075	70.075	70.075	1044.0
2020-04-20 06:05:00	AAPL	Stock	69.8775	69.8775	69.775	69.775	4364.0
2020-04-20 06:10:00	AAPL	Stock	69.775	69.775	69.75	69.75	1240.0
2020-04-20 06:15:00	AAPL	Stock	69.8175	69.8375	69.7625	69.7625	1520.0
2020-04-20 06:20:00	AAPL	Stock	69.6925	69.6925	69.6925	69.6925	400.0
2020-04-20 06:25:00	AAPL	Stock	69.575	69.575	69.55	69.55	1640.0
2020-04-20 06:30:00	AAPL	Stock	69.6175	69.75	69.6175	69.75	2908.0
2020-04-20 06:35:00	AAPL	Stock	69.8	69.8375	69.75	69.75	4268.0
2020-04-20 06:40:00	AAPL	Stock	69.855	69.855	69.7775	69.7775	2404.0
2020-04-20 06:45:00	AAPL	Stock	69.75	69.75	69.75	69.75	800.0
2020-04-20 06:50:00	AAPL	Stock	69.69	69.69	69.69	69.69	1744.0
2020-04-20 06:55:00	AAPL	Stock	69.655	69.655	69.655	69.655	400.0
2020-04-20 07:00:00	AAPL	Stock	69.75	69.935	69.65	69.935	34620.0
2020-04-20 07:05:00	AAPL	Stock	69.9125	69.935	69.81	69.815	23572.0
2020-04-20 07:10:00	AAPL	Stock	69.8175	69.9075	69.8025	69.875	20856.0
2020-04-20 07:15:00	AAPL	Stock	69.87	69.885	69.795	69.825	43980.0
2020-04-20 07:20:00	AAPL	Stock	69.8275	69.85	69.8075	69.835	28456.0
2020-04-20 07:25:00	AAPL	Stock	69.855	69.95	69.855	69.8975	21032.0
2020-04-20 07:30:00	AAPL	Stock	69.9	69.925	69.84	69.925	17328.0
2020-04-20 07:35:00	AAPL	Stock	69.9175	69.9375	69.85	69.855	9200.0
2020-04-20 07:40:00	AAPL	Stock	69.855	69.89	69.8375	69.89	46644.0
2020-04-20 07:45:00	AAPL	Stock	69.925	69.925	69.725	69.75	36400.0
2020-04-20 07:50:00	AAPL	Stock	69.75	69.75	69.6375	69.75	44212.0
2020-04-20 07:55:00	AAPL	Stock	69.75	69.7625	69.6775	69.7325	23272.0
2020-04-20 08:00:00	AAPL	Stock	69.825	69.948	69.627	69.75	114644.0
2020-04-20 08:05:00	AAPL	Stock	69.685	69.7925	69.6	69.7925	79872.0
2020-04-20 08:10:00	AAPL	Stock	69.7975	69.8725	69.7625	69.8275	46320.0
2020-04-20 08:15:00	AAPL	Stock	69.835	69.86	69.7675	69.8375	35168.0
2020-04-20 08:20:00	AAPL	Stock	69.8375	69.8375	69.75	69.75	53748.0
2020-04-20 08:25:00	AAPL	Stock	69.7875	69.85	69.7775	69.7875	26836.0
2020-04-20 08:30:00	AAPL	Stock	69.75	69.75	69.575	69.625	60932.0
2020-04-20 08:35:00	AAPL	Stock	69.625	69.675	69.5925	69.5925	25820.0
2020-04-20 08:40:00	AAPL	Stock	69.6	69.7475	69.5875	69.7025	79712.0
2020-04-20 08:45:00	AAPL	Stock	69.7025	69.705	69.615	69.6175	12624.0
2020-04-20 08:50:00	AAPL	Stock	69.65	69.65	69.5475	69.5875	51832.0
2020-04-20 08:55:00	AAPL	Stock	69.6125	69.6375	69.5775	69.6	36696.0

> showing 50 of 402,338 rows — these rows as CSV

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