PREVIEW / stock_5min / 2018-06-04

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-06-04.parquet
  size:    5.7 MB
  rows:    365,058
  symbols: 2,835

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-06-04 04:00:00	AAPL	Stock	47.69	47.8	47.69	47.75	9964.0
2018-06-04 04:05:00	AAPL	Stock	47.7525	47.775	47.7525	47.775	1600.0
2018-06-04 04:25:00	AAPL	Stock	47.8075	47.8075	47.8075	47.8075	416.0
2018-06-04 04:30:00	AAPL	Stock	47.7875	47.7875	47.7875	47.7875	4000.0
2018-06-04 04:35:00	AAPL	Stock	47.805	47.805	47.805	47.805	1440.0
2018-06-04 04:50:00	AAPL	Stock	47.86	47.86	47.86	47.86	404.0
2018-06-04 05:00:00	AAPL	Stock	47.805	47.805	47.805	47.805	400.0
2018-06-04 05:10:00	AAPL	Stock	47.8225	47.8225	47.8225	47.8225	3552.0
2018-06-04 05:15:00	AAPL	Stock	47.805	47.815	47.805	47.815	800.0
2018-06-04 05:20:00	AAPL	Stock	47.8475	47.8475	47.8475	47.8475	520.0
2018-06-04 05:40:00	AAPL	Stock	47.86	47.86	47.86	47.86	1200.0
2018-06-04 05:45:00	AAPL	Stock	47.8625	47.8625	47.8625	47.8625	800.0
2018-06-04 05:55:00	AAPL	Stock	47.845	47.845	47.845	47.845	400.0
2018-06-04 06:00:00	AAPL	Stock	47.825	47.825	47.825	47.825	5496.0
2018-06-04 06:10:00	AAPL	Stock	47.8175	47.8225	47.8175	47.8225	1600.0
2018-06-04 06:15:00	AAPL	Stock	47.8125	47.8125	47.7875	47.7875	2468.0
2018-06-04 06:20:00	AAPL	Stock	47.8125	47.8125	47.8	47.8125	3700.0
2018-06-04 06:25:00	AAPL	Stock	47.8125	47.8125	47.8125	47.8125	676.0
2018-06-04 06:30:00	AAPL	Stock	47.8	47.8	47.7875	47.795	17132.0
2018-06-04 06:35:00	AAPL	Stock	47.795	47.795	47.775	47.775	7544.0
2018-06-04 06:40:00	AAPL	Stock	47.7625	47.7625	47.7625	47.7625	4000.0
2018-06-04 06:45:00	AAPL	Stock	47.76	47.76	47.76	47.76	400.0
2018-06-04 06:50:00	AAPL	Stock	47.76	47.7975	47.76	47.795	8576.0
2018-06-04 06:55:00	AAPL	Stock	47.765	47.765	47.75	47.75	8564.0
2018-06-04 07:00:00	AAPL	Stock	47.685	47.75	47.67	47.7125	23632.0
2018-06-04 07:05:00	AAPL	Stock	47.7125	47.7125	47.7	47.7075	3800.0
2018-06-04 07:10:00	AAPL	Stock	47.7125	47.74	47.7125	47.735	14080.0
2018-06-04 07:15:00	AAPL	Stock	47.725	47.7275	47.72	47.72	13912.0
2018-06-04 07:20:00	AAPL	Stock	47.72	47.735	47.72	47.735	38032.0
2018-06-04 07:25:00	AAPL	Stock	47.7325	47.7375	47.7325	47.7375	3292.0
2018-06-04 07:30:00	AAPL	Stock	47.7375	47.7625	47.7375	47.7625	48572.0
2018-06-04 07:35:00	AAPL	Stock	47.7625	47.775	47.7575	47.77	25600.0
2018-06-04 07:40:00	AAPL	Stock	47.77	47.775	47.7525	47.775	31640.0
2018-06-04 07:45:00	AAPL	Stock	47.775	47.785	47.75	47.75	35568.0
2018-06-04 07:50:00	AAPL	Stock	47.735	47.77	47.735	47.7625	52972.0
2018-06-04 07:55:00	AAPL	Stock	47.7675	47.8075	47.76	47.7975	43772.0
2018-06-04 08:00:00	AAPL	Stock	47.7	47.8125	47.6875	47.7925	159100.0
2018-06-04 08:05:00	AAPL	Stock	47.7975	47.845	47.7975	47.8375	55552.0
2018-06-04 08:10:00	AAPL	Stock	47.8425	47.86	47.825	47.85	63456.0
2018-06-04 08:15:00	AAPL	Stock	47.8475	47.8775	47.8375	47.8775	63268.0
2018-06-04 08:20:00	AAPL	Stock	47.8875	47.9475	47.875	47.8875	79248.0
2018-06-04 08:25:00	AAPL	Stock	47.8925	47.9	47.8775	47.89	34444.0
2018-06-04 08:30:00	AAPL	Stock	47.8925	47.8925	47.88	47.8875	14184.0
2018-06-04 08:35:00	AAPL	Stock	47.885	47.8925	47.8825	47.8825	10096.0
2018-06-04 08:40:00	AAPL	Stock	47.8775	47.88	47.8625	47.88	24648.0
2018-06-04 08:45:00	AAPL	Stock	47.875	47.9075	47.87	47.9075	51008.0
2018-06-04 08:50:00	AAPL	Stock	47.9075	47.9175	47.9	47.9125	51492.0
2018-06-04 08:55:00	AAPL	Stock	47.9175	47.9375	47.915	47.915	36720.0
2018-06-04 09:00:00	AAPL	Stock	47.905	47.9125	47.875	47.8875	90552.0
2018-06-04 09:05:00	AAPL	Stock	47.8825	47.9275	47.875	47.9275	98200.0

> showing 50 of 365,058 rows — these rows as CSV

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