PREVIEW / stock_5min / 2017-08-30

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-08-30.parquet
  size:    5.3 MB
  rows:    345,770
  symbols: 2,979

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-08-30 04:00:00	AAPL	Stock	40.9525	40.9525	40.875	40.88	10804.0
2017-08-30 04:05:00	AAPL	Stock	40.88	40.8875	40.875	40.875	3520.0
2017-08-30 04:10:00	AAPL	Stock	40.9225	40.9225	40.9225	40.9225	3964.0
2017-08-30 04:20:00	AAPL	Stock	40.92	40.92	40.8875	40.8875	1200.0
2017-08-30 04:30:00	AAPL	Stock	40.875	40.8775	40.875	40.8775	3964.0
2017-08-30 04:40:00	AAPL	Stock	40.875	40.875	40.875	40.875	4000.0
2017-08-30 04:45:00	AAPL	Stock	40.9	40.9	40.9	40.9	400.0
2017-08-30 05:00:00	AAPL	Stock	40.8725	40.8725	40.8725	40.8725	400.0
2017-08-30 05:15:00	AAPL	Stock	40.875	40.875	40.855	40.855	1084.0
2017-08-30 05:25:00	AAPL	Stock	40.855	40.855	40.855	40.855	840.0
2017-08-30 06:00:00	AAPL	Stock	40.8275	40.8275	40.8275	40.8275	1600.0
2017-08-30 06:10:00	AAPL	Stock	40.835	40.8375	40.835	40.8375	1200.0
2017-08-30 06:15:00	AAPL	Stock	40.8375	40.8375	40.8375	40.8375	2400.0
2017-08-30 06:20:00	AAPL	Stock	40.8375	40.8375	40.8375	40.8375	2000.0
2017-08-30 06:25:00	AAPL	Stock	40.8375	40.8375	40.8375	40.8375	1824.0
2017-08-30 06:30:00	AAPL	Stock	40.8525	40.8525	40.8525	40.8525	800.0
2017-08-30 06:35:00	AAPL	Stock	40.8525	40.8525	40.8525	40.8525	1440.0
2017-08-30 06:45:00	AAPL	Stock	40.8525	40.8525	40.8525	40.8525	948.0
2017-08-30 06:50:00	AAPL	Stock	40.8525	40.855	40.8525	40.855	7644.0
2017-08-30 07:00:00	AAPL	Stock	40.865	40.9125	40.865	40.8875	39312.0
2017-08-30 07:05:00	AAPL	Stock	40.8975	40.9125	40.875	40.875	22200.0
2017-08-30 07:10:00	AAPL	Stock	40.8775	40.8875	40.7318	40.85	11980.0
2017-08-30 07:15:00	AAPL	Stock	40.85	40.85	40.8075	40.8075	8108.0
2017-08-30 07:20:00	AAPL	Stock	40.8025	40.825	40.7925	40.825	19684.0
2017-08-30 07:25:00	AAPL	Stock	40.8	40.8125	40.8	40.8125	1792.0
2017-08-30 07:30:00	AAPL	Stock	40.8175	40.8425	40.79	40.8	14888.0
2017-08-30 07:35:00	AAPL	Stock	40.8	40.8225	40.8	40.8225	2188.0
2017-08-30 07:40:00	AAPL	Stock	40.8225	40.8225	40.8225	40.8225	2584.0
2017-08-30 07:45:00	AAPL	Stock	40.8225	40.845	40.8225	40.8425	9520.0
2017-08-30 07:50:00	AAPL	Stock	40.8425	40.8425	40.84	40.8425	10360.0
2017-08-30 07:55:00	AAPL	Stock	40.8425	40.85	40.8425	40.85	9816.0
2017-08-30 08:00:00	AAPL	Stock	40.83	40.9	40.825	40.8875	99208.0
2017-08-30 08:05:00	AAPL	Stock	40.8875	40.91	40.8775	40.88	80420.0
2017-08-30 08:10:00	AAPL	Stock	40.885	40.8975	40.87	40.88	25664.0
2017-08-30 08:15:00	AAPL	Stock	40.8875	40.9	40.87	40.9	45404.0
2017-08-30 08:20:00	AAPL	Stock	40.9	40.905	40.88	40.9	24016.0
2017-08-30 08:25:00	AAPL	Stock	40.9	40.9	40.8875	40.8875	36488.0
2017-08-30 08:30:00	AAPL	Stock	40.8775	40.9225	40.875	40.9225	92176.0
2017-08-30 08:35:00	AAPL	Stock	40.925	40.935	40.9025	40.9125	116696.0
2017-08-30 08:40:00	AAPL	Stock	40.9	40.9025	40.875	40.895	92628.0
2017-08-30 08:45:00	AAPL	Stock	40.8775	40.8775	40.8525	40.855	119040.0
2017-08-30 08:50:00	AAPL	Stock	40.855	40.8875	40.84	40.87	102852.0
2017-08-30 08:55:00	AAPL	Stock	40.8825	40.9175	40.875	40.9	61280.0
2017-08-30 09:00:00	AAPL	Stock	40.91	40.9175	40.88	40.89	66356.0
2017-08-30 09:05:00	AAPL	Stock	40.91	40.9125	40.8925	40.895	40704.0
2017-08-30 09:10:00	AAPL	Stock	40.8975	40.905	40.8875	40.9	93976.0
2017-08-30 09:15:00	AAPL	Stock	40.9	40.905	40.8875	40.8875	17220.0
2017-08-30 09:20:00	AAPL	Stock	40.8875	40.91	40.88	40.88	81356.0
2017-08-30 09:25:00	AAPL	Stock	40.88	40.97	40.875	40.9475	168640.0
2017-08-30 09:30:00	AAPL	Stock	40.93	40.9725	40.815	40.8282	5474980.0

> showing 50 of 345,770 rows — these rows as CSV

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