PREVIEW / stock_5min / 2017-07-05

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-07-05.parquet
  size:    5.3 MB
  rows:    350,385
  symbols: 3,006

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-07-05 04:00:00	AAPL	Stock	35.895	35.895	35.87	35.87	1200.0
2017-07-05 04:05:00	AAPL	Stock	35.835	35.835	35.785	35.785	3140.0
2017-07-05 04:10:00	AAPL	Stock	35.785	35.785	35.785	35.785	400.0
2017-07-05 04:15:00	AAPL	Stock	35.865	35.865	35.865	35.865	400.0
2017-07-05 04:25:00	AAPL	Stock	35.775	35.775	35.775	35.775	740.0
2017-07-05 04:30:00	AAPL	Stock	35.775	35.775	35.775	35.775	2800.0
2017-07-05 04:40:00	AAPL	Stock	35.77	35.77	35.77	35.77	400.0
2017-07-05 05:25:00	AAPL	Stock	35.7875	35.7875	35.7875	35.7875	400.0
2017-07-05 05:50:00	AAPL	Stock	35.755	35.755	35.755	35.755	976.0
2017-07-05 06:20:00	AAPL	Stock	35.7525	35.7525	35.7525	35.7525	400.0
2017-07-05 06:25:00	AAPL	Stock	35.84	35.84	35.84	35.84	2320.0
2017-07-05 06:30:00	AAPL	Stock	35.8375	35.84	35.8375	35.84	1600.0
2017-07-05 06:35:00	AAPL	Stock	35.8	35.8	35.8	35.8	400.0
2017-07-05 06:50:00	AAPL	Stock	35.8175	35.8175	35.8175	35.8175	1200.0
2017-07-05 06:55:00	AAPL	Stock	35.84	35.84	35.8225	35.825	2408.0
2017-07-05 07:00:00	AAPL	Stock	35.8325	35.8325	35.8325	35.8325	800.0
2017-07-05 07:05:00	AAPL	Stock	35.825	35.835	35.815	35.815	8000.0
2017-07-05 07:10:00	AAPL	Stock	35.8075	35.81	35.8075	35.81	2796.0
2017-07-05 07:15:00	AAPL	Stock	35.8125	35.8125	35.8	35.8	5804.0
2017-07-05 07:20:00	AAPL	Stock	35.79	35.79	35.7875	35.7875	2088.0
2017-07-05 07:25:00	AAPL	Stock	35.7925	35.7925	35.7925	35.7925	400.0
2017-07-05 07:40:00	AAPL	Stock	35.815	35.815	35.815	35.815	3600.0
2017-07-05 07:45:00	AAPL	Stock	35.815	35.815	35.815	35.815	400.0
2017-07-05 07:50:00	AAPL	Stock	35.8475	35.8625	35.8475	35.8625	3200.0
2017-07-05 07:55:00	AAPL	Stock	35.885	35.885	35.8825	35.885	6008.0
2017-07-05 08:00:00	AAPL	Stock	35.815	35.9225	35.7875	35.9075	32760.0
2017-07-05 08:05:00	AAPL	Stock	35.9725	35.985	35.95	35.9725	8180.0
2017-07-05 08:10:00	AAPL	Stock	35.9725	36.02	35.9725	36.0025	8244.0
2017-07-05 08:15:00	AAPL	Stock	36.0025	36.0025	35.9775	35.9875	42292.0
2017-07-05 08:20:00	AAPL	Stock	35.99	36.0125	35.9875	36.0	14096.0
2017-07-05 08:25:00	AAPL	Stock	36.0125	36.0125	35.99	36.0	33764.0
2017-07-05 08:30:00	AAPL	Stock	36.0225	36.0225	36.0125	36.0175	10492.0
2017-07-05 08:35:00	AAPL	Stock	36.0175	36.0175	36.0075	36.0175	6276.0
2017-07-05 08:40:00	AAPL	Stock	36.02	36.025	36.02	36.025	47396.0
2017-07-05 08:45:00	AAPL	Stock	36.035	36.0375	36.0075	36.0075	19280.0
2017-07-05 08:50:00	AAPL	Stock	36.0225	36.0325	36.015	36.015	12800.0
2017-07-05 08:55:00	AAPL	Stock	36.015	36.015	35.995	36.0	9060.0
2017-07-05 09:00:00	AAPL	Stock	35.99	35.99	35.9875	35.9875	1420.0
2017-07-05 09:05:00	AAPL	Stock	35.9975	35.9975	35.985	35.985	1104.0
2017-07-05 09:10:00	AAPL	Stock	35.9975	36.01	35.98	36.0	9188.0
2017-07-05 09:15:00	AAPL	Stock	36.01	36.0375	36.0	36.0375	12624.0
2017-07-05 09:20:00	AAPL	Stock	36.02	36.025	36.02	36.025	2400.0
2017-07-05 09:25:00	AAPL	Stock	36.0075	36.0075	35.915	35.9225	89176.0
2017-07-05 09:30:00	AAPL	Stock	35.9225	36.0	35.9	35.965	3350312.0
2017-07-05 09:35:00	AAPL	Stock	35.9652	36.0995	35.9525	36.0718	2090628.0
2017-07-05 09:40:00	AAPL	Stock	36.07	36.0775	35.965	35.996	1184432.0
2017-07-05 09:45:00	AAPL	Stock	36.0062	36.025	35.9075	35.975	1159868.0
2017-07-05 09:50:00	AAPL	Stock	35.9775	36.0225	35.93	35.94	2125396.0
2017-07-05 09:55:00	AAPL	Stock	35.9425	35.97	35.89	35.915	1504352.0
2017-07-05 10:00:00	AAPL	Stock	35.9125	35.9162	35.7675	35.7725	1532112.0

> showing 50 of 350,385 rows — these rows as CSV

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