PREVIEW / stock_5min / 2018-08-01

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-01.parquet
  size:    5.5 MB
  rows:    357,146
  symbols: 2,799

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-08-01 04:00:00	AAPL	Stock	49.3225	49.4725	49.3225	49.42	41336.0
2018-08-01 04:05:00	AAPL	Stock	49.3775	49.3775	49.375	49.375	2248.0
2018-08-01 04:10:00	AAPL	Stock	49.355	49.3575	49.355	49.3575	2480.0
2018-08-01 04:15:00	AAPL	Stock	49.375	49.375	49.3025	49.32	18212.0
2018-08-01 04:20:00	AAPL	Stock	49.37	49.37	49.3025	49.3025	4008.0
2018-08-01 04:25:00	AAPL	Stock	49.38	49.38	49.3025	49.325	12040.0
2018-08-01 04:30:00	AAPL	Stock	49.325	49.325	49.25	49.25	28120.0
2018-08-01 04:35:00	AAPL	Stock	49.24	49.25	49.225	49.225	24284.0
2018-08-01 04:40:00	AAPL	Stock	49.225	49.25	49.225	49.25	1000.0
2018-08-01 04:50:00	AAPL	Stock	49.225	49.225	49.1775	49.18	12008.0
2018-08-01 04:55:00	AAPL	Stock	49.1775	49.25	49.1775	49.25	22900.0
2018-08-01 05:05:00	AAPL	Stock	49.19	49.26	49.19	49.26	10152.0
2018-08-01 05:10:00	AAPL	Stock	49.3	49.3	49.27	49.27	6520.0
2018-08-01 05:15:00	AAPL	Stock	49.27	49.27	49.27	49.27	416.0
2018-08-01 05:20:00	AAPL	Stock	49.24	49.24	49.24	49.24	1536.0
2018-08-01 05:25:00	AAPL	Stock	49.2525	49.27	49.2525	49.27	2060.0
2018-08-01 05:40:00	AAPL	Stock	49.275	49.275	49.275	49.275	732.0
2018-08-01 05:45:00	AAPL	Stock	49.29	49.3	49.26	49.26	16624.0
2018-08-01 05:50:00	AAPL	Stock	49.275	49.29	49.25	49.25	21288.0
2018-08-01 05:55:00	AAPL	Stock	49.245	49.25	49.2125	49.2375	8644.0
2018-08-01 06:00:00	AAPL	Stock	49.2175	49.2175	49.175	49.175	11236.0
2018-08-01 06:05:00	AAPL	Stock	49.225	49.2425	49.225	49.2425	7740.0
2018-08-01 06:10:00	AAPL	Stock	49.2425	49.2425	49.2125	49.2125	9696.0
2018-08-01 06:15:00	AAPL	Stock	49.1875	49.1875	49.18	49.18	5800.0
2018-08-01 06:20:00	AAPL	Stock	49.1975	49.2175	49.1625	49.2175	14184.0
2018-08-01 06:25:00	AAPL	Stock	49.2125	49.3	49.195	49.3	40340.0
2018-08-01 06:30:00	AAPL	Stock	49.3225	49.375	49.3225	49.375	20652.0
2018-08-01 06:35:00	AAPL	Stock	49.315	49.36	49.3	49.36	13180.0
2018-08-01 06:40:00	AAPL	Stock	49.3675	49.45	49.3625	49.445	64912.0
2018-08-01 06:45:00	AAPL	Stock	49.3775	49.4375	49.3775	49.3775	23176.0
2018-08-01 06:50:00	AAPL	Stock	49.42	49.45	49.42	49.45	8680.0
2018-08-01 06:55:00	AAPL	Stock	49.405	49.435	49.375	49.375	37736.0
2018-08-01 07:00:00	AAPL	Stock	49.3875	49.5375	49.375	49.47	157512.0
2018-08-01 07:05:00	AAPL	Stock	49.495	49.5125	49.375	49.375	85756.0
2018-08-01 07:10:00	AAPL	Stock	49.4	49.425	49.3875	49.4	28284.0
2018-08-01 07:15:00	AAPL	Stock	49.39	49.475	49.375	49.4375	55284.0
2018-08-01 07:20:00	AAPL	Stock	49.4375	49.4525	49.415	49.415	15292.0
2018-08-01 07:25:00	AAPL	Stock	49.4	49.5425	49.4	49.54	80852.0
2018-08-01 07:30:00	AAPL	Stock	49.54	49.555	49.4275	49.5275	82868.0
2018-08-01 07:35:00	AAPL	Stock	49.525	49.5275	49.4425	49.4625	47264.0
2018-08-01 07:40:00	AAPL	Stock	49.47	49.625	49.47	49.5875	125928.0
2018-08-01 07:45:00	AAPL	Stock	49.5875	49.6475	49.575	49.62	109536.0
2018-08-01 07:50:00	AAPL	Stock	49.625	49.72	49.6175	49.6875	121672.0
2018-08-01 07:55:00	AAPL	Stock	49.6875	49.745	49.6675	49.7125	145324.0
2018-08-01 08:00:00	AAPL	Stock	49.425	49.725	49.375	49.6625	429224.0
2018-08-01 08:05:00	AAPL	Stock	49.6725	49.775	49.6625	49.7125	254056.0
2018-08-01 08:10:00	AAPL	Stock	49.7175	49.8125	49.6875	49.8125	304396.0
2018-08-01 08:15:00	AAPL	Stock	49.8	49.85	49.755	49.825	285152.0
2018-08-01 08:20:00	AAPL	Stock	49.8375	49.85	49.6875	49.71	273780.0
2018-08-01 08:25:00	AAPL	Stock	49.7	49.75	49.6475	49.6475	180712.0

> showing 50 of 357,146 rows — these rows as CSV

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