PREVIEW / stock_5min / 2017-08-24

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-24.parquet
  size:    5.2 MB
  rows:    338,065
  symbols: 2,962

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
2017-08-24 04:05:00	AAPL	Stock	39.95	39.95	39.95	39.95	1600.0
2017-08-24 04:40:00	AAPL	Stock	40.005	40.005	40.005	40.005	400.0
2017-08-24 06:10:00	AAPL	Stock	40.0475	40.0475	40.0475	40.0475	400.0
2017-08-24 07:00:00	AAPL	Stock	40.05	40.0575	40.05	40.055	9016.0
2017-08-24 07:05:00	AAPL	Stock	40.0375	40.0375	40.0375	40.0375	1912.0
2017-08-24 07:10:00	AAPL	Stock	40.0475	40.07	40.0475	40.07	5568.0
2017-08-24 07:15:00	AAPL	Stock	40.0725	40.1125	40.0725	40.1125	1356.0
2017-08-24 07:20:00	AAPL	Stock	40.12	40.125	40.1175	40.125	19052.0
2017-08-24 07:25:00	AAPL	Stock	40.1625	40.1625	40.1625	40.1625	400.0
2017-08-24 07:30:00	AAPL	Stock	40.125	40.15	40.125	40.15	5588.0
2017-08-24 07:35:00	AAPL	Stock	40.15	40.15	40.15	40.15	400.0
2017-08-24 07:40:00	AAPL	Stock	40.16	40.1625	40.15	40.1625	4624.0
2017-08-24 07:45:00	AAPL	Stock	40.1625	40.1625	40.145	40.145	12480.0
2017-08-24 07:50:00	AAPL	Stock	40.155	40.155	40.145	40.145	800.0
2017-08-24 08:00:00	AAPL	Stock	40.145	40.155	40.0375	40.155	42884.0
2017-08-24 08:05:00	AAPL	Stock	40.155	40.1675	40.1525	40.155	19236.0
2017-08-24 08:10:00	AAPL	Stock	40.1575	40.1575	40.15	40.15	19652.0
2017-08-24 08:15:00	AAPL	Stock	40.15	40.1575	40.1425	40.1575	10640.0
2017-08-24 08:20:00	AAPL	Stock	40.1625	40.165	40.1625	40.1625	23436.0
2017-08-24 08:25:00	AAPL	Stock	40.1675	40.1725	40.1475	40.1475	18492.0
2017-08-24 08:30:00	AAPL	Stock	40.17	40.17	40.15	40.17	11548.0
2017-08-24 08:35:00	AAPL	Stock	40.16	40.1625	40.1525	40.1575	9060.0
2017-08-24 08:40:00	AAPL	Stock	40.1625	40.1625	40.155	40.1625	11900.0
2017-08-24 08:45:00	AAPL	Stock	40.1625	40.1625	40.15	40.15	19420.0
2017-08-24 08:50:00	AAPL	Stock	40.14	40.155	40.14	40.155	17200.0
2017-08-24 09:00:00	AAPL	Stock	40.15	40.1625	40.1425	40.1425	36372.0
2017-08-24 09:05:00	AAPL	Stock	40.1575	40.1575	40.145	40.1475	3404.0
2017-08-24 09:10:00	AAPL	Stock	40.155	40.1775	40.155	40.175	25764.0
2017-08-24 09:15:00	AAPL	Stock	40.175	40.18	40.175	40.175	11280.0
2017-08-24 09:20:00	AAPL	Stock	40.175	40.185	40.175	40.175	34144.0
2017-08-24 09:25:00	AAPL	Stock	40.175	40.175	40.1125	40.1125	74772.0
2017-08-24 09:30:00	AAPL	Stock	40.1075	40.185	40.04	40.1175	3034988.0
2017-08-24 09:35:00	AAPL	Stock	40.1125	40.15	39.99	39.9975	1856372.0
2017-08-24 09:40:00	AAPL	Stock	39.9975	40.03	39.92	39.95	1963108.0
2017-08-24 09:45:00	AAPL	Stock	39.95	39.97	39.89	39.905	1093164.0
2017-08-24 09:50:00	AAPL	Stock	39.9	39.9125	39.7925	39.894	1947996.0
2017-08-24 09:55:00	AAPL	Stock	39.8925	39.9075	39.815	39.85	1135512.0
2017-08-24 10:00:00	AAPL	Stock	39.8475	39.94	39.845	39.9325	1434340.0
2017-08-24 10:05:00	AAPL	Stock	39.935	39.945	39.825	39.865	993576.0
2017-08-24 10:10:00	AAPL	Stock	39.865	39.9325	39.805	39.9225	1288748.0
2017-08-24 10:15:00	AAPL	Stock	39.925	39.965	39.9075	39.935	922432.0
2017-08-24 10:20:00	AAPL	Stock	39.935	39.9825	39.905	39.965	1198444.0
2017-08-24 10:25:00	AAPL	Stock	39.965	39.985	39.93	39.9325	944360.0
2017-08-24 10:30:00	AAPL	Stock	39.9345	39.9775	39.9345	39.975	756916.0
2017-08-24 10:35:00	AAPL	Stock	39.9738	40.025	39.9675	39.9675	1178108.0
2017-08-24 10:40:00	AAPL	Stock	39.97	40.0125	39.9575	40.01	748160.0
2017-08-24 10:45:00	AAPL	Stock	40.005	40.03	39.94	39.95	893636.0
2017-08-24 10:50:00	AAPL	Stock	39.9475	39.98	39.9225	39.9425	634516.0
2017-08-24 10:55:00	AAPL	Stock	39.9375	39.9928	39.9275	39.935	542120.0
2017-08-24 11:00:00	AAPL	Stock	39.9375	39.95	39.9075	39.94	485832.0

> showing 50 of 338,065 rows — these rows as CSV

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