PREVIEW / stock_5min / 2018-05-30

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-30.parquet
  size:    5.7 MB
  rows:    367,563
  symbols: 2,821

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-05-30 04:00:00	AAPL	Stock	47.05	47.1375	47.05	47.1375	3356.0
2018-05-30 05:00:00	AAPL	Stock	47.0275	47.0275	47.0275	47.0275	3968.0
2018-05-30 05:10:00	AAPL	Stock	47.05	47.05	47.05	47.05	400.0
2018-05-30 05:15:00	AAPL	Stock	47.0675	47.1175	47.0675	47.1175	1064.0
2018-05-30 05:20:00	AAPL	Stock	47.1175	47.1175	47.1175	47.1175	400.0
2018-05-30 05:40:00	AAPL	Stock	47.1375	47.1375	47.1375	47.1375	724.0
2018-05-30 05:50:00	AAPL	Stock	47.1375	47.14	47.1375	47.14	3932.0
2018-05-30 06:05:00	AAPL	Stock	47.13	47.13	47.13	47.13	1276.0
2018-05-30 06:10:00	AAPL	Stock	47.13	47.13	47.125	47.125	3624.0
2018-05-30 06:30:00	AAPL	Stock	47.125	47.125	47.11	47.11	5424.0
2018-05-30 06:35:00	AAPL	Stock	47.155	47.155	47.155	47.155	792.0
2018-05-30 06:40:00	AAPL	Stock	47.125	47.125	47.1075	47.1075	1240.0
2018-05-30 06:50:00	AAPL	Stock	47.1075	47.1075	47.1075	47.1075	400.0
2018-05-30 06:55:00	AAPL	Stock	47.1075	47.1075	47.1075	47.1075	1600.0
2018-05-30 07:00:00	AAPL	Stock	47.105	47.105	47.1	47.105	31656.0
2018-05-30 07:05:00	AAPL	Stock	47.125	47.125	47.125	47.125	1592.0
2018-05-30 07:10:00	AAPL	Stock	47.13	47.145	47.1225	47.1225	13300.0
2018-05-30 07:15:00	AAPL	Stock	47.1225	47.1225	47.0875	47.0875	16560.0
2018-05-30 07:20:00	AAPL	Stock	47.095	47.1025	47.095	47.1025	7244.0
2018-05-30 07:25:00	AAPL	Stock	47.1025	47.105	46.9525	46.9525	68076.0
2018-05-30 07:30:00	AAPL	Stock	46.99	47.035	46.9675	46.9775	15080.0
2018-05-30 07:35:00	AAPL	Stock	47.025	47.0475	46.995	46.995	29736.0
2018-05-30 07:40:00	AAPL	Stock	47.0125	47.025	46.9975	46.9975	11136.0
2018-05-30 07:45:00	AAPL	Stock	47.0125	47.0125	47.0125	47.0125	1120.0
2018-05-30 07:50:00	AAPL	Stock	47.025	47.0375	46.9875	46.9875	21016.0
2018-05-30 08:00:00	AAPL	Stock	47.1	47.125	46.9525	46.99	91716.0
2018-05-30 08:05:00	AAPL	Stock	47.0	47.025	46.9875	47.0	5680.0
2018-05-30 08:10:00	AAPL	Stock	46.98	47.015	46.975	47.015	12148.0
2018-05-30 08:15:00	AAPL	Stock	47.02	47.025	47.0125	47.0225	18700.0
2018-05-30 08:20:00	AAPL	Stock	47.0225	47.0225	46.9825	46.9825	46940.0
2018-05-30 08:25:00	AAPL	Stock	46.9875	47.01	46.9875	47.0	13688.0
2018-05-30 08:30:00	AAPL	Stock	47.0025	47.0025	46.905	46.925	68808.0
2018-05-30 08:35:00	AAPL	Stock	46.925	46.9525	46.9025	46.9325	20004.0
2018-05-30 08:40:00	AAPL	Stock	46.9178	46.93	46.9175	46.93	16304.0
2018-05-30 08:45:00	AAPL	Stock	46.925	46.94	46.92	46.9375	9688.0
2018-05-30 08:50:00	AAPL	Stock	46.9375	46.94	46.925	46.925	12376.0
2018-05-30 08:55:00	AAPL	Stock	46.925	46.925	46.9075	46.91	8108.0
2018-05-30 09:00:00	AAPL	Stock	46.9075	46.91	46.84	46.8725	30404.0
2018-05-30 09:05:00	AAPL	Stock	46.9	46.9125	46.87	46.9	28720.0
2018-05-30 09:10:00	AAPL	Stock	46.9	46.94	46.9	46.9375	28304.0
2018-05-30 09:15:00	AAPL	Stock	46.9325	46.9375	46.925	46.935	7124.0
2018-05-30 09:20:00	AAPL	Stock	46.9425	46.95	46.935	46.935	22544.0
2018-05-30 09:25:00	AAPL	Stock	46.935	46.9425	46.8775	46.905	28680.0
2018-05-30 09:30:00	AAPL	Stock	46.91	47.0	46.79	46.8088	2618452.0
2018-05-30 09:35:00	AAPL	Stock	46.8225	46.9075	46.8	46.85	1336500.0
2018-05-30 09:40:00	AAPL	Stock	46.8575	46.86	46.8078	46.835	1256500.0
2018-05-30 09:45:00	AAPL	Stock	46.835	46.955	46.82	46.87	1392672.0
2018-05-30 09:50:00	AAPL	Stock	46.8675	46.905	46.7725	46.7925	1121676.0
2018-05-30 09:55:00	AAPL	Stock	46.7928	46.835	46.765	46.78	1115400.0
2018-05-30 10:00:00	AAPL	Stock	46.78	46.7908	46.72	46.73	1337424.0

> showing 50 of 367,563 rows — these rows as CSV

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