PREVIEW / stock_5min / 2020-04-01

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-04-01.parquet
  size:    6.3 MB
  rows:    406,221
  symbols: 2,424

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-01 04:00:00	AAPL	Stock	62.75	62.75	61.85	61.85	25652.0
2020-04-01 04:05:00	AAPL	Stock	61.8225	61.9675	61.79	61.9675	4988.0
2020-04-01 04:10:00	AAPL	Stock	62.1225	62.1225	62.0	62.0	2276.0
2020-04-01 04:15:00	AAPL	Stock	62.0025	62.0925	62.0	62.0925	1296.0
2020-04-01 04:20:00	AAPL	Stock	61.95	61.95	61.95	61.95	3484.0
2020-04-01 04:25:00	AAPL	Stock	61.9125	61.9125	61.8225	61.8225	8356.0
2020-04-01 04:30:00	AAPL	Stock	61.86	61.86	61.755	61.7775	7312.0
2020-04-01 04:35:00	AAPL	Stock	61.885	61.885	61.825	61.825	4012.0
2020-04-01 04:40:00	AAPL	Stock	61.8	61.8	61.5675	61.75	4992.0
2020-04-01 04:45:00	AAPL	Stock	61.68	61.81	61.68	61.81	4816.0
2020-04-01 04:50:00	AAPL	Stock	61.835	61.835	61.7775	61.7775	884.0
2020-04-01 04:55:00	AAPL	Stock	61.8175	61.8425	61.815	61.8425	3200.0
2020-04-01 05:00:00	AAPL	Stock	61.8375	61.9675	61.8375	61.935	1420.0
2020-04-01 05:10:00	AAPL	Stock	61.98	62.1	61.98	62.0	5380.0
2020-04-01 05:20:00	AAPL	Stock	61.75	61.7525	61.75	61.75	1200.0
2020-04-01 05:45:00	AAPL	Stock	61.925	62.0	61.925	62.0	5372.0
2020-04-01 05:50:00	AAPL	Stock	62.0	62.05	62.0	62.05	3944.0
2020-04-01 05:55:00	AAPL	Stock	62.0725	62.0725	62.0	62.0	1976.0
2020-04-01 06:00:00	AAPL	Stock	62.0275	62.12	62.0275	62.1175	2484.0
2020-04-01 06:05:00	AAPL	Stock	62.12	62.12	62.0625	62.0625	2400.0
2020-04-01 06:10:00	AAPL	Stock	62.0025	62.0025	61.905	61.905	1600.0
2020-04-01 06:20:00	AAPL	Stock	61.8125	61.835	61.8125	61.835	4824.0
2020-04-01 06:35:00	AAPL	Stock	61.905	61.905	61.905	61.905	400.0
2020-04-01 06:40:00	AAPL	Stock	61.7875	61.7875	61.6275	61.63	5020.0
2020-04-01 06:45:00	AAPL	Stock	61.75	61.75	61.75	61.75	400.0
2020-04-01 06:50:00	AAPL	Stock	61.75	61.75	61.6325	61.6325	8720.0
2020-04-01 06:55:00	AAPL	Stock	61.625	61.75	61.565	61.75	13308.0
2020-04-01 07:00:00	AAPL	Stock	61.8925	61.9225	61.6725	61.705	109908.0
2020-04-01 07:05:00	AAPL	Stock	61.705	61.725	61.6	61.725	68972.0
2020-04-01 07:10:00	AAPL	Stock	61.625	61.75	61.615	61.75	12816.0
2020-04-01 07:15:00	AAPL	Stock	61.75	61.88	61.75	61.7875	54748.0
2020-04-01 07:20:00	AAPL	Stock	61.8	61.855	61.7125	61.8	56108.0
2020-04-01 07:25:00	AAPL	Stock	61.83	61.83	61.725	61.8	29056.0
2020-04-01 07:30:00	AAPL	Stock	61.7825	61.9525	61.73	61.925	24416.0
2020-04-01 07:35:00	AAPL	Stock	61.9375	61.975	61.905	61.975	20052.0
2020-04-01 07:40:00	AAPL	Stock	61.9475	61.9675	61.8375	61.9125	20024.0
2020-04-01 07:45:00	AAPL	Stock	61.88	61.8825	61.75	61.75	22556.0
2020-04-01 07:50:00	AAPL	Stock	61.7525	62.175	61.7525	61.975	105372.0
2020-04-01 07:55:00	AAPL	Stock	61.9275	62.0	61.885	62.0	18452.0
2020-04-01 08:00:00	AAPL	Stock	61.7225	62.0925	61.625	61.625	197236.0
2020-04-01 08:05:00	AAPL	Stock	61.645	61.755	61.575	61.625	88280.0
2020-04-01 08:10:00	AAPL	Stock	61.6	61.6375	61.37	61.41	156804.0
2020-04-01 08:15:00	AAPL	Stock	61.4025	61.8225	61.4025	61.75	186512.0
2020-04-01 08:20:00	AAPL	Stock	61.715	61.9	61.605	61.61	72072.0
2020-04-01 08:25:00	AAPL	Stock	61.6175	61.695	61.5	61.6475	24456.0
2020-04-01 08:30:00	AAPL	Stock	61.625	61.75	61.61	61.6875	45780.0
2020-04-01 08:35:00	AAPL	Stock	61.735	61.81	61.65	61.655	44004.0
2020-04-01 08:40:00	AAPL	Stock	61.6425	61.8	61.625	61.8	128176.0
2020-04-01 08:45:00	AAPL	Stock	61.7925	61.95	61.655	61.655	77092.0
2020-04-01 08:50:00	AAPL	Stock	61.7	61.8275	61.7	61.755	27856.0

> showing 50 of 406,221 rows — these rows as CSV

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