PREVIEW / stock_5min / 2019-12-19

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-12-19.parquet
  size:    5.9 MB
  rows:    369,185
  symbols: 2,501

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-12-19 04:15:00	AAPL	Stock	69.9	69.9	69.9	69.9	400.0
2019-12-19 04:20:00	AAPL	Stock	69.875	69.875	69.875	69.875	400.0
2019-12-19 04:25:00	AAPL	Stock	69.845	69.845	69.845	69.845	484.0
2019-12-19 04:40:00	AAPL	Stock	69.875	69.875	69.875	69.875	2000.0
2019-12-19 05:30:00	AAPL	Stock	69.895	69.895	69.895	69.895	400.0
2019-12-19 06:15:00	AAPL	Stock	69.9175	69.9175	69.9125	69.9125	1916.0
2019-12-19 06:20:00	AAPL	Stock	69.9125	69.9125	69.84	69.845	10592.0
2019-12-19 06:25:00	AAPL	Stock	69.8375	69.8375	69.75	69.75	20464.0
2019-12-19 06:30:00	AAPL	Stock	69.7725	69.78	69.7725	69.78	3644.0
2019-12-19 06:35:00	AAPL	Stock	69.7775	69.8125	69.7375	69.77	7996.0
2019-12-19 06:40:00	AAPL	Stock	69.75	69.75	69.7475	69.75	2000.0
2019-12-19 06:55:00	AAPL	Stock	69.82	69.82	69.8075	69.8075	936.0
2019-12-19 07:00:00	AAPL	Stock	69.79	69.8875	69.7875	69.845	21440.0
2019-12-19 07:05:00	AAPL	Stock	69.85	69.87	69.85	69.8625	5352.0
2019-12-19 07:10:00	AAPL	Stock	69.87	69.8875	69.8375	69.86	12400.0
2019-12-19 07:15:00	AAPL	Stock	69.86	69.8625	69.85	69.8625	7040.0
2019-12-19 07:20:00	AAPL	Stock	69.8625	69.875	69.8525	69.875	10864.0
2019-12-19 07:25:00	AAPL	Stock	69.875	69.8825	69.8375	69.8375	16152.0
2019-12-19 07:30:00	AAPL	Stock	69.8575	69.8625	69.84	69.8625	2600.0
2019-12-19 07:35:00	AAPL	Stock	69.84	69.85	69.7625	69.7625	23584.0
2019-12-19 07:40:00	AAPL	Stock	69.8125	69.825	69.805	69.8125	12764.0
2019-12-19 07:45:00	AAPL	Stock	69.8225	69.8375	69.8075	69.8375	6080.0
2019-12-19 07:50:00	AAPL	Stock	69.8375	69.855	69.835	69.855	5892.0
2019-12-19 07:55:00	AAPL	Stock	69.85	69.85	69.7625	69.7875	37792.0
2019-12-19 08:00:00	AAPL	Stock	69.8225	69.8875	69.7722	69.7722	51836.0
2019-12-19 08:05:00	AAPL	Stock	69.8	69.825	69.7825	69.8125	6760.0
2019-12-19 08:10:00	AAPL	Stock	69.8025	69.835	69.8025	69.8225	18760.0
2019-12-19 08:15:00	AAPL	Stock	69.82	69.82	69.78	69.8125	12868.0
2019-12-19 08:20:00	AAPL	Stock	69.82	69.825	69.8025	69.805	4928.0
2019-12-19 08:25:00	AAPL	Stock	69.8725	69.8725	69.85	69.85	4596.0
2019-12-19 08:30:00	AAPL	Stock	69.84	69.8475	69.805	69.835	20020.0
2019-12-19 08:35:00	AAPL	Stock	69.8275	69.835	69.7375	69.75	122732.0
2019-12-19 08:40:00	AAPL	Stock	69.7775	69.8125	69.7775	69.8125	7528.0
2019-12-19 08:45:00	AAPL	Stock	69.8225	69.8425	69.7925	69.8325	16432.0
2019-12-19 08:50:00	AAPL	Stock	69.8325	69.8725	69.8	69.8	13560.0
2019-12-19 08:55:00	AAPL	Stock	69.8375	69.8475	69.835	69.8475	1820.0
2019-12-19 09:00:00	AAPL	Stock	69.8475	69.85	69.825	69.85	8432.0
2019-12-19 09:05:00	AAPL	Stock	69.8475	69.8725	69.8325	69.8625	20024.0
2019-12-19 09:10:00	AAPL	Stock	69.8625	69.875	69.85	69.875	35968.0
2019-12-19 09:15:00	AAPL	Stock	69.875	69.8925	69.8425	69.8425	27832.0
2019-12-19 09:20:00	AAPL	Stock	69.85	69.875	69.85	69.875	12908.0
2019-12-19 09:25:00	AAPL	Stock	69.87	69.9	69.8325	69.8325	23248.0
2019-12-19 09:30:00	AAPL	Stock	69.8775	70.1925	69.865	70.0925	3698864.0
2019-12-19 09:35:00	AAPL	Stock	70.1075	70.295	70.0825	70.2178	2169332.0
2019-12-19 09:40:00	AAPL	Stock	70.215	70.2225	70.105	70.1075	1207128.0
2019-12-19 09:45:00	AAPL	Stock	70.1075	70.2	70.0125	70.165	1928040.0
2019-12-19 09:50:00	AAPL	Stock	70.155	70.195	70.085	70.135	901492.0
2019-12-19 09:55:00	AAPL	Stock	70.125	70.1975	70.1	70.115	800100.0
2019-12-19 10:00:00	AAPL	Stock	70.11	70.137	70.0488	70.0575	872364.0
2019-12-19 10:05:00	AAPL	Stock	70.0575	70.0875	70.015	70.0202	908664.0

> showing 50 of 369,185 rows — these rows as CSV

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