PREVIEW / stock_5min / 2017-08-18

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-18.parquet
  size:    5.3 MB
  rows:    345,239
  symbols: 2,961

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-18 04:00:00	AAPL	Stock	39.45	39.45	39.45	39.45	3600.0
2017-08-18 04:05:00	AAPL	Stock	39.4525	39.4525	39.45	39.45	3964.0
2017-08-18 04:40:00	AAPL	Stock	39.5	39.5	39.5	39.5	1908.0
2017-08-18 05:00:00	AAPL	Stock	39.5	39.5	39.5	39.5	608.0
2017-08-18 05:25:00	AAPL	Stock	39.5	39.5	39.5	39.5	800.0
2017-08-18 05:30:00	AAPL	Stock	39.5	39.5	39.5	39.5	1696.0
2017-08-18 05:55:00	AAPL	Stock	39.525	39.525	39.525	39.525	784.0
2017-08-18 06:00:00	AAPL	Stock	39.5625	39.6	39.5625	39.6	4152.0
2017-08-18 06:05:00	AAPL	Stock	39.6125	39.6125	39.6125	39.6125	400.0
2017-08-18 06:10:00	AAPL	Stock	39.67	39.7125	39.65	39.7125	9684.0
2017-08-18 06:15:00	AAPL	Stock	39.75	39.75	39.7025	39.715	2636.0
2017-08-18 06:20:00	AAPL	Stock	39.6925	39.6925	39.6575	39.6575	34920.0
2017-08-18 06:25:00	AAPL	Stock	39.705	39.705	39.705	39.705	400.0
2017-08-18 06:30:00	AAPL	Stock	39.7	39.705	39.7	39.705	2400.0
2017-08-18 06:35:00	AAPL	Stock	39.7125	39.745	39.705	39.705	3556.0
2017-08-18 06:40:00	AAPL	Stock	39.7075	39.7175	39.705	39.705	4400.0
2017-08-18 06:50:00	AAPL	Stock	39.705	39.705	39.7	39.7	4000.0
2017-08-18 07:00:00	AAPL	Stock	39.7075	39.71	39.6625	39.675	14732.0
2017-08-18 07:05:00	AAPL	Stock	39.675	39.6975	39.64	39.65	15048.0
2017-08-18 07:10:00	AAPL	Stock	39.6425	39.6425	39.625	39.625	6600.0
2017-08-18 07:15:00	AAPL	Stock	39.6625	39.665	39.6575	39.6575	2980.0
2017-08-18 07:20:00	AAPL	Stock	39.66	39.66	39.6025	39.6025	5864.0
2017-08-18 07:25:00	AAPL	Stock	39.605	39.6125	39.6025	39.6125	3980.0
2017-08-18 07:30:00	AAPL	Stock	39.6125	39.6125	39.6125	39.6125	800.0
2017-08-18 07:35:00	AAPL	Stock	39.6125	39.6225	39.6	39.6225	10216.0
2017-08-18 07:40:00	AAPL	Stock	39.6425	39.6825	39.64	39.675	8244.0
2017-08-18 07:45:00	AAPL	Stock	39.675	39.675	39.65	39.65	8068.0
2017-08-18 07:50:00	AAPL	Stock	39.67	39.67	39.67	39.67	400.0
2017-08-18 07:55:00	AAPL	Stock	39.6875	39.6875	39.6875	39.6875	7920.0
2017-08-18 08:00:00	AAPL	Stock	39.6975	39.7	39.6125	39.6875	132084.0
2017-08-18 08:05:00	AAPL	Stock	39.6875	39.705	39.6875	39.705	38496.0
2017-08-18 08:10:00	AAPL	Stock	39.71	39.71	39.6775	39.68	15864.0
2017-08-18 08:15:00	AAPL	Stock	39.6825	39.6975	39.68	39.685	34552.0
2017-08-18 08:20:00	AAPL	Stock	39.675	39.69	39.65	39.65	6724.0
2017-08-18 08:25:00	AAPL	Stock	39.6625	39.6925	39.655	39.69	38264.0
2017-08-18 08:30:00	AAPL	Stock	39.6875	39.7125	39.6875	39.7125	20096.0
2017-08-18 08:35:00	AAPL	Stock	39.7125	39.7175	39.7	39.7175	14160.0
2017-08-18 08:40:00	AAPL	Stock	39.72	39.72	39.7	39.7	20500.0
2017-08-18 08:45:00	AAPL	Stock	39.7	39.7	39.675	39.6775	16424.0
2017-08-18 08:50:00	AAPL	Stock	39.68	39.68	39.6625	39.6625	11708.0
2017-08-18 08:55:00	AAPL	Stock	39.6525	39.675	39.6525	39.675	25960.0
2017-08-18 09:00:00	AAPL	Stock	39.6625	39.675	39.6525	39.6525	13056.0
2017-08-18 09:05:00	AAPL	Stock	39.655	39.655	39.6075	39.6275	40372.0
2017-08-18 09:10:00	AAPL	Stock	39.6275	39.6275	39.6	39.6175	15528.0
2017-08-18 09:15:00	AAPL	Stock	39.625	39.625	39.5875	39.6125	66936.0
2017-08-18 09:20:00	AAPL	Stock	39.59	39.59	39.565	39.575	30076.0
2017-08-18 09:25:00	AAPL	Stock	39.6	39.6	39.405	39.49	450708.0
2017-08-18 09:30:00	AAPL	Stock	39.49	39.67	39.445	39.5642	9812208.0
2017-08-18 09:35:00	AAPL	Stock	39.5675	39.6475	39.4975	39.5225	1953708.0
2017-08-18 09:40:00	AAPL	Stock	39.52	39.568	39.4675	39.47	2055896.0

> showing 50 of 345,239 rows — these rows as CSV

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