PREVIEW / stock_5min / 2017-02-23

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-02-23.parquet
  size:    5.5 MB
  rows:    355,528
  symbols: 3,086

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
2017-02-23 05:05:00	AAPL	Stock	34.29	34.29	34.29	34.29	3600.0
2017-02-23 05:45:00	AAPL	Stock	34.3175	34.3175	34.3175	34.3175	604.0
2017-02-23 06:00:00	AAPL	Stock	34.29	34.29	34.29	34.29	976.0
2017-02-23 06:05:00	AAPL	Stock	34.3	34.3	34.2925	34.2925	868.0
2017-02-23 06:15:00	AAPL	Stock	34.2875	34.2875	34.2875	34.2875	400.0
2017-02-23 06:25:00	AAPL	Stock	34.2875	34.2875	34.2875	34.2875	400.0
2017-02-23 07:00:00	AAPL	Stock	34.3375	34.3375	34.3375	34.3375	1000.0
2017-02-23 07:25:00	AAPL	Stock	34.335	34.3375	34.335	34.3375	7600.0
2017-02-23 07:30:00	AAPL	Stock	34.34	34.34	34.3375	34.3375	9200.0
2017-02-23 07:40:00	AAPL	Stock	34.3425	34.3425	34.33	34.3375	9720.0
2017-02-23 07:45:00	AAPL	Stock	34.34	34.34	34.33	34.33	3264.0
2017-02-23 07:50:00	AAPL	Stock	34.3375	34.3375	34.33	34.33	4000.0
2017-02-23 07:55:00	AAPL	Stock	34.32	34.32	34.32	34.32	400.0
2017-02-23 08:00:00	AAPL	Stock	34.3175	34.33	34.31	34.3125	34296.0
2017-02-23 08:05:00	AAPL	Stock	34.3175	34.3175	34.3175	34.3175	3600.0
2017-02-23 08:10:00	AAPL	Stock	34.3225	34.325	34.3225	34.3225	3996.0
2017-02-23 08:15:00	AAPL	Stock	34.325	34.335	34.3175	34.3275	43876.0
2017-02-23 08:20:00	AAPL	Stock	34.325	34.325	34.325	34.325	1180.0
2017-02-23 08:25:00	AAPL	Stock	34.3325	34.3375	34.325	34.325	4436.0
2017-02-23 08:30:00	AAPL	Stock	34.3375	34.3375	34.335	34.3375	5800.0
2017-02-23 08:35:00	AAPL	Stock	34.3375	34.3425	34.33	34.3425	5528.0
2017-02-23 08:40:00	AAPL	Stock	34.3325	34.34	34.3	34.3125	65396.0
2017-02-23 08:45:00	AAPL	Stock	34.32	34.3225	34.31	34.31	6540.0
2017-02-23 08:50:00	AAPL	Stock	34.32	34.32	34.31	34.31	4080.0
2017-02-23 08:55:00	AAPL	Stock	34.31	34.3125	34.3075	34.3075	5600.0
2017-02-23 09:00:00	AAPL	Stock	34.3075	34.3075	34.3075	34.3075	8000.0
2017-02-23 09:05:00	AAPL	Stock	34.3225	34.3225	34.31	34.3125	19260.0
2017-02-23 09:10:00	AAPL	Stock	34.32	34.32	34.305	34.3075	19780.0
2017-02-23 09:15:00	AAPL	Stock	34.3175	34.325	34.315	34.325	16932.0
2017-02-23 09:20:00	AAPL	Stock	34.315	34.3275	34.315	34.3275	13008.0
2017-02-23 09:25:00	AAPL	Stock	34.3275	34.375	34.3275	34.345	47576.0
2017-02-23 09:30:00	AAPL	Stock	34.345	34.37	34.275	34.3138	4344236.0
2017-02-23 09:35:00	AAPL	Stock	34.315	34.3225	34.2425	34.27	2702120.0
2017-02-23 09:40:00	AAPL	Stock	34.2698	34.2725	34.2025	34.21	2094340.0
2017-02-23 09:45:00	AAPL	Stock	34.2125	34.2275	34.1725	34.205	2156184.0
2017-02-23 09:50:00	AAPL	Stock	34.205	34.235	34.2035	34.23	1202296.0
2017-02-23 09:55:00	AAPL	Stock	34.23	34.2725	34.23	34.2675	1259276.0
2017-02-23 10:00:00	AAPL	Stock	34.2688	34.275	34.2325	34.2525	886424.0
2017-02-23 10:05:00	AAPL	Stock	34.25	34.2975	34.24	34.2425	1417164.0
2017-02-23 10:10:00	AAPL	Stock	34.2415	34.2438	34.185	34.1888	1758176.0
2017-02-23 10:15:00	AAPL	Stock	34.1888	34.2125	34.165	34.18	1887244.0
2017-02-23 10:20:00	AAPL	Stock	34.1835	34.185	34.1525	34.161	1397352.0
2017-02-23 10:25:00	AAPL	Stock	34.16	34.1975	34.1388	34.1825	1267572.0
2017-02-23 10:30:00	AAPL	Stock	34.1825	34.251	34.1825	34.2175	788232.0
2017-02-23 10:35:00	AAPL	Stock	34.22	34.22	34.1875	34.1925	691444.0
2017-02-23 10:40:00	AAPL	Stock	34.1915	34.1975	34.16	34.16	685664.0
2017-02-23 10:45:00	AAPL	Stock	34.1575	34.1712	34.1512	34.1525	1070440.0
2017-02-23 10:50:00	AAPL	Stock	34.155	34.155	34.105	34.1125	1792720.0
2017-02-23 10:55:00	AAPL	Stock	34.1125	34.1325	34.0925	34.0975	1616752.0
2017-02-23 11:00:00	AAPL	Stock	34.0982	34.1025	34.075	34.0822	1623588.0

> showing 50 of 355,528 rows — these rows as CSV

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