PREVIEW / stock_5min / 2019-09-09

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-09-09.parquet
  size:    5.7 MB
  rows:    361,067
  symbols: 2,565

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-09-09 04:00:00	AAPL	Stock	53.425	53.425	53.415	53.415	800.0
2019-09-09 04:05:00	AAPL	Stock	53.3975	53.3975	53.3475	53.3475	1200.0
2019-09-09 04:35:00	AAPL	Stock	53.3975	53.3975	53.3975	53.3975	400.0
2019-09-09 04:40:00	AAPL	Stock	53.3975	53.45	53.3975	53.45	4252.0
2019-09-09 05:30:00	AAPL	Stock	53.415	53.415	53.415	53.415	400.0
2019-09-09 05:45:00	AAPL	Stock	53.45	53.45	53.45	53.45	1200.0
2019-09-09 06:10:00	AAPL	Stock	53.5325	53.575	53.5325	53.575	4784.0
2019-09-09 06:20:00	AAPL	Stock	53.5575	53.56	53.5575	53.56	4000.0
2019-09-09 06:35:00	AAPL	Stock	53.55	53.55	53.55	53.55	640.0
2019-09-09 07:00:00	AAPL	Stock	53.5225	53.575	53.5025	53.5275	38952.0
2019-09-09 07:05:00	AAPL	Stock	53.52	53.52	53.515	53.515	10420.0
2019-09-09 07:10:00	AAPL	Stock	53.515	53.52	53.5	53.5	9580.0
2019-09-09 07:15:00	AAPL	Stock	53.52	53.52	53.5075	53.5075	1200.0
2019-09-09 07:20:00	AAPL	Stock	53.5125	53.525	53.51	53.5225	4004.0
2019-09-09 07:25:00	AAPL	Stock	53.52	53.6	53.52	53.6	19292.0
2019-09-09 07:30:00	AAPL	Stock	53.575	53.61	53.575	53.61	19640.0
2019-09-09 07:35:00	AAPL	Stock	53.61	53.62	53.6	53.62	10824.0
2019-09-09 07:40:00	AAPL	Stock	53.62	53.64	53.62	53.625	17252.0
2019-09-09 07:45:00	AAPL	Stock	53.64	53.64	53.5825	53.6	4248.0
2019-09-09 07:50:00	AAPL	Stock	53.6	53.6	53.58	53.58	8800.0
2019-09-09 07:55:00	AAPL	Stock	53.5975	53.5975	53.585	53.585	800.0
2019-09-09 08:00:00	AAPL	Stock	53.55	53.6375	53.5	53.6	102268.0
2019-09-09 08:05:00	AAPL	Stock	53.6	53.6	53.575	53.575	7636.0
2019-09-09 08:10:00	AAPL	Stock	53.595	53.6275	53.59	53.625	27376.0
2019-09-09 08:15:00	AAPL	Stock	53.6125	53.6275	53.6125	53.625	6784.0
2019-09-09 08:20:00	AAPL	Stock	53.6175	53.6625	53.6175	53.65	43212.0
2019-09-09 08:25:00	AAPL	Stock	53.65	53.675	53.65	53.675	12100.0
2019-09-09 08:30:00	AAPL	Stock	53.6875	53.69	53.625	53.625	23144.0
2019-09-09 08:35:00	AAPL	Stock	53.6575	53.6575	53.6375	53.6375	7404.0
2019-09-09 08:40:00	AAPL	Stock	53.6375	53.645	53.6375	53.64	4800.0
2019-09-09 08:45:00	AAPL	Stock	53.65	53.65	53.6275	53.6275	5820.0
2019-09-09 08:50:00	AAPL	Stock	53.65	53.65	53.625	53.6375	9956.0
2019-09-09 08:55:00	AAPL	Stock	53.6475	53.6685	53.6475	53.65	24532.0
2019-09-09 09:00:00	AAPL	Stock	53.6575	53.6695	53.65	53.66	31216.0
2019-09-09 09:05:00	AAPL	Stock	53.655	53.6875	53.65	53.685	51512.0
2019-09-09 09:10:00	AAPL	Stock	53.685	53.685	53.6675	53.6725	10992.0
2019-09-09 09:15:00	AAPL	Stock	53.665	53.6875	53.665	53.6875	24504.0
2019-09-09 09:20:00	AAPL	Stock	53.67	53.67	53.64	53.6625	59412.0
2019-09-09 09:25:00	AAPL	Stock	53.6525	53.71	53.65	53.71	40028.0
2019-09-09 09:30:00	AAPL	Stock	53.715	53.865	53.6062	53.795	5272336.0
2019-09-09 09:35:00	AAPL	Stock	53.7975	53.8388	53.73	53.8312	1977600.0
2019-09-09 09:40:00	AAPL	Stock	53.835	53.9968	53.82	53.945	2404388.0
2019-09-09 09:45:00	AAPL	Stock	53.9425	53.98	53.835	53.9	1599660.0
2019-09-09 09:50:00	AAPL	Stock	53.9	54.01	53.885	53.8975	2259412.0
2019-09-09 09:55:00	AAPL	Stock	53.9	53.94	53.7775	53.8038	1501336.0
2019-09-09 10:00:00	AAPL	Stock	53.8025	53.87	53.7875	53.84	1091260.0
2019-09-09 10:05:00	AAPL	Stock	53.8425	53.845	53.8025	53.805	918032.0
2019-09-09 10:10:00	AAPL	Stock	53.8025	53.835	53.73	53.78	1325652.0
2019-09-09 10:15:00	AAPL	Stock	53.7765	53.815	53.7375	53.7375	795520.0
2019-09-09 10:20:00	AAPL	Stock	53.74	53.8325	53.66	53.8275	1145920.0

> showing 50 of 361,067 rows — these rows as CSV

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