PREVIEW / stock_5min / 2017-03-23

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-23.parquet
  size:    5.3 MB
  rows:    348,841
  symbols: 3,061

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-03-23 04:20:00	AAPL	Stock	35.32	35.32	35.32	35.32	1808.0
2017-03-23 04:55:00	AAPL	Stock	35.285	35.3	35.2825	35.3	2460.0
2017-03-23 07:00:00	AAPL	Stock	35.3475	35.35	35.3475	35.35	9924.0
2017-03-23 07:25:00	AAPL	Stock	35.3625	35.3625	35.3625	35.3625	3920.0
2017-03-23 07:30:00	AAPL	Stock	35.365	35.37	35.35	35.35	4272.0
2017-03-23 07:35:00	AAPL	Stock	35.35	35.35	35.35	35.35	1340.0
2017-03-23 07:40:00	AAPL	Stock	35.3675	35.3675	35.35	35.35	11000.0
2017-03-23 07:45:00	AAPL	Stock	35.325	35.325	35.325	35.325	400.0
2017-03-23 07:55:00	AAPL	Stock	35.3275	35.34	35.325	35.34	5900.0
2017-03-23 08:00:00	AAPL	Stock	35.35	35.375	35.325	35.3375	16640.0
2017-03-23 08:05:00	AAPL	Stock	35.3475	35.3475	35.3475	35.3475	1200.0
2017-03-23 08:10:00	AAPL	Stock	35.3375	35.3375	35.3375	35.3375	400.0
2017-03-23 08:15:00	AAPL	Stock	35.345	35.345	35.345	35.345	4340.0
2017-03-23 08:20:00	AAPL	Stock	35.34	35.345	35.34	35.345	6400.0
2017-03-23 08:25:00	AAPL	Stock	35.345	35.3475	35.345	35.3475	11440.0
2017-03-23 08:30:00	AAPL	Stock	35.3475	35.3875	35.3475	35.37	111576.0
2017-03-23 08:35:00	AAPL	Stock	35.365	35.385	35.355	35.375	23000.0
2017-03-23 08:40:00	AAPL	Stock	35.375	35.3875	35.3675	35.3725	5504.0
2017-03-23 08:45:00	AAPL	Stock	35.365	35.375	35.36	35.375	4800.0
2017-03-23 08:50:00	AAPL	Stock	35.375	35.3775	35.36	35.3775	10020.0
2017-03-23 08:55:00	AAPL	Stock	35.37	35.37	35.335	35.335	26784.0
2017-03-23 09:00:00	AAPL	Stock	35.33	35.33	35.3025	35.3125	31352.0
2017-03-23 09:05:00	AAPL	Stock	35.3025	35.3225	35.3	35.3225	14144.0
2017-03-23 09:10:00	AAPL	Stock	35.3225	35.3475	35.3225	35.33	56764.0
2017-03-23 09:15:00	AAPL	Stock	35.3275	35.3275	35.3	35.3	19824.0
2017-03-23 09:20:00	AAPL	Stock	35.31	35.3225	35.31	35.3225	16324.0
2017-03-23 09:25:00	AAPL	Stock	35.32	35.345	35.3	35.32	53784.0
2017-03-23 09:30:00	AAPL	Stock	35.315	35.37	35.225	35.2535	3674360.0
2017-03-23 09:35:00	AAPL	Stock	35.2525	35.31	35.207	35.2215	2310944.0
2017-03-23 09:40:00	AAPL	Stock	35.2225	35.2475	35.18	35.1975	1580420.0
2017-03-23 09:45:00	AAPL	Stock	35.1975	35.225	35.16	35.2195	1359508.0
2017-03-23 09:50:00	AAPL	Stock	35.215	35.2175	35.155	35.1725	1236852.0
2017-03-23 09:55:00	AAPL	Stock	35.175	35.22	35.1625	35.19	998348.0
2017-03-23 10:00:00	AAPL	Stock	35.1905	35.2722	35.19	35.244	1361712.0
2017-03-23 10:05:00	AAPL	Stock	35.245	35.245	35.2	35.2075	717728.0
2017-03-23 10:10:00	AAPL	Stock	35.2088	35.2088	35.1525	35.1725	1042108.0
2017-03-23 10:15:00	AAPL	Stock	35.171	35.2012	35.165	35.195	762260.0
2017-03-23 10:20:00	AAPL	Stock	35.195	35.2375	35.19	35.2375	935592.0
2017-03-23 10:25:00	AAPL	Stock	35.2375	35.24	35.21	35.22	577492.0
2017-03-23 10:30:00	AAPL	Stock	35.22	35.25	35.2088	35.2375	739448.0
2017-03-23 10:35:00	AAPL	Stock	35.24	35.2725	35.24	35.265	671724.0
2017-03-23 10:40:00	AAPL	Stock	35.2675	35.2975	35.265	35.2825	797496.0
2017-03-23 10:45:00	AAPL	Stock	35.285	35.3	35.27	35.271	910296.0
2017-03-23 10:50:00	AAPL	Stock	35.2725	35.32	35.2725	35.3175	710312.0
2017-03-23 10:55:00	AAPL	Stock	35.32	35.325	35.2825	35.2825	741408.0
2017-03-23 11:00:00	AAPL	Stock	35.285	35.3125	35.2775	35.2825	679508.0
2017-03-23 11:05:00	AAPL	Stock	35.2825	35.3025	35.26	35.3025	671080.0
2017-03-23 11:10:00	AAPL	Stock	35.3	35.335	35.275	35.3075	863224.0
2017-03-23 11:15:00	AAPL	Stock	35.3125	35.3475	35.3125	35.3375	979680.0
2017-03-23 11:20:00	AAPL	Stock	35.34	35.3425	35.3025	35.305	670756.0

> showing 50 of 348,841 rows — these rows as CSV

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