PREVIEW / stock_5min / 2015-04-07

all stock 5-min files

  file:    by_date/stock_5min/2015/2015-04-07.parquet
  size:    5.4 MB
  rows:    357,843
  symbols: 3,499

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
2015-04-07 04:00:00	AAPL	Stock	31.93	31.93	31.93	31.93	400.0
2015-04-07 04:15:00	AAPL	Stock	31.8725	31.8725	31.8725	31.8725	1904.0
2015-04-07 04:20:00	AAPL	Stock	31.8375	31.8375	31.8375	31.8375	3684.0
2015-04-07 04:25:00	AAPL	Stock	31.825	31.835	31.825	31.835	1200.0
2015-04-07 04:35:00	AAPL	Stock	31.845	31.845	31.825	31.825	1600.0
2015-04-07 05:00:00	AAPL	Stock	31.85	31.85	31.85	31.85	1200.0
2015-04-07 05:05:00	AAPL	Stock	31.825	31.825	31.825	31.825	400.0
2015-04-07 05:30:00	AAPL	Stock	31.875	31.875	31.875	31.875	400.0
2015-04-07 05:45:00	AAPL	Stock	31.855	31.855	31.855	31.855	1200.0
2015-04-07 06:00:00	AAPL	Stock	31.875	31.88	31.875	31.88	6560.0
2015-04-07 06:05:00	AAPL	Stock	31.895	31.9025	31.895	31.9	11200.0
2015-04-07 06:10:00	AAPL	Stock	31.92	31.9225	31.9175	31.9225	16000.0
2015-04-07 06:20:00	AAPL	Stock	31.9225	31.9225	31.9225	31.9225	800.0
2015-04-07 06:30:00	AAPL	Stock	31.925	31.93	31.9175	31.9175	7232.0
2015-04-07 06:35:00	AAPL	Stock	31.9125	31.9225	31.9125	31.9225	2400.0
2015-04-07 06:40:00	AAPL	Stock	31.9225	31.9225	31.9125	31.9125	3112.0
2015-04-07 06:45:00	AAPL	Stock	31.905	31.9225	31.905	31.9225	4312.0
2015-04-07 06:50:00	AAPL	Stock	31.925	31.925	31.925	31.925	6000.0
2015-04-07 06:55:00	AAPL	Stock	31.9375	31.9425	31.9225	31.9425	7200.0
2015-04-07 07:00:00	AAPL	Stock	31.9425	31.9625	31.9425	31.9625	11368.0
2015-04-07 07:05:00	AAPL	Stock	31.97	31.9975	31.97	31.9825	22696.0
2015-04-07 07:10:00	AAPL	Stock	31.99	32.0225	31.99	32.0225	41984.0
2015-04-07 07:15:00	AAPL	Stock	32.0175	32.03	31.97	31.97	42144.0
2015-04-07 07:20:00	AAPL	Stock	31.9875	31.995	31.9875	31.995	20876.0
2015-04-07 07:25:00	AAPL	Stock	32.0	32.02	32.0	32.005	39320.0
2015-04-07 07:30:00	AAPL	Stock	32.0075	32.01	32.0	32.0025	49848.0
2015-04-07 07:35:00	AAPL	Stock	32.0125	32.0175	32.0125	32.0175	11420.0
2015-04-07 07:40:00	AAPL	Stock	32.0175	32.025	32.0175	32.025	29740.0
2015-04-07 07:45:00	AAPL	Stock	32.02	32.02	32.0025	32.02	19088.0
2015-04-07 07:50:00	AAPL	Stock	32.0225	32.03	32.015	32.015	19572.0
2015-04-07 07:55:00	AAPL	Stock	32.0075	32.0075	31.97	31.985	52296.0
2015-04-07 08:00:00	AAPL	Stock	31.98	32.03	31.9575	32.0025	170908.0
2015-04-07 08:05:00	AAPL	Stock	32.0025	32.025	32.0	32.0125	109612.0
2015-04-07 08:10:00	AAPL	Stock	32.0125	32.02	32.0025	32.015	65116.0
2015-04-07 08:15:00	AAPL	Stock	32.0225	32.0375	32.0212	32.0375	70896.0
2015-04-07 08:20:00	AAPL	Stock	32.04	32.04	32.03	32.0375	47388.0
2015-04-07 08:25:00	AAPL	Stock	32.0375	32.04	32.02	32.0225	50620.0
2015-04-07 08:30:00	AAPL	Stock	32.0175	32.0175	32.0025	32.01	71960.0
2015-04-07 08:35:00	AAPL	Stock	32.01	32.015	31.9925	32.0125	123772.0
2015-04-07 08:40:00	AAPL	Stock	32.01	32.0175	31.9975	32.0075	48392.0
2015-04-07 08:45:00	AAPL	Stock	32.0075	32.0125	32.0025	32.0075	110180.0
2015-04-07 08:50:00	AAPL	Stock	32.0075	32.0175	32.005	32.0125	99892.0
2015-04-07 08:55:00	AAPL	Stock	32.01	32.0175	32.01	32.0102	34456.0
2015-04-07 09:00:00	AAPL	Stock	32.015	32.0175	32.0	32.0125	172252.0
2015-04-07 09:05:00	AAPL	Stock	32.0125	32.015	32.01	32.0125	56156.0
2015-04-07 09:10:00	AAPL	Stock	32.0125	32.0125	31.9525	31.9675	133488.0
2015-04-07 09:15:00	AAPL	Stock	31.9675	31.975	31.9375	31.9475	122644.0
2015-04-07 09:20:00	AAPL	Stock	31.9525	31.9825	31.92	31.9825	122440.0
2015-04-07 09:25:00	AAPL	Stock	31.975	31.985	31.9075	31.91	95636.0
2015-04-07 09:30:00	AAPL	Stock	31.91	32.03	31.8825	32.005	8198972.0

> showing 50 of 357,843 rows — these rows as CSV

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