PREVIEW / stock_5min / 2019-06-25

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-06-25.parquet
  size:    5.7 MB
  rows:    364,006
  symbols: 2,612

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
2019-06-25 04:00:00	AAPL	Stock	49.5625	49.5625	49.465	49.465	800.0
2019-06-25 04:55:00	AAPL	Stock	49.4	49.4	49.4	49.4	2000.0
2019-06-25 05:00:00	AAPL	Stock	49.395	49.4925	49.395	49.4925	5880.0
2019-06-25 05:05:00	AAPL	Stock	49.4575	49.4575	49.4575	49.4575	2520.0
2019-06-25 05:10:00	AAPL	Stock	49.455	49.4575	49.455	49.4575	3688.0
2019-06-25 05:30:00	AAPL	Stock	49.4375	49.4575	49.4375	49.4575	1412.0
2019-06-25 05:35:00	AAPL	Stock	49.4725	49.4725	49.4725	49.4725	1708.0
2019-06-25 06:00:00	AAPL	Stock	49.4175	49.4175	49.4175	49.4175	800.0
2019-06-25 06:05:00	AAPL	Stock	49.4175	49.4175	49.4175	49.4175	1196.0
2019-06-25 06:20:00	AAPL	Stock	49.41	49.41	49.41	49.41	400.0
2019-06-25 06:55:00	AAPL	Stock	49.4725	49.4725	49.4725	49.4725	400.0
2019-06-25 07:00:00	AAPL	Stock	49.4725	49.56	49.4725	49.56	8400.0
2019-06-25 07:05:00	AAPL	Stock	49.5625	49.5625	49.5625	49.5625	400.0
2019-06-25 07:10:00	AAPL	Stock	49.555	49.555	49.555	49.555	400.0
2019-06-25 07:15:00	AAPL	Stock	49.5525	49.5525	49.525	49.525	3752.0
2019-06-25 07:20:00	AAPL	Stock	49.5525	49.615	49.5275	49.5275	4960.0
2019-06-25 07:30:00	AAPL	Stock	49.5525	49.5525	49.525	49.5275	5800.0
2019-06-25 07:35:00	AAPL	Stock	49.5375	49.5375	49.5375	49.5375	400.0
2019-06-25 07:40:00	AAPL	Stock	49.55	49.55	49.525	49.525	14120.0
2019-06-25 07:45:00	AAPL	Stock	49.5125	49.5225	49.5125	49.5225	1120.0
2019-06-25 07:50:00	AAPL	Stock	49.5375	49.5375	49.5375	49.5375	800.0
2019-06-25 08:00:00	AAPL	Stock	49.55	49.5975	49.4725	49.5975	25576.0
2019-06-25 08:05:00	AAPL	Stock	49.585	49.585	49.5475	49.5475	12028.0
2019-06-25 08:15:00	AAPL	Stock	49.592	49.592	49.592	49.592	400.0
2019-06-25 08:25:00	AAPL	Stock	49.625	49.625	49.5875	49.6075	10528.0
2019-06-25 08:30:00	AAPL	Stock	49.6025	49.6375	49.6025	49.6375	14416.0
2019-06-25 08:35:00	AAPL	Stock	49.6425	49.65	49.625	49.625	7008.0
2019-06-25 08:40:00	AAPL	Stock	49.625	49.6475	49.625	49.64	6364.0
2019-06-25 08:45:00	AAPL	Stock	49.64	49.6475	49.625	49.625	3160.0
2019-06-25 08:50:00	AAPL	Stock	49.6475	49.6875	49.64	49.685	11132.0
2019-06-25 08:55:00	AAPL	Stock	49.6875	49.6875	49.6625	49.6675	8600.0
2019-06-25 09:00:00	AAPL	Stock	49.6875	49.6875	49.6875	49.6875	3200.0
2019-06-25 09:05:00	AAPL	Stock	49.68	49.695	49.65	49.65	14256.0
2019-06-25 09:10:00	AAPL	Stock	49.6725	49.6725	49.63	49.63	5960.0
2019-06-25 09:15:00	AAPL	Stock	49.6425	49.6625	49.6325	49.6325	8008.0
2019-06-25 09:20:00	AAPL	Stock	49.625	49.63	49.605	49.605	10020.0
2019-06-25 09:25:00	AAPL	Stock	49.605	49.615	49.5625	49.615	6816.0
2019-06-25 09:30:00	AAPL	Stock	49.65	49.815	49.5875	49.7875	2516764.0
2019-06-25 09:35:00	AAPL	Stock	49.79	49.815	49.635	49.7175	1585464.0
2019-06-25 09:40:00	AAPL	Stock	49.7175	49.7275	49.6	49.6875	1111036.0
2019-06-25 09:45:00	AAPL	Stock	49.685	49.745	49.5825	49.6275	1003196.0
2019-06-25 09:50:00	AAPL	Stock	49.629	49.675	49.59	49.6275	1105124.0
2019-06-25 09:55:00	AAPL	Stock	49.6287	49.6675	49.6093	49.6275	670048.0
2019-06-25 10:00:00	AAPL	Stock	49.6325	49.67	49.5925	49.5975	819464.0
2019-06-25 10:05:00	AAPL	Stock	49.595	49.6175	49.5375	49.605	1202156.0
2019-06-25 10:10:00	AAPL	Stock	49.6025	49.6125	49.4275	49.4875	1326148.0
2019-06-25 10:15:00	AAPL	Stock	49.485	49.49	49.41	49.4625	846180.0
2019-06-25 10:20:00	AAPL	Stock	49.46	49.5025	49.42	49.474	934816.0
2019-06-25 10:25:00	AAPL	Stock	49.4725	49.5625	49.47	49.56	869464.0
2019-06-25 10:30:00	AAPL	Stock	49.5575	49.5875	49.4825	49.495	883236.0

> showing 50 of 364,006 rows — these rows as CSV

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