PREVIEW / stock_30min / 2017-03-22

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-22.parquet
  size:    1.6 MB
  rows:    81,913
  symbols: 3,076

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-03-22 04:00:00	AAPL	Stock	34.8125	34.8125	34.6875	34.75	11372.0
2017-03-22 04:30:00	AAPL	Stock	34.725	34.735	34.685	34.735	5840.0
2017-03-22 05:00:00	AAPL	Stock	34.6775	34.7475	34.6675	34.725	13276.0
2017-03-22 05:30:00	AAPL	Stock	34.7	34.775	34.67	34.775	12432.0
2017-03-22 06:00:00	AAPL	Stock	34.76	34.7725	34.73	34.73	19320.0
2017-03-22 06:30:00	AAPL	Stock	34.7575	34.7625	34.715	34.75	20940.0
2017-03-22 07:00:00	AAPL	Stock	34.775	34.825	34.755	34.8125	79176.0
2017-03-22 07:30:00	AAPL	Stock	34.8125	34.875	34.8	34.85	186700.0
2017-03-22 08:00:00	AAPL	Stock	34.85	34.875	34.73	34.8575	186636.0
2017-03-22 08:30:00	AAPL	Stock	34.8575	34.8975	34.855	34.8775	154524.0
2017-03-22 09:00:00	AAPL	Stock	34.895	34.9925	34.875	34.9625	278048.0
2017-03-22 09:30:00	AAPL	Stock	34.9612	35.25	34.94	35.1025	18577812.0
2017-03-22 10:00:00	AAPL	Stock	35.11	35.195	35.0288	35.0728	9663724.0
2017-03-22 10:30:00	AAPL	Stock	35.0745	35.2	34.99	35.1975	7517604.0
2017-03-22 11:00:00	AAPL	Stock	35.197	35.3425	35.1675	35.341	9405960.0
2017-03-22 11:30:00	AAPL	Stock	35.3425	35.3472	35.2775	35.28	4303160.0
2017-03-22 12:00:00	AAPL	Stock	35.2812	35.2968	35.2025	35.2425	3817888.0
2017-03-22 12:30:00	AAPL	Stock	35.2412	35.3075	35.2025	35.2475	4235660.0
2017-03-22 13:00:00	AAPL	Stock	35.245	35.26	35.1575	35.19	3996728.0
2017-03-22 13:30:00	AAPL	Stock	35.1902	35.285	35.1838	35.2175	4081972.0
2017-03-22 14:00:00	AAPL	Stock	35.22	35.285	35.22	35.2362	3391604.0
2017-03-22 14:30:00	AAPL	Stock	35.2375	35.305	35.2075	35.295	3200060.0
2017-03-22 15:00:00	AAPL	Stock	35.2942	35.335	35.27	35.28	3725292.0
2017-03-22 15:30:00	AAPL	Stock	35.2778	35.4	35.275	35.3575	10537316.0
2017-03-22 16:00:00	AAPL	Stock	35.355	35.36	35.2188	35.3125	7844252.0
2017-03-22 16:30:00	AAPL	Stock	35.325	35.355	35.3	35.3125	33660.0
2017-03-22 17:00:00	AAPL	Stock	35.3	35.3125	35.295	35.295	34320.0
2017-03-22 17:30:00	AAPL	Stock	35.3	35.3125	35.2925	35.3125	30212.0
2017-03-22 18:00:00	AAPL	Stock	35.325	35.35	35.3175	35.325	21180.0
2017-03-22 18:30:00	AAPL	Stock	35.3325	35.35	35.3325	35.3475	10564.0
2017-03-22 19:00:00	AAPL	Stock	35.3475	35.36	35.3425	35.3575	6256.0
2017-03-22 19:30:00	AAPL	Stock	35.3625	35.375	35.3625	35.375	31756.0
2017-03-22 04:00:00	MSFT	Stock	64.05	64.05	64.05	64.05	110.0
2017-03-22 07:00:00	MSFT	Stock	64.06	64.1	64.06	64.1	1651.0
2017-03-22 07:30:00	MSFT	Stock	64.06	64.06	64.06	64.06	800.0
2017-03-22 08:00:00	MSFT	Stock	64.06	64.2	64.05	64.1	815.0
2017-03-22 08:30:00	MSFT	Stock	64.14	64.2	64.05	64.1	9152.0
2017-03-22 09:00:00	MSFT	Stock	64.13	64.3	64.06	64.25	26422.0
2017-03-22 09:30:00	MSFT	Stock	64.23	64.53	64.12	64.34	2250022.0
2017-03-22 10:00:00	MSFT	Stock	64.35	64.53	64.32	64.5	1262635.0
2017-03-22 10:30:00	MSFT	Stock	64.505	64.82	64.39	64.82	1434145.0
2017-03-22 11:00:00	MSFT	Stock	64.81	65.04	64.695	65.04	1390011.0
2017-03-22 11:30:00	MSFT	Stock	65.04	65.07	64.86	64.885	1106530.0
2017-03-22 12:00:00	MSFT	Stock	64.885	64.935	64.825	64.88	837675.0
2017-03-22 12:30:00	MSFT	Stock	64.885	64.94	64.815	64.92	864577.0
2017-03-22 13:00:00	MSFT	Stock	64.92	65.01	64.81	64.926	978067.0
2017-03-22 13:30:00	MSFT	Stock	64.92	65.03	64.89	64.89	668882.0
2017-03-22 14:00:00	MSFT	Stock	64.9	65.009	64.87	64.895	656367.0
2017-03-22 14:30:00	MSFT	Stock	64.9	65.098	64.89	65.06	940361.0
2017-03-22 15:00:00	MSFT	Stock	65.055	65.14	65.01	65.01	1018239.0

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

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