PREVIEW / stock_5min / 2018-03-20

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-03-20.parquet
  size:    5.5 MB
  rows:    353,062
  symbols: 2,889

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
2018-03-20 04:45:00	AAPL	Stock	43.8775	43.8775	43.875	43.875	1200.0
2018-03-20 05:45:00	AAPL	Stock	43.8675	43.8725	43.8675	43.8725	5196.0
2018-03-20 06:00:00	AAPL	Stock	43.835	43.835	43.835	43.835	420.0
2018-03-20 06:40:00	AAPL	Stock	43.7875	43.7875	43.7875	43.7875	1200.0
2018-03-20 06:50:00	AAPL	Stock	43.875	43.895	43.875	43.895	1804.0
2018-03-20 07:00:00	AAPL	Stock	43.85	43.925	43.85	43.925	5488.0
2018-03-20 07:10:00	AAPL	Stock	43.9025	43.9025	43.9025	43.9025	400.0
2018-03-20 07:20:00	AAPL	Stock	43.925	43.9275	43.9125	43.9275	8160.0
2018-03-20 07:25:00	AAPL	Stock	43.9275	44.0425	43.9275	44.04	51976.0
2018-03-20 07:30:00	AAPL	Stock	44.0425	44.0525	44.0425	44.0525	8688.0
2018-03-20 07:35:00	AAPL	Stock	44.04	44.04	44.0325	44.0325	3008.0
2018-03-20 07:40:00	AAPL	Stock	44.0525	44.0575	44.0275	44.04	12868.0
2018-03-20 07:45:00	AAPL	Stock	44.0575	44.0575	44.0575	44.0575	832.0
2018-03-20 07:50:00	AAPL	Stock	44.02	44.02	44.0075	44.0075	4400.0
2018-03-20 07:55:00	AAPL	Stock	44.0	44.0075	44.0	44.0	6276.0
2018-03-20 08:00:00	AAPL	Stock	44.045	44.0625	43.835	44.035	82988.0
2018-03-20 08:05:00	AAPL	Stock	44.015	44.015	44.0	44.0	28560.0
2018-03-20 08:10:00	AAPL	Stock	43.985	43.9875	43.9625	43.9875	21144.0
2018-03-20 08:15:00	AAPL	Stock	43.985	43.9975	43.965	43.975	6100.0
2018-03-20 08:20:00	AAPL	Stock	43.9625	44.0125	43.9625	44.005	17128.0
2018-03-20 08:25:00	AAPL	Stock	44.005	44.005	43.9375	43.975	59164.0
2018-03-20 08:30:00	AAPL	Stock	43.975	43.98	43.95	43.9625	67576.0
2018-03-20 08:35:00	AAPL	Stock	43.9725	43.9725	43.9675	43.9675	7652.0
2018-03-20 08:40:00	AAPL	Stock	43.98	43.9825	43.975	43.975	3200.0
2018-03-20 08:45:00	AAPL	Stock	43.98	43.98	43.975	43.975	1500.0
2018-03-20 08:50:00	AAPL	Stock	43.9575	43.975	43.9525	43.975	7704.0
2018-03-20 08:55:00	AAPL	Stock	43.975	43.975	43.9725	43.9725	2800.0
2018-03-20 09:00:00	AAPL	Stock	43.975	43.98	43.9275	43.9325	25692.0
2018-03-20 09:05:00	AAPL	Stock	43.9375	43.96	43.9375	43.96	2000.0
2018-03-20 09:10:00	AAPL	Stock	43.96	43.97	43.9525	43.9675	3200.0
2018-03-20 09:15:00	AAPL	Stock	43.9625	43.9625	43.915	43.915	44992.0
2018-03-20 09:20:00	AAPL	Stock	43.915	43.925	43.8625	43.8625	74488.0
2018-03-20 09:25:00	AAPL	Stock	43.8625	43.8625	43.805	43.805	58140.0
2018-03-20 09:30:00	AAPL	Stock	43.82	44.1425	43.8	44.135	3413832.0
2018-03-20 09:35:00	AAPL	Stock	44.1325	44.1675	44.015	44.1062	1962764.0
2018-03-20 09:40:00	AAPL	Stock	44.1075	44.2	44.105	44.1125	1852160.0
2018-03-20 09:45:00	AAPL	Stock	44.1125	44.175	44.095	44.0975	1251112.0
2018-03-20 09:50:00	AAPL	Stock	44.0975	44.1175	44.06	44.0925	1042456.0
2018-03-20 09:55:00	AAPL	Stock	44.09	44.09	44.015	44.0575	991932.0
2018-03-20 10:00:00	AAPL	Stock	44.0612	44.1	43.9875	44.0275	994512.0
2018-03-20 10:05:00	AAPL	Stock	44.0275	44.06	43.9975	44.0	868096.0
2018-03-20 10:10:00	AAPL	Stock	43.9975	44.0175	43.9525	43.9642	958524.0
2018-03-20 10:15:00	AAPL	Stock	43.9625	43.9625	43.88	43.9038	1158872.0
2018-03-20 10:20:00	AAPL	Stock	43.9025	44.0	43.9025	43.9812	1105216.0
2018-03-20 10:25:00	AAPL	Stock	43.98	44.0242	43.9175	43.9925	987312.0
2018-03-20 10:30:00	AAPL	Stock	43.995	44.0675	43.995	44.04	1180416.0
2018-03-20 10:35:00	AAPL	Stock	44.042	44.0675	43.98	44.0525	907652.0
2018-03-20 10:40:00	AAPL	Stock	44.0525	44.07	43.975	43.9775	761172.0
2018-03-20 10:45:00	AAPL	Stock	43.98	44.0175	43.965	43.9662	591920.0
2018-03-20 10:50:00	AAPL	Stock	43.9625	44.0575	43.96	44.045	730084.0

> showing 50 of 353,062 rows — these rows as CSV

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