PREVIEW / stock_30min / 2015-07-10

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-10.parquet
  size:    1.6 MB
  rows:    82,446
  symbols: 3,493

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-07-10 04:00:00	AAPL	Stock	30.45	30.45	30.3575	30.395	21968.0
2015-07-10 04:30:00	AAPL	Stock	30.36	30.4	30.31	30.31	23724.0
2015-07-10 05:00:00	AAPL	Stock	30.3125	30.375	30.305	30.31	8660.0
2015-07-10 05:30:00	AAPL	Stock	30.37	30.375	30.37	30.375	14924.0
2015-07-10 06:00:00	AAPL	Stock	30.3725	30.42	30.3525	30.42	30724.0
2015-07-10 06:30:00	AAPL	Stock	30.425	30.425	30.3975	30.425	67332.0
2015-07-10 07:00:00	AAPL	Stock	30.4325	30.5	30.4125	30.47	238800.0
2015-07-10 07:30:00	AAPL	Stock	30.4725	30.4725	30.35	30.395	237660.0
2015-07-10 08:00:00	AAPL	Stock	30.385	30.5	30.3625	30.3925	648952.0
2015-07-10 08:30:00	AAPL	Stock	30.3925	30.475	30.3625	30.455	863388.0
2015-07-10 09:00:00	AAPL	Stock	30.455	30.535	30.415	30.485	1160728.0
2015-07-10 09:30:00	AAPL	Stock	30.485	30.555	30.3025	30.5125	41921916.0
2015-07-10 10:00:00	AAPL	Stock	30.51	30.76	30.5075	30.72	35825556.0
2015-07-10 10:30:00	AAPL	Stock	30.72	30.785	30.61	30.723	22706836.0
2015-07-10 11:00:00	AAPL	Stock	30.7262	30.8	30.7175	30.7725	15423808.0
2015-07-10 11:30:00	AAPL	Stock	30.7702	30.8175	30.72	30.7725	12232580.0
2015-07-10 12:00:00	AAPL	Stock	30.7725	30.7875	30.7	30.7525	9359320.0
2015-07-10 12:30:00	AAPL	Stock	30.755	30.7775	30.6	30.76	11055232.0
2015-07-10 13:00:00	AAPL	Stock	30.76	30.7675	30.71	30.7342	6416576.0
2015-07-10 13:30:00	AAPL	Stock	30.7332	30.7925	30.7325	30.7818	6104592.0
2015-07-10 14:00:00	AAPL	Stock	30.78	30.8875	30.7675	30.86	10764768.0
2015-07-10 14:30:00	AAPL	Stock	30.8582	30.9562	30.8425	30.9148	11570420.0
2015-07-10 15:00:00	AAPL	Stock	30.915	30.9625	30.875	30.883	11084892.0
2015-07-10 15:30:00	AAPL	Stock	30.8825	30.905	30.8125	30.815	20959540.0
2015-07-10 16:00:00	AAPL	Stock	30.815	30.8575	30.66	30.8125	11477368.0
2015-07-10 16:30:00	AAPL	Stock	30.8125	30.82	30.78	30.79	199648.0
2015-07-10 17:00:00	AAPL	Stock	30.78	30.8175	30.78	30.815	66964.0
2015-07-10 17:30:00	AAPL	Stock	30.815	30.8175	30.77	30.8175	74656.0
2015-07-10 18:00:00	AAPL	Stock	30.8125	30.8325	30.8	30.82	65144.0
2015-07-10 18:30:00	AAPL	Stock	30.8325	30.8375	30.8275	30.8375	16224.0
2015-07-10 19:00:00	AAPL	Stock	30.8275	30.835	30.82	30.82	20408.0
2015-07-10 19:30:00	AAPL	Stock	30.825	30.835	30.82	30.83	54560.0
2015-07-10 04:00:00	MSFT	Stock	45.04	45.04	45.02	45.02	300.0
2015-07-10 06:00:00	MSFT	Stock	45.0	45.0	45.0	45.0	100.0
2015-07-10 06:30:00	MSFT	Stock	44.95	44.95	44.95	44.95	200.0
2015-07-10 07:00:00	MSFT	Stock	45.0	45.0	45.0	45.0	1400.0
2015-07-10 07:30:00	MSFT	Stock	45.0	45.01	45.0	45.01	1900.0
2015-07-10 08:00:00	MSFT	Stock	44.95	45.05	44.85	45.0	19689.0
2015-07-10 08:30:00	MSFT	Stock	44.997	45.0	44.9	45.0	14640.0
2015-07-10 09:00:00	MSFT	Stock	45.0	45.17	44.98	45.09	15879.0
2015-07-10 09:30:00	MSFT	Stock	45.09	45.14	44.8	44.81	2613279.0
2015-07-10 10:00:00	MSFT	Stock	44.81	44.96	44.77	44.795	1428574.0
2015-07-10 10:30:00	MSFT	Stock	44.8	44.89	44.63	44.83	1760284.0
2015-07-10 11:00:00	MSFT	Stock	44.83	45.08	44.82	44.97	1455910.0
2015-07-10 11:30:00	MSFT	Stock	44.97	45.11	44.89	45.01	1606094.0
2015-07-10 12:00:00	MSFT	Stock	45.015	45.09	44.94	44.96	1418519.0
2015-07-10 12:30:00	MSFT	Stock	44.955	44.98	44.875	44.93	1283956.0
2015-07-10 13:00:00	MSFT	Stock	44.93	44.96	44.79	44.84	1441397.0
2015-07-10 13:30:00	MSFT	Stock	44.83	44.84	44.67	44.746	1093120.0
2015-07-10 14:00:00	MSFT	Stock	44.75	44.84	44.72	44.74	1166781.0

> showing 50 of 82,446 rows — these rows as CSV

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