PREVIEW / stock_30min / 2016-06-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-22.parquet
  size:    1.5 MB
  rows:    81,011
  symbols: 3,291

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-06-22 04:30:00	AAPL	Stock	24.0125	24.0125	24.0125	24.0125	1400.0
2016-06-22 05:30:00	AAPL	Stock	24.0475	24.0475	24.0475	24.0475	480.0
2016-06-22 06:00:00	AAPL	Stock	24.0625	24.0625	24.0375	24.0375	1960.0
2016-06-22 06:30:00	AAPL	Stock	24.06	24.0725	24.06	24.0725	6400.0
2016-06-22 07:00:00	AAPL	Stock	24.075	24.1525	24.06	24.1375	68292.0
2016-06-22 07:30:00	AAPL	Stock	24.1375	24.175	24.1375	24.1625	49676.0
2016-06-22 08:00:00	AAPL	Stock	24.1625	24.175	24.05	24.14	459696.0
2016-06-22 08:30:00	AAPL	Stock	24.14	24.1675	24.1125	24.1225	111084.0
2016-06-22 09:00:00	AAPL	Stock	24.1175	24.1475	24.06	24.0625	227016.0
2016-06-22 09:30:00	AAPL	Stock	24.0625	24.2225	24.0625	24.15	14559772.0
2016-06-22 10:00:00	AAPL	Stock	24.155	24.1875	24.105	24.14	8056172.0
2016-06-22 10:30:00	AAPL	Stock	24.14	24.2175	24.1125	24.1912	7143028.0
2016-06-22 11:00:00	AAPL	Stock	24.1925	24.2075	24.1425	24.1725	4417956.0
2016-06-22 11:30:00	AAPL	Stock	24.17	24.17	24.075	24.0875	6989992.0
2016-06-22 12:00:00	AAPL	Stock	24.0855	24.0975	23.9125	23.9575	9994224.0
2016-06-22 12:30:00	AAPL	Stock	23.96	23.96	23.885	23.94	7558600.0
2016-06-22 13:00:00	AAPL	Stock	23.9425	23.9425	23.8375	23.8775	7722052.0
2016-06-22 13:30:00	AAPL	Stock	23.8775	23.96	23.865	23.935	6136772.0
2016-06-22 14:00:00	AAPL	Stock	23.9328	23.9625	23.9088	23.9475	3983400.0
2016-06-22 14:30:00	AAPL	Stock	23.945	23.9575	23.8975	23.915	4169408.0
2016-06-22 15:00:00	AAPL	Stock	23.915	23.9625	23.875	23.8825	6047776.0
2016-06-22 15:30:00	AAPL	Stock	23.8835	23.94	23.8412	23.89	11556692.0
2016-06-22 16:00:00	AAPL	Stock	23.8875	23.895	23.885	23.895	6888068.0
2016-06-22 16:30:00	AAPL	Stock	23.8875	23.9	23.8875	23.8975	293228.0
2016-06-22 17:00:00	AAPL	Stock	23.9	23.9125	23.89	23.905	69324.0
2016-06-22 17:30:00	AAPL	Stock	23.92	23.925	23.905	23.92	30420.0
2016-06-22 18:00:00	AAPL	Stock	23.9325	23.97	23.925	23.97	95640.0
2016-06-22 18:30:00	AAPL	Stock	23.9625	23.965	23.94	23.94	39900.0
2016-06-22 19:00:00	AAPL	Stock	23.9525	23.9525	23.94	23.9525	10200.0
2016-06-22 19:30:00	AAPL	Stock	23.955	23.9575	23.945	23.9575	20104.0
2016-06-22 06:00:00	MSFT	Stock	51.5	51.5	51.5	51.5	100.0
2016-06-22 07:00:00	MSFT	Stock	51.24	51.24	51.22	51.22	989.0
2016-06-22 07:30:00	MSFT	Stock	51.45	51.45	51.45	51.45	200.0
2016-06-22 08:00:00	MSFT	Stock	51.23	51.45	51.23	51.23	2800.0
2016-06-22 08:30:00	MSFT	Stock	51.25	51.25	51.25	51.25	2000.0
2016-06-22 09:00:00	MSFT	Stock	51.39	51.39	51.04	51.04	12845.0
2016-06-22 09:30:00	MSFT	Stock	51.05	51.46	51.05	51.335	3171463.0
2016-06-22 10:00:00	MSFT	Stock	51.33	51.35	51.11	51.175	2246464.0
2016-06-22 10:30:00	MSFT	Stock	51.175	51.305	51.13	51.305	1876376.0
2016-06-22 11:00:00	MSFT	Stock	51.31	51.33	51.21	51.264	1684131.0
2016-06-22 11:30:00	MSFT	Stock	51.26	51.26	51.2	51.214	1606688.0
2016-06-22 12:00:00	MSFT	Stock	51.22	51.28	51.0	51.034	1627092.0
2016-06-22 12:30:00	MSFT	Stock	51.035	51.26	50.99	51.24	1205909.0
2016-06-22 13:00:00	MSFT	Stock	51.235	51.235	50.99	51.14	1399177.0
2016-06-22 13:30:00	MSFT	Stock	51.14	51.28	51.066	51.21	936298.0
2016-06-22 14:00:00	MSFT	Stock	51.214	51.27	51.11	51.17	1269650.0
2016-06-22 14:30:00	MSFT	Stock	51.17	51.21	51.01	51.18	1397442.0
2016-06-22 15:00:00	MSFT	Stock	51.17	51.22	51.04	51.05	1706838.0
2016-06-22 15:30:00	MSFT	Stock	51.05	51.14	50.952	51.0	3892272.0
2016-06-22 16:00:00	MSFT	Stock	50.99	51.04	50.96	50.96	2784320.0

> showing 50 of 81,011 rows — these rows as CSV

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