PREVIEW / stock_5min / 2017-01-17

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-17.parquet
  size:    5.4 MB
  rows:    355,453
  symbols: 3,127

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-01-17 04:00:00	AAPL	Stock	29.685	29.685	29.6725	29.6725	880.0
2017-01-17 05:35:00	AAPL	Stock	29.625	29.625	29.625	29.625	2000.0
2017-01-17 05:50:00	AAPL	Stock	29.62	29.62	29.6	29.6	1944.0
2017-01-17 05:55:00	AAPL	Stock	29.615	29.615	29.6	29.6	1256.0
2017-01-17 06:25:00	AAPL	Stock	29.625	29.625	29.6125	29.6125	4000.0
2017-01-17 06:45:00	AAPL	Stock	29.5675	29.595	29.5675	29.595	4384.0
2017-01-17 06:50:00	AAPL	Stock	29.6	29.625	29.6	29.6225	9416.0
2017-01-17 06:55:00	AAPL	Stock	29.625	29.6425	29.625	29.6425	4156.0
2017-01-17 07:05:00	AAPL	Stock	29.6625	29.675	29.6625	29.665	19356.0
2017-01-17 07:10:00	AAPL	Stock	29.665	29.685	29.665	29.675	6032.0
2017-01-17 07:15:00	AAPL	Stock	29.665	29.665	29.665	29.665	10000.0
2017-01-17 07:20:00	AAPL	Stock	29.675	29.675	29.675	29.675	1200.0
2017-01-17 07:25:00	AAPL	Stock	29.6525	29.6525	29.6525	29.6525	1384.0
2017-01-17 07:35:00	AAPL	Stock	29.6575	29.6575	29.64	29.64	3600.0
2017-01-17 07:40:00	AAPL	Stock	29.635	29.6625	29.635	29.66	11200.0
2017-01-17 07:45:00	AAPL	Stock	29.67	29.6825	29.67	29.675	4000.0
2017-01-17 07:50:00	AAPL	Stock	29.6625	29.675	29.6625	29.675	6804.0
2017-01-17 07:55:00	AAPL	Stock	29.675	29.6825	29.675	29.6825	1600.0
2017-01-17 08:00:00	AAPL	Stock	29.665	29.6875	29.65	29.665	41364.0
2017-01-17 08:05:00	AAPL	Stock	29.6575	29.665	29.65	29.65	33128.0
2017-01-17 08:10:00	AAPL	Stock	29.6575	29.6725	29.6325	29.6325	8148.0
2017-01-17 08:15:00	AAPL	Stock	29.65	29.6625	29.6275	29.6275	5200.0
2017-01-17 08:20:00	AAPL	Stock	29.6275	29.65	29.6275	29.65	14800.0
2017-01-17 08:25:00	AAPL	Stock	29.65	29.65	29.65	29.65	4000.0
2017-01-17 08:30:00	AAPL	Stock	29.6525	29.6525	29.6525	29.6525	2032.0
2017-01-17 08:35:00	AAPL	Stock	29.6525	29.6625	29.65	29.6525	28844.0
2017-01-17 08:40:00	AAPL	Stock	29.655	29.6625	29.65	29.66	37792.0
2017-01-17 08:45:00	AAPL	Stock	29.6625	29.6625	29.65	29.6575	21620.0
2017-01-17 08:50:00	AAPL	Stock	29.6675	29.6725	29.6675	29.6725	4352.0
2017-01-17 08:55:00	AAPL	Stock	29.6675	29.6675	29.6675	29.6675	3000.0
2017-01-17 09:00:00	AAPL	Stock	29.6725	29.6725	29.6475	29.6475	26080.0
2017-01-17 09:05:00	AAPL	Stock	29.6475	29.6475	29.645	29.645	8656.0
2017-01-17 09:10:00	AAPL	Stock	29.645	29.655	29.645	29.645	11344.0
2017-01-17 09:15:00	AAPL	Stock	29.645	29.65	29.645	29.65	20380.0
2017-01-17 09:20:00	AAPL	Stock	29.65	29.65	29.6125	29.6125	61700.0
2017-01-17 09:25:00	AAPL	Stock	29.625	29.625	29.57	29.58	60304.0
2017-01-17 09:30:00	AAPL	Stock	29.58	29.76	29.555	29.7575	7493828.0
2017-01-17 09:35:00	AAPL	Stock	29.7588	29.8325	29.7575	29.7688	3853700.0
2017-01-17 09:40:00	AAPL	Stock	29.7675	29.9112	29.7675	29.89	4333608.0
2017-01-17 09:45:00	AAPL	Stock	29.8875	29.9025	29.83	29.8938	3067744.0
2017-01-17 09:50:00	AAPL	Stock	29.8935	29.9075	29.8425	29.8925	2363352.0
2017-01-17 09:55:00	AAPL	Stock	29.8925	29.945	29.8825	29.8945	3523148.0
2017-01-17 10:00:00	AAPL	Stock	29.895	29.9325	29.8875	29.9062	1510852.0
2017-01-17 10:05:00	AAPL	Stock	29.905	29.9412	29.8938	29.9225	2047564.0
2017-01-17 10:10:00	AAPL	Stock	29.925	29.9575	29.9238	29.9425	2173712.0
2017-01-17 10:15:00	AAPL	Stock	29.9438	29.9662	29.9275	29.955	1676664.0
2017-01-17 10:20:00	AAPL	Stock	29.9538	29.9775	29.95	29.97	2268292.0
2017-01-17 10:25:00	AAPL	Stock	29.9712	29.9775	29.9482	29.9775	1620284.0
2017-01-17 10:30:00	AAPL	Stock	29.975	29.99	29.97	29.98	2032544.0
2017-01-17 10:35:00	AAPL	Stock	29.9812	29.9862	29.9525	29.9545	1218820.0

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

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