PREVIEW / stock_5min / 2017-04-24

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-24.parquet
  size:    5.4 MB
  rows:    359,210
  symbols: 3,056

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-04-24 04:00:00	AAPL	Stock	36.0025	36.0025	36.0	36.0	2840.0
2017-04-24 04:05:00	AAPL	Stock	36.025	36.05	36.025	36.05	1676.0
2017-04-24 04:30:00	AAPL	Stock	36.025	36.025	36.025	36.025	2640.0
2017-04-24 04:35:00	AAPL	Stock	36.025	36.025	36.0125	36.0125	1772.0
2017-04-24 04:50:00	AAPL	Stock	35.9925	35.9925	35.9925	35.9925	496.0
2017-04-24 04:55:00	AAPL	Stock	35.9925	35.9925	35.9925	35.9925	2048.0
2017-04-24 05:00:00	AAPL	Stock	35.9925	35.9925	35.9925	35.9925	400.0
2017-04-24 05:15:00	AAPL	Stock	36.0025	36.0025	36.0025	36.0025	400.0
2017-04-24 05:20:00	AAPL	Stock	36.0125	36.0125	36.0125	36.0125	1916.0
2017-04-24 05:50:00	AAPL	Stock	35.98	35.98	35.9725	35.9725	4332.0
2017-04-24 06:05:00	AAPL	Stock	35.9625	35.9725	35.9625	35.9725	3600.0
2017-04-24 06:10:00	AAPL	Stock	35.985	35.9875	35.985	35.9875	3572.0
2017-04-24 06:20:00	AAPL	Stock	35.97	35.97	35.965	35.965	3356.0
2017-04-24 06:30:00	AAPL	Stock	35.9875	35.9925	35.9875	35.9925	5600.0
2017-04-24 06:50:00	AAPL	Stock	35.95	35.95	35.95	35.95	2420.0
2017-04-24 06:55:00	AAPL	Stock	35.9875	35.9875	35.9875	35.9875	400.0
2017-04-24 07:00:00	AAPL	Stock	35.975	35.975	35.975	35.975	3980.0
2017-04-24 07:05:00	AAPL	Stock	35.9625	35.975	35.9025	35.9025	10452.0
2017-04-24 07:15:00	AAPL	Stock	35.905	35.905	35.9	35.9	12808.0
2017-04-24 07:20:00	AAPL	Stock	35.92	35.9225	35.92	35.92	12304.0
2017-04-24 07:25:00	AAPL	Stock	35.9125	35.9125	35.9125	35.9125	3600.0
2017-04-24 07:30:00	AAPL	Stock	35.92	35.92	35.9025	35.9025	5160.0
2017-04-24 07:35:00	AAPL	Stock	35.925	35.925	35.925	35.925	9000.0
2017-04-24 07:40:00	AAPL	Stock	35.9125	35.9125	35.9025	35.9025	10800.0
2017-04-24 07:45:00	AAPL	Stock	35.92	35.92	35.92	35.92	400.0
2017-04-24 07:50:00	AAPL	Stock	35.925	35.925	35.925	35.925	800.0
2017-04-24 07:55:00	AAPL	Stock	35.935	35.935	35.9075	35.91	11200.0
2017-04-24 08:00:00	AAPL	Stock	35.905	35.965	35.9	35.905	43676.0
2017-04-24 08:05:00	AAPL	Stock	35.9	35.9	35.5675	35.9	27960.0
2017-04-24 08:10:00	AAPL	Stock	35.9	35.9	35.8875	35.9	15200.0
2017-04-24 08:15:00	AAPL	Stock	35.9	35.9075	35.9	35.905	8400.0
2017-04-24 08:20:00	AAPL	Stock	35.905	35.935	35.905	35.935	23016.0
2017-04-24 08:25:00	AAPL	Stock	35.9325	35.9425	35.925	35.925	14000.0
2017-04-24 08:30:00	AAPL	Stock	35.925	35.935	35.885	35.9075	41312.0
2017-04-24 08:35:00	AAPL	Stock	35.9075	35.9225	35.9075	35.9225	10944.0
2017-04-24 08:40:00	AAPL	Stock	35.92	35.9425	35.9175	35.9325	10800.0
2017-04-24 08:45:00	AAPL	Stock	35.9325	35.95	35.9325	35.9375	46656.0
2017-04-24 08:50:00	AAPL	Stock	35.935	35.935	35.9	35.9075	30500.0
2017-04-24 08:55:00	AAPL	Stock	35.9075	35.9125	35.9	35.905	28116.0
2017-04-24 09:00:00	AAPL	Stock	35.9025	35.9125	35.9	35.9	27776.0
2017-04-24 09:05:00	AAPL	Stock	35.9	35.915	35.885	35.885	61484.0
2017-04-24 09:10:00	AAPL	Stock	35.8875	35.8875	35.8625	35.88	33920.0
2017-04-24 09:15:00	AAPL	Stock	35.88	35.88	35.865	35.865	11600.0
2017-04-24 09:20:00	AAPL	Stock	35.865	35.8725	35.8425	35.85	65304.0
2017-04-24 09:25:00	AAPL	Stock	35.8375	35.91	35.825	35.8775	142812.0
2017-04-24 09:30:00	AAPL	Stock	35.875	35.92	35.8125	35.8192	3564744.0
2017-04-24 09:35:00	AAPL	Stock	35.8175	35.89	35.795	35.8825	2246120.0
2017-04-24 09:40:00	AAPL	Stock	35.8825	35.935	35.8825	35.917	1817296.0
2017-04-24 09:45:00	AAPL	Stock	35.9175	35.9838	35.88	35.9825	2270820.0
2017-04-24 09:50:00	AAPL	Stock	35.9838	35.9875	35.94	35.9475	1534028.0

> showing 50 of 359,210 rows — these rows as CSV

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