PREVIEW / stock_5min / 2018-10-05

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-10-05.parquet
  size:    5.8 MB
  rows:    361,500
  symbols: 2,773

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-10-05 04:00:00	AAPL	Stock	56.7675	56.88	56.7675	56.88	9328.0
2018-10-05 04:05:00	AAPL	Stock	56.875	56.875	56.875	56.875	400.0
2018-10-05 04:10:00	AAPL	Stock	56.9125	56.9125	56.9125	56.9125	468.0
2018-10-05 04:20:00	AAPL	Stock	56.875	56.875	56.875	56.875	400.0
2018-10-05 04:40:00	AAPL	Stock	56.775	56.775	56.775	56.775	400.0
2018-10-05 04:50:00	AAPL	Stock	56.85	56.85	56.85	56.85	400.0
2018-10-05 05:00:00	AAPL	Stock	56.7775	56.7775	56.775	56.775	1224.0
2018-10-05 05:05:00	AAPL	Stock	56.85	56.87	56.85	56.87	1520.0
2018-10-05 05:20:00	AAPL	Stock	56.78	56.78	56.78	56.78	400.0
2018-10-05 05:35:00	AAPL	Stock	56.825	56.825	56.825	56.825	400.0
2018-10-05 05:40:00	AAPL	Stock	56.8	56.8	56.78	56.78	6800.0
2018-10-05 05:50:00	AAPL	Stock	56.785	56.785	56.785	56.785	788.0
2018-10-05 06:00:00	AAPL	Stock	56.85	56.85	56.85	56.85	2360.0
2018-10-05 06:05:00	AAPL	Stock	56.8	56.8	56.7875	56.7875	1388.0
2018-10-05 06:10:00	AAPL	Stock	56.9125	56.9125	56.9125	56.9125	452.0
2018-10-05 06:45:00	AAPL	Stock	56.88	56.88	56.88	56.88	444.0
2018-10-05 06:55:00	AAPL	Stock	56.9025	56.91	56.9025	56.91	2168.0
2018-10-05 07:00:00	AAPL	Stock	56.91	56.97	56.8625	56.96	29036.0
2018-10-05 07:05:00	AAPL	Stock	56.95	56.95	56.925	56.9375	2640.0
2018-10-05 07:10:00	AAPL	Stock	56.9925	57.0	56.97	56.995	18020.0
2018-10-05 07:15:00	AAPL	Stock	57.02	57.025	57.0	57.0	6392.0
2018-10-05 07:20:00	AAPL	Stock	56.995	57.0	56.97	56.9875	7188.0
2018-10-05 07:25:00	AAPL	Stock	56.99	57.02	56.9675	57.02	5548.0
2018-10-05 07:30:00	AAPL	Stock	56.9975	57.0125	56.99	56.99	4400.0
2018-10-05 07:35:00	AAPL	Stock	56.99	56.99	56.8825	56.9475	11704.0
2018-10-05 07:40:00	AAPL	Stock	56.965	56.965	56.965	56.965	400.0
2018-10-05 07:45:00	AAPL	Stock	56.9125	56.9125	56.89	56.89	1200.0
2018-10-05 07:50:00	AAPL	Stock	56.95	56.95	56.945	56.945	1300.0
2018-10-05 07:55:00	AAPL	Stock	56.9575	56.9625	56.9025	56.9025	7036.0
2018-10-05 08:00:00	AAPL	Stock	57.05	57.05	56.85	56.86	79760.0
2018-10-05 08:05:00	AAPL	Stock	56.8425	56.855	56.815	56.8325	18760.0
2018-10-05 08:10:00	AAPL	Stock	56.85	56.85	56.78	56.78	26992.0
2018-10-05 08:15:00	AAPL	Stock	56.78	56.825	56.78	56.825	19600.0
2018-10-05 08:20:00	AAPL	Stock	56.8375	56.8475	56.7575	56.79	30992.0
2018-10-05 08:25:00	AAPL	Stock	56.8125	56.83	56.79	56.83	13920.0
2018-10-05 08:30:00	AAPL	Stock	56.8575	57.125	56.8575	56.9375	323944.0
2018-10-05 08:35:00	AAPL	Stock	56.93	56.94	56.765	56.8025	113384.0
2018-10-05 08:40:00	AAPL	Stock	56.8025	56.9	56.745	56.8775	153584.0
2018-10-05 08:45:00	AAPL	Stock	56.8775	56.91	56.8575	56.895	71744.0
2018-10-05 08:50:00	AAPL	Stock	56.8875	56.97	56.8875	56.94	62788.0
2018-10-05 08:55:00	AAPL	Stock	56.925	56.9975	56.9025	56.975	77616.0
2018-10-05 09:00:00	AAPL	Stock	56.97	56.99	56.97	56.975	20120.0
2018-10-05 09:05:00	AAPL	Stock	56.975	57.04	56.975	57.0025	19168.0
2018-10-05 09:10:00	AAPL	Stock	57.0125	57.1225	57.0125	57.0875	63856.0
2018-10-05 09:15:00	AAPL	Stock	57.065	57.0875	57.0025	57.0375	64560.0
2018-10-05 09:20:00	AAPL	Stock	57.01	57.0375	57.0	57.0225	34180.0
2018-10-05 09:25:00	AAPL	Stock	57.0075	57.0225	56.9475	56.9475	36152.0
2018-10-05 09:30:00	AAPL	Stock	56.99	57.1025	56.71	56.8012	2891596.0
2018-10-05 09:35:00	AAPL	Stock	56.805	57.035	56.76	56.8458	2007936.0
2018-10-05 09:40:00	AAPL	Stock	56.8548	56.9022	56.72	56.78	1501248.0

> showing 50 of 361,500 rows — these rows as CSV

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