PREVIEW / stock_5min / 2018-08-23

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-23.parquet
  size:    5.4 MB
  rows:    342,884
  symbols: 2,787

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-08-23 04:00:00	AAPL	Stock	53.8125	53.8125	53.8125	53.8125	400.0
2018-08-23 04:10:00	AAPL	Stock	53.7725	53.7725	53.7725	53.7725	584.0
2018-08-23 04:15:00	AAPL	Stock	53.7725	53.7725	53.7725	53.7725	400.0
2018-08-23 05:40:00	AAPL	Stock	53.8725	53.8725	53.8725	53.8725	1604.0
2018-08-23 05:55:00	AAPL	Stock	53.8625	53.8625	53.8625	53.8625	1920.0
2018-08-23 06:05:00	AAPL	Stock	53.8475	53.8475	53.8475	53.8475	2000.0
2018-08-23 06:20:00	AAPL	Stock	53.8175	53.82	53.8175	53.82	3200.0
2018-08-23 06:50:00	AAPL	Stock	53.7675	53.7675	53.7675	53.7675	400.0
2018-08-23 06:55:00	AAPL	Stock	53.8425	53.8425	53.8175	53.8175	3600.0
2018-08-23 07:00:00	AAPL	Stock	53.82	53.85	53.8175	53.8475	36980.0
2018-08-23 07:05:00	AAPL	Stock	53.82	53.825	53.8125	53.825	17648.0
2018-08-23 07:10:00	AAPL	Stock	53.825	53.825	53.8125	53.8175	4240.0
2018-08-23 07:15:00	AAPL	Stock	53.8175	53.8175	53.7575	53.7575	5280.0
2018-08-23 07:20:00	AAPL	Stock	53.7625	53.7625	53.7625	53.7625	400.0
2018-08-23 07:25:00	AAPL	Stock	53.7575	53.7575	53.7575	53.7575	800.0
2018-08-23 07:30:00	AAPL	Stock	53.76	53.76	53.76	53.76	400.0
2018-08-23 07:35:00	AAPL	Stock	53.765	53.7775	53.765	53.7775	1600.0
2018-08-23 07:40:00	AAPL	Stock	53.7725	53.7775	53.7675	53.7775	3672.0
2018-08-23 07:45:00	AAPL	Stock	53.7825	53.7825	53.7775	53.7775	3600.0
2018-08-23 07:50:00	AAPL	Stock	53.775	53.775	53.7675	53.7675	5028.0
2018-08-23 07:55:00	AAPL	Stock	53.7875	53.7875	53.7875	53.7875	1600.0
2018-08-23 08:00:00	AAPL	Stock	53.8468	53.8468	53.7525	53.7725	17916.0
2018-08-23 08:05:00	AAPL	Stock	53.7875	53.7875	53.7625	53.77	38724.0
2018-08-23 08:10:00	AAPL	Stock	53.77	53.7725	53.7625	53.7725	6968.0
2018-08-23 08:15:00	AAPL	Stock	53.7625	53.77	53.755	53.765	18688.0
2018-08-23 08:20:00	AAPL	Stock	53.7675	53.7675	53.73	53.74	17748.0
2018-08-23 08:25:00	AAPL	Stock	53.7125	53.7425	53.7125	53.7425	20396.0
2018-08-23 08:30:00	AAPL	Stock	53.725	53.7275	53.705	53.705	33676.0
2018-08-23 08:35:00	AAPL	Stock	53.705	53.725	53.6875	53.7	14480.0
2018-08-23 08:40:00	AAPL	Stock	53.7075	53.7325	53.7075	53.7325	3260.0
2018-08-23 08:45:00	AAPL	Stock	53.73	53.7425	53.715	53.715	5200.0
2018-08-23 08:50:00	AAPL	Stock	53.725	53.725	53.7125	53.7125	4924.0
2018-08-23 08:55:00	AAPL	Stock	53.745	53.745	53.725	53.73	4612.0
2018-08-23 09:00:00	AAPL	Stock	53.7325	53.77	53.7125	53.7275	8616.0
2018-08-23 09:05:00	AAPL	Stock	53.7125	53.72	53.705	53.7125	15012.0
2018-08-23 09:10:00	AAPL	Stock	53.7225	53.7225	53.6775	53.685	30232.0
2018-08-23 09:15:00	AAPL	Stock	53.685	53.69	53.6525	53.675	20640.0
2018-08-23 09:20:00	AAPL	Stock	53.68	53.7	53.675	53.6775	14860.0
2018-08-23 09:25:00	AAPL	Stock	53.68	53.6875	53.65	53.65	27356.0
2018-08-23 09:30:00	AAPL	Stock	53.68	53.92	53.65	53.9075	2647104.0
2018-08-23 09:35:00	AAPL	Stock	53.914	54.05	53.89	54.019	1700456.0
2018-08-23 09:40:00	AAPL	Stock	54.02	54.0475	53.975	54.014	1327892.0
2018-08-23 09:45:00	AAPL	Stock	54.015	54.0925	54.0125	54.089	1331316.0
2018-08-23 09:50:00	AAPL	Stock	54.09	54.18	54.04	54.17	1798400.0
2018-08-23 09:55:00	AAPL	Stock	54.17	54.2625	54.16	54.19	2077348.0
2018-08-23 10:00:00	AAPL	Stock	54.19	54.2075	54.1275	54.155	1146172.0
2018-08-23 10:05:00	AAPL	Stock	54.155	54.165	54.0622	54.065	1017052.0
2018-08-23 10:10:00	AAPL	Stock	54.0675	54.172	54.06	54.13	1019620.0
2018-08-23 10:15:00	AAPL	Stock	54.1325	54.2	54.1268	54.1625	967272.0
2018-08-23 10:20:00	AAPL	Stock	54.165	54.23	54.1642	54.2098	884984.0

> showing 50 of 342,884 rows — these rows as CSV

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