PREVIEW / stock_5min / 2018-06-07

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-06-07.parquet
  size:    5.6 MB
  rows:    361,017
  symbols: 2,831

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-07 04:00:00	AAPL	Stock	48.5625	48.6125	48.5625	48.6125	3076.0
2018-06-07 04:10:00	AAPL	Stock	48.6125	48.6125	48.6125	48.6125	1600.0
2018-06-07 04:50:00	AAPL	Stock	48.595	48.595	48.575	48.575	3568.0
2018-06-07 04:55:00	AAPL	Stock	48.575	48.575	48.575	48.575	1952.0
2018-06-07 05:10:00	AAPL	Stock	48.575	48.575	48.575	48.575	3636.0
2018-06-07 05:15:00	AAPL	Stock	48.575	48.575	48.575	48.575	400.0
2018-06-07 06:00:00	AAPL	Stock	48.575	48.575	48.575	48.575	440.0
2018-06-07 06:05:00	AAPL	Stock	48.575	48.575	48.575	48.575	3304.0
2018-06-07 07:00:00	AAPL	Stock	48.53	48.54	48.47	48.47	41644.0
2018-06-07 07:05:00	AAPL	Stock	48.4725	48.48	48.47	48.48	4240.0
2018-06-07 07:10:00	AAPL	Stock	48.4925	48.55	48.4925	48.5475	59176.0
2018-06-07 07:15:00	AAPL	Stock	48.535	48.575	48.535	48.575	20328.0
2018-06-07 07:20:00	AAPL	Stock	48.5575	48.5625	48.5375	48.5375	7200.0
2018-06-07 07:25:00	AAPL	Stock	48.5375	48.55	48.5375	48.5375	10736.0
2018-06-07 07:30:00	AAPL	Stock	48.5475	48.5475	48.515	48.515	12808.0
2018-06-07 07:35:00	AAPL	Stock	48.5175	48.5175	48.5175	48.5175	1600.0
2018-06-07 07:40:00	AAPL	Stock	48.5175	48.5175	48.515	48.5175	7892.0
2018-06-07 07:45:00	AAPL	Stock	48.515	48.515	48.505	48.5075	13460.0
2018-06-07 07:50:00	AAPL	Stock	48.5075	48.5075	48.5075	48.5075	4264.0
2018-06-07 07:55:00	AAPL	Stock	48.51	48.515	48.5025	48.515	8344.0
2018-06-07 08:00:00	AAPL	Stock	48.5	48.575	48.465	48.485	105504.0
2018-06-07 08:05:00	AAPL	Stock	48.485	48.5125	48.485	48.5125	26020.0
2018-06-07 08:10:00	AAPL	Stock	48.5125	48.525	48.5025	48.505	15544.0
2018-06-07 08:15:00	AAPL	Stock	48.515	48.525	48.5125	48.5125	5600.0
2018-06-07 08:20:00	AAPL	Stock	48.51	48.5225	48.51	48.5125	14892.0
2018-06-07 08:25:00	AAPL	Stock	48.5	48.52	48.5	48.52	8080.0
2018-06-07 08:30:00	AAPL	Stock	48.5	48.5125	48.5	48.5125	4000.0
2018-06-07 08:35:00	AAPL	Stock	48.5075	48.515	48.5	48.5	6960.0
2018-06-07 08:40:00	AAPL	Stock	48.5	48.5	48.4875	48.4875	4080.0
2018-06-07 08:50:00	AAPL	Stock	48.5025	48.5025	48.4975	48.5	8760.0
2018-06-07 08:55:00	AAPL	Stock	48.5	48.525	48.5	48.525	12544.0
2018-06-07 09:00:00	AAPL	Stock	48.525	48.525	48.525	48.525	1200.0
2018-06-07 09:05:00	AAPL	Stock	48.5125	48.5125	48.495	48.495	7100.0
2018-06-07 09:10:00	AAPL	Stock	48.5	48.52	48.495	48.52	6800.0
2018-06-07 09:15:00	AAPL	Stock	48.4975	48.5	48.4925	48.4975	14180.0
2018-06-07 09:20:00	AAPL	Stock	48.4975	48.5	48.475	48.475	16112.0
2018-06-07 09:25:00	AAPL	Stock	48.5	48.5125	48.4775	48.5125	17072.0
2018-06-07 09:30:00	AAPL	Stock	48.535	48.55	48.3802	48.3825	2662040.0
2018-06-07 09:35:00	AAPL	Stock	48.3825	48.4375	48.2862	48.3925	1873756.0
2018-06-07 09:40:00	AAPL	Stock	48.39	48.425	48.3325	48.4188	1174388.0
2018-06-07 09:45:00	AAPL	Stock	48.42	48.46	48.39	48.4175	1163004.0
2018-06-07 09:50:00	AAPL	Stock	48.415	48.5097	48.4025	48.495	1584984.0
2018-06-07 09:55:00	AAPL	Stock	48.492	48.495	48.4052	48.45	893560.0
2018-06-07 10:00:00	AAPL	Stock	48.45	48.45	48.3825	48.41	708692.0
2018-06-07 10:05:00	AAPL	Stock	48.405	48.4175	48.31	48.3188	1016092.0
2018-06-07 10:10:00	AAPL	Stock	48.3175	48.35	48.24	48.3425	1519920.0
2018-06-07 10:15:00	AAPL	Stock	48.3425	48.3675	48.2975	48.3125	791268.0
2018-06-07 10:20:00	AAPL	Stock	48.3112	48.32	48.245	48.3025	928484.0
2018-06-07 10:25:00	AAPL	Stock	48.305	48.3142	48.2725	48.2825	482040.0
2018-06-07 10:30:00	AAPL	Stock	48.2825	48.285	48.1575	48.17	1215744.0

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

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