PREVIEW / stock_5min / 2016-07-01

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-07-01.parquet
  size:    5.3 MB
  rows:    354,503
  symbols: 3,251

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
2016-07-01 04:00:00	AAPL	Stock	23.8475	23.9	23.825	23.825	4400.0
2016-07-01 04:40:00	AAPL	Stock	23.8325	23.8325	23.8325	23.8325	400.0
2016-07-01 04:45:00	AAPL	Stock	23.845	23.845	23.845	23.845	2800.0
2016-07-01 05:30:00	AAPL	Stock	23.7875	23.7875	23.7875	23.7875	864.0
2016-07-01 05:35:00	AAPL	Stock	23.7875	23.7875	23.7875	23.7875	648.0
2016-07-01 05:45:00	AAPL	Stock	23.7875	23.7875	23.7875	23.7875	400.0
2016-07-01 05:55:00	AAPL	Stock	23.7875	23.7875	23.7875	23.7875	1200.0
2016-07-01 06:00:00	AAPL	Stock	23.7875	23.7875	23.7875	23.7875	1156.0
2016-07-01 06:05:00	AAPL	Stock	23.7875	23.7875	23.7875	23.7875	596.0
2016-07-01 06:50:00	AAPL	Stock	23.79	23.79	23.79	23.79	800.0
2016-07-01 07:00:00	AAPL	Stock	23.8225	23.8225	23.8225	23.8225	400.0
2016-07-01 07:15:00	AAPL	Stock	23.8325	23.8375	23.8325	23.8375	5360.0
2016-07-01 07:20:00	AAPL	Stock	23.8375	23.8375	23.8375	23.8375	3600.0
2016-07-01 07:30:00	AAPL	Stock	23.8375	23.85	23.8375	23.85	4960.0
2016-07-01 07:35:00	AAPL	Stock	23.8625	23.8625	23.85	23.85	6760.0
2016-07-01 07:45:00	AAPL	Stock	23.86	23.86	23.86	23.86	400.0
2016-07-01 07:50:00	AAPL	Stock	23.8575	23.8625	23.8575	23.8625	9984.0
2016-07-01 07:55:00	AAPL	Stock	23.875	23.875	23.875	23.875	8160.0
2016-07-01 08:00:00	AAPL	Stock	23.79	23.8875	23.79	23.8725	17800.0
2016-07-01 08:05:00	AAPL	Stock	23.88	23.9	23.88	23.8975	39552.0
2016-07-01 08:10:00	AAPL	Stock	23.8975	23.9	23.89	23.89	16000.0
2016-07-01 08:15:00	AAPL	Stock	23.9	23.9	23.89	23.89	2800.0
2016-07-01 08:20:00	AAPL	Stock	23.89	23.8975	23.8875	23.8875	13120.0
2016-07-01 08:25:00	AAPL	Stock	23.8875	23.895	23.8875	23.895	20880.0
2016-07-01 08:30:00	AAPL	Stock	23.89	23.8975	23.89	23.8975	7300.0
2016-07-01 08:35:00	AAPL	Stock	23.9	23.9	23.8925	23.895	4640.0
2016-07-01 08:40:00	AAPL	Stock	23.89	23.8975	23.8875	23.8975	17248.0
2016-07-01 08:45:00	AAPL	Stock	23.895	23.8975	23.8875	23.8875	4040.0
2016-07-01 08:50:00	AAPL	Stock	23.89	23.89	23.8875	23.8875	4800.0
2016-07-01 08:55:00	AAPL	Stock	23.8875	23.89	23.8875	23.89	7224.0
2016-07-01 09:00:00	AAPL	Stock	23.8875	23.89	23.8875	23.89	2200.0
2016-07-01 09:05:00	AAPL	Stock	23.89	23.89	23.89	23.89	640.0
2016-07-01 09:10:00	AAPL	Stock	23.8975	23.8975	23.8925	23.8925	2468.0
2016-07-01 09:15:00	AAPL	Stock	23.8925	23.8925	23.8925	23.8925	11600.0
2016-07-01 09:20:00	AAPL	Stock	23.8925	23.895	23.8875	23.8875	18000.0
2016-07-01 09:25:00	AAPL	Stock	23.8875	23.9	23.8525	23.865	106032.0
2016-07-01 09:30:00	AAPL	Stock	23.87	23.9275	23.8325	23.8875	3410248.0
2016-07-01 09:35:00	AAPL	Stock	23.8875	23.9398	23.873	23.8875	2471100.0
2016-07-01 09:40:00	AAPL	Stock	23.89	23.9	23.855	23.885	1766908.0
2016-07-01 09:45:00	AAPL	Stock	23.885	23.9335	23.8828	23.9178	1560296.0
2016-07-01 09:50:00	AAPL	Stock	23.92	23.97	23.915	23.9418	2066808.0
2016-07-01 09:55:00	AAPL	Stock	23.94	23.96	23.93	23.9325	1426244.0
2016-07-01 10:00:00	AAPL	Stock	23.935	23.9675	23.93	23.965	1960500.0
2016-07-01 10:05:00	AAPL	Stock	23.9628	23.98	23.9525	23.965	1596076.0
2016-07-01 10:10:00	AAPL	Stock	23.9625	23.99	23.9625	23.9812	1535728.0
2016-07-01 10:15:00	AAPL	Stock	23.98	24.01	23.975	24.0025	1854104.0
2016-07-01 10:20:00	AAPL	Stock	24.0012	24.01	23.985	23.99	1538872.0
2016-07-01 10:25:00	AAPL	Stock	23.99	24.0075	23.985	23.9975	1248988.0
2016-07-01 10:30:00	AAPL	Stock	23.9975	24.0038	23.9875	24.0	1093068.0
2016-07-01 10:35:00	AAPL	Stock	24.0	24.045	23.9975	24.035	1997304.0

> showing 50 of 354,503 rows — these rows as CSV

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