PREVIEW / stock_5min / 2020-07-27

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-07-27.parquet
  size:    6.5 MB
  rows:    409,646
  symbols: 2,452

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-27 04:00:00	AAPL	Stock	93.0025	93.0275	92.83	92.83	14336.0
2020-07-27 04:10:00	AAPL	Stock	93.0	93.0	93.0	93.0	3600.0
2020-07-27 04:35:00	AAPL	Stock	92.9975	92.9975	92.9975	92.9975	1132.0
2020-07-27 04:40:00	AAPL	Stock	93.08	93.08	93.08	93.08	2000.0
2020-07-27 04:45:00	AAPL	Stock	93.08	93.08	93.08	93.08	416.0
2020-07-27 05:10:00	AAPL	Stock	93.0825	93.1125	93.0825	93.1125	1200.0
2020-07-27 05:20:00	AAPL	Stock	93.215	93.25	93.215	93.25	800.0
2020-07-27 05:30:00	AAPL	Stock	93.4775	93.5	93.3825	93.5	5684.0
2020-07-27 05:45:00	AAPL	Stock	93.5	93.5	93.45	93.45	2000.0
2020-07-27 05:55:00	AAPL	Stock	93.45	93.45	93.45	93.45	400.0
2020-07-27 06:00:00	AAPL	Stock	93.535	93.535	93.49	93.49	2600.0
2020-07-27 06:10:00	AAPL	Stock	93.52	93.5675	93.4775	93.4775	9628.0
2020-07-27 06:15:00	AAPL	Stock	93.4975	93.4975	93.45	93.475	9968.0
2020-07-27 06:20:00	AAPL	Stock	93.475	93.5675	93.475	93.5675	1796.0
2020-07-27 06:25:00	AAPL	Stock	93.695	93.875	93.695	93.875	1304.0
2020-07-27 06:30:00	AAPL	Stock	93.8975	93.8975	93.7825	93.7825	2180.0
2020-07-27 06:35:00	AAPL	Stock	94.0	94.0	94.0	94.0	400.0
2020-07-27 06:40:00	AAPL	Stock	93.975	93.975	93.975	93.975	400.0
2020-07-27 06:45:00	AAPL	Stock	93.925	93.925	93.8075	93.87	5796.0
2020-07-27 06:50:00	AAPL	Stock	93.7875	93.7875	93.7775	93.7775	1200.0
2020-07-27 06:55:00	AAPL	Stock	93.67	93.67	93.65	93.65	4896.0
2020-07-27 07:00:00	AAPL	Stock	93.625	93.7375	93.4275	93.4275	77064.0
2020-07-27 07:05:00	AAPL	Stock	93.475	93.475	93.3725	93.4725	48012.0
2020-07-27 07:10:00	AAPL	Stock	93.475	93.6625	93.4275	93.66	39416.0
2020-07-27 07:15:00	AAPL	Stock	93.69	93.7375	93.5	93.5975	51000.0
2020-07-27 07:20:00	AAPL	Stock	93.5975	93.625	93.5	93.5	20368.0
2020-07-27 07:25:00	AAPL	Stock	93.5	93.625	93.5	93.625	4572.0
2020-07-27 07:30:00	AAPL	Stock	93.625	93.75	93.6175	93.75	38432.0
2020-07-27 07:35:00	AAPL	Stock	93.7425	93.75	93.6925	93.705	23752.0
2020-07-27 07:40:00	AAPL	Stock	93.7	93.8	93.675	93.8	46664.0
2020-07-27 07:45:00	AAPL	Stock	93.7775	93.8075	93.7475	93.7475	34660.0
2020-07-27 07:50:00	AAPL	Stock	93.7725	93.805	93.75	93.75	23048.0
2020-07-27 07:55:00	AAPL	Stock	93.775	93.8125	93.75	93.8125	23812.0
2020-07-27 08:00:00	AAPL	Stock	93.3765	93.825	93.375	93.625	186272.0
2020-07-27 08:05:00	AAPL	Stock	93.65	93.7	93.5875	93.615	29412.0
2020-07-27 08:10:00	AAPL	Stock	93.6125	93.625	93.55	93.555	32760.0
2020-07-27 08:15:00	AAPL	Stock	93.6225	93.7375	93.6125	93.725	5500.0
2020-07-27 08:20:00	AAPL	Stock	93.6775	93.6775	93.5675	93.6725	12532.0
2020-07-27 08:25:00	AAPL	Stock	93.625	93.6975	93.6	93.695	14996.0
2020-07-27 08:30:00	AAPL	Stock	93.6825	93.6875	93.5025	93.5525	44868.0
2020-07-27 08:35:00	AAPL	Stock	93.535	93.675	93.535	93.6502	10944.0
2020-07-27 08:40:00	AAPL	Stock	93.655	93.6925	93.5775	93.63	66288.0
2020-07-27 08:45:00	AAPL	Stock	93.6425	93.7175	93.5825	93.7175	49988.0
2020-07-27 08:50:00	AAPL	Stock	93.705	93.7375	93.59	93.725	96512.0
2020-07-27 08:55:00	AAPL	Stock	93.7375	93.785	93.715	93.7375	46856.0
2020-07-27 09:00:00	AAPL	Stock	93.7375	93.78	93.67	93.78	37476.0
2020-07-27 09:05:00	AAPL	Stock	93.76	93.9525	93.76	93.89	164916.0
2020-07-27 09:10:00	AAPL	Stock	93.91	93.9375	93.825	93.825	54496.0
2020-07-27 09:15:00	AAPL	Stock	93.8275	93.885	93.825	93.865	37444.0
2020-07-27 09:20:00	AAPL	Stock	93.8925	93.925	93.8675	93.925	38032.0

> showing 50 of 409,646 rows — these rows as CSV

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