PREVIEW / stock_5min / 2017-03-06

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-06.parquet
  size:    5.4 MB
  rows:    353,882
  symbols: 3,097

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-06 04:35:00	AAPL	Stock	34.85	34.85	34.85	34.85	800.0
2017-03-06 04:45:00	AAPL	Stock	34.845	34.845	34.845	34.845	2228.0
2017-03-06 04:55:00	AAPL	Stock	34.8725	34.8725	34.8725	34.8725	800.0
2017-03-06 05:15:00	AAPL	Stock	34.8125	34.8125	34.8125	34.8125	432.0
2017-03-06 05:50:00	AAPL	Stock	34.86	34.86	34.86	34.86	2000.0
2017-03-06 05:55:00	AAPL	Stock	34.86	34.86	34.86	34.86	1200.0
2017-03-06 06:15:00	AAPL	Stock	34.875	34.875	34.875	34.875	1900.0
2017-03-06 06:30:00	AAPL	Stock	34.885	34.885	34.885	34.885	600.0
2017-03-06 06:40:00	AAPL	Stock	34.8725	34.8725	34.8725	34.8725	4000.0
2017-03-06 06:55:00	AAPL	Stock	34.84	34.84	34.84	34.84	612.0
2017-03-06 07:00:00	AAPL	Stock	34.85	34.85	34.8425	34.8425	6600.0
2017-03-06 07:05:00	AAPL	Stock	34.825	34.825	34.825	34.825	1456.0
2017-03-06 07:10:00	AAPL	Stock	34.8375	34.86	34.825	34.86	5336.0
2017-03-06 07:15:00	AAPL	Stock	34.86	34.86	34.85	34.8575	4000.0
2017-03-06 07:20:00	AAPL	Stock	34.85	34.8625	34.85	34.855	5600.0
2017-03-06 07:25:00	AAPL	Stock	34.855	34.855	34.8375	34.845	3200.0
2017-03-06 07:30:00	AAPL	Stock	34.845	34.845	34.8425	34.8425	6832.0
2017-03-06 07:35:00	AAPL	Stock	34.8375	34.8375	34.8375	34.8375	8880.0
2017-03-06 07:45:00	AAPL	Stock	34.8475	34.8475	34.8425	34.8425	800.0
2017-03-06 07:50:00	AAPL	Stock	34.8375	34.8375	34.825	34.825	2012.0
2017-03-06 07:55:00	AAPL	Stock	34.8175	34.8375	34.815	34.8375	5200.0
2017-03-06 08:00:00	AAPL	Stock	34.825	34.8475	34.825	34.8475	6752.0
2017-03-06 08:05:00	AAPL	Stock	34.8475	34.865	34.8475	34.85	10036.0
2017-03-06 08:10:00	AAPL	Stock	34.8625	34.8675	34.86	34.86	8500.0
2017-03-06 08:15:00	AAPL	Stock	34.8525	34.8525	34.8475	34.8475	2516.0
2017-03-06 08:20:00	AAPL	Stock	34.8475	34.855	34.8475	34.855	17400.0
2017-03-06 08:25:00	AAPL	Stock	34.8575	34.86	34.8475	34.8475	23140.0
2017-03-06 08:30:00	AAPL	Stock	34.84	34.84	34.8375	34.84	9560.0
2017-03-06 08:35:00	AAPL	Stock	34.8525	34.8625	34.8525	34.8575	14836.0
2017-03-06 08:40:00	AAPL	Stock	34.8625	34.8625	34.8575	34.8625	23252.0
2017-03-06 08:45:00	AAPL	Stock	34.85	34.85	34.85	34.85	692.0
2017-03-06 08:50:00	AAPL	Stock	34.845	34.8625	34.845	34.8625	5908.0
2017-03-06 08:55:00	AAPL	Stock	34.86	34.8625	34.8575	34.8575	3600.0
2017-03-06 09:00:00	AAPL	Stock	34.8575	34.8625	34.8575	34.8625	13828.0
2017-03-06 09:05:00	AAPL	Stock	34.8625	34.87	34.8625	34.87	9788.0
2017-03-06 09:10:00	AAPL	Stock	34.8675	34.87	34.865	34.865	25260.0
2017-03-06 09:15:00	AAPL	Stock	34.85	34.8625	34.85	34.8625	4400.0
2017-03-06 09:20:00	AAPL	Stock	34.86	34.86	34.8375	34.85	41312.0
2017-03-06 09:25:00	AAPL	Stock	34.845	34.85	34.83	34.85	22344.0
2017-03-06 09:30:00	AAPL	Stock	34.8412	34.9425	34.8225	34.9015	3969584.0
2017-03-06 09:35:00	AAPL	Stock	34.9	34.9038	34.8025	34.855	1837204.0
2017-03-06 09:40:00	AAPL	Stock	34.8525	34.89	34.815	34.8535	1616320.0
2017-03-06 09:45:00	AAPL	Stock	34.85	34.855	34.8125	34.824	1528176.0
2017-03-06 09:50:00	AAPL	Stock	34.8237	34.83	34.795	34.8062	1699116.0
2017-03-06 09:55:00	AAPL	Stock	34.805	34.82	34.7712	34.8175	1432560.0
2017-03-06 10:00:00	AAPL	Stock	34.8182	34.8182	34.745	34.754	1667896.0
2017-03-06 10:05:00	AAPL	Stock	34.7525	34.78	34.7302	34.775	1297752.0
2017-03-06 10:10:00	AAPL	Stock	34.7775	34.785	34.75	34.76	1042660.0
2017-03-06 10:15:00	AAPL	Stock	34.7575	34.7725	34.715	34.72	1192492.0
2017-03-06 10:20:00	AAPL	Stock	34.72	34.7275	34.675	34.6875	1480852.0

> showing 50 of 353,882 rows — these rows as CSV

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