PREVIEW / stock_5min / 2018-04-03

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-04-03.parquet
  size:    5.6 MB
  rows:    363,540
  symbols: 2,879

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-04-03 04:00:00	AAPL	Stock	41.875	41.875	41.875	41.875	9088.0
2018-04-03 04:20:00	AAPL	Stock	41.7875	41.7875	41.7725	41.7725	2548.0
2018-04-03 04:25:00	AAPL	Stock	41.7	41.7	41.7	41.7	1976.0
2018-04-03 04:50:00	AAPL	Stock	41.8225	41.8225	41.8225	41.8225	900.0
2018-04-03 05:00:00	AAPL	Stock	41.775	41.775	41.775	41.775	800.0
2018-04-03 05:40:00	AAPL	Stock	41.805	41.84	41.805	41.84	4936.0
2018-04-03 05:50:00	AAPL	Stock	41.775	41.775	41.775	41.775	760.0
2018-04-03 06:00:00	AAPL	Stock	41.795	41.795	41.7875	41.7875	2244.0
2018-04-03 06:25:00	AAPL	Stock	41.8125	41.8125	41.8125	41.8125	800.0
2018-04-03 06:40:00	AAPL	Stock	41.875	41.875	41.875	41.875	2400.0
2018-04-03 06:45:00	AAPL	Stock	41.9125	41.92	41.9	41.9	6036.0
2018-04-03 07:00:00	AAPL	Stock	41.845	41.845	41.8025	41.8025	39440.0
2018-04-03 07:05:00	AAPL	Stock	41.8025	41.825	41.8025	41.8125	14392.0
2018-04-03 07:10:00	AAPL	Stock	41.825	41.85	41.825	41.8375	49504.0
2018-04-03 07:15:00	AAPL	Stock	41.8375	41.8475	41.8375	41.8475	12600.0
2018-04-03 07:20:00	AAPL	Stock	41.845	41.845	41.845	41.845	4000.0
2018-04-03 07:25:00	AAPL	Stock	41.8375	41.8375	41.8325	41.8375	10000.0
2018-04-03 07:30:00	AAPL	Stock	41.815	41.82	41.8025	41.82	4800.0
2018-04-03 07:35:00	AAPL	Stock	41.825	41.825	41.7925	41.7925	2480.0
2018-04-03 07:40:00	AAPL	Stock	41.8	41.82	41.8	41.8025	13160.0
2018-04-03 07:45:00	AAPL	Stock	41.8425	41.86	41.8425	41.86	2868.0
2018-04-03 07:50:00	AAPL	Stock	41.825	41.85	41.825	41.85	5732.0
2018-04-03 07:55:00	AAPL	Stock	41.86	41.8625	41.86	41.8625	11600.0
2018-04-03 08:00:00	AAPL	Stock	41.8625	41.8975	41.79	41.8525	68488.0
2018-04-03 08:05:00	AAPL	Stock	41.85	41.875	41.85	41.875	9552.0
2018-04-03 08:10:00	AAPL	Stock	41.875	41.8975	41.875	41.8875	53536.0
2018-04-03 08:15:00	AAPL	Stock	41.8975	41.95	41.895	41.95	66500.0
2018-04-03 08:20:00	AAPL	Stock	41.9625	41.975	41.9325	41.95	32384.0
2018-04-03 08:25:00	AAPL	Stock	41.95	41.985	41.67	41.9725	135680.0
2018-04-03 08:30:00	AAPL	Stock	41.9725	41.975	41.9525	41.9575	30236.0
2018-04-03 08:35:00	AAPL	Stock	41.9525	41.9625	41.8875	41.9375	19268.0
2018-04-03 08:40:00	AAPL	Stock	41.9425	42.0125	41.9425	42.0125	55212.0
2018-04-03 08:45:00	AAPL	Stock	42.0	42.0	41.935	41.985	38244.0
2018-04-03 08:50:00	AAPL	Stock	41.9675	42.0225	41.9675	42.0125	46688.0
2018-04-03 08:55:00	AAPL	Stock	42.0075	42.045	42.0075	42.025	43072.0
2018-04-03 09:00:00	AAPL	Stock	42.0225	42.0375	42.0	42.0375	82952.0
2018-04-03 09:05:00	AAPL	Stock	42.0325	42.0325	42.0025	42.0275	23504.0
2018-04-03 09:10:00	AAPL	Stock	42.0175	42.025	42.0	42.0125	78604.0
2018-04-03 09:15:00	AAPL	Stock	42.0125	42.0225	41.98	42.0125	112744.0
2018-04-03 09:20:00	AAPL	Stock	42.0125	42.0125	41.9925	41.9925	130860.0
2018-04-03 09:25:00	AAPL	Stock	42.0025	42.0025	41.85	41.9225	129332.0
2018-04-03 09:30:00	AAPL	Stock	41.915	41.95	41.6375	41.6675	4643484.0
2018-04-03 09:35:00	AAPL	Stock	41.665	41.9225	41.6425	41.9185	2343932.0
2018-04-03 09:40:00	AAPL	Stock	41.92	41.9475	41.7225	41.7275	2835596.0
2018-04-03 09:45:00	AAPL	Stock	41.7275	41.8975	41.6875	41.8502	2453124.0
2018-04-03 09:50:00	AAPL	Stock	41.8525	41.8612	41.7125	41.7925	1290248.0
2018-04-03 09:55:00	AAPL	Stock	41.795	41.8125	41.6025	41.675	1522876.0
2018-04-03 10:00:00	AAPL	Stock	41.68	41.6888	41.57	41.67	1269528.0
2018-04-03 10:05:00	AAPL	Stock	41.66	41.665	41.4375	41.4775	2114784.0
2018-04-03 10:10:00	AAPL	Stock	41.48	41.4875	41.36	41.3825	1939344.0

> showing 50 of 363,540 rows — these rows as CSV

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