PREVIEW / stock_30min / 2017-07-25

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-25.parquet
  size:    1.6 MB
  rows:    83,555
  symbols: 3,008

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-25 04:30:00	AAPL	Stock	37.9825	37.9825	37.9725	37.9725	12548.0
2017-07-25 05:00:00	AAPL	Stock	38.0225	38.0225	38.0225	38.0225	8000.0
2017-07-25 05:30:00	AAPL	Stock	38.0375	38.0475	38.0375	38.0475	3508.0
2017-07-25 06:00:00	AAPL	Stock	38.0575	38.0575	38.0575	38.0575	1736.0
2017-07-25 07:00:00	AAPL	Stock	38.05	38.05	38.05	38.05	2812.0
2017-07-25 07:30:00	AAPL	Stock	38.06	38.1125	38.06	38.1	19872.0
2017-07-25 08:00:00	AAPL	Stock	38.095	38.15	38.055	38.1	99524.0
2017-07-25 08:30:00	AAPL	Stock	38.1	38.12	38.0	38.0	75192.0
2017-07-25 09:00:00	AAPL	Stock	38.0025	38.075	37.9375	38.06	263824.0
2017-07-25 09:30:00	AAPL	Stock	37.95	38.4238	37.95	38.4	15969376.0
2017-07-25 10:00:00	AAPL	Stock	38.4	38.4275	38.315	38.3685	5851828.0
2017-07-25 10:30:00	AAPL	Stock	38.3725	38.3748	38.2825	38.3262	3913804.0
2017-07-25 11:00:00	AAPL	Stock	38.3275	38.4025	38.31	38.3725	4017720.0
2017-07-25 11:30:00	AAPL	Stock	38.37	38.46	38.3462	38.42	4221460.0
2017-07-25 12:00:00	AAPL	Stock	38.419	38.4325	38.3188	38.3388	3579044.0
2017-07-25 12:30:00	AAPL	Stock	38.34	38.385	38.33	38.3522	1776672.0
2017-07-25 13:00:00	AAPL	Stock	38.35	38.3825	38.33	38.36	2167024.0
2017-07-25 13:30:00	AAPL	Stock	38.3575	38.36	38.2825	38.305	3206376.0
2017-07-25 14:00:00	AAPL	Stock	38.3025	38.3125	38.24	38.26	2909712.0
2017-07-25 14:30:00	AAPL	Stock	38.26	38.275	38.2175	38.27	2499680.0
2017-07-25 15:00:00	AAPL	Stock	38.27	38.2925	38.195	38.2625	2656816.0
2017-07-25 15:30:00	AAPL	Stock	38.26	38.26	38.1625	38.1875	7290704.0
2017-07-25 16:00:00	AAPL	Stock	38.1925	38.22	38.0925	38.21	6141396.0
2017-07-25 16:30:00	AAPL	Stock	38.205	38.225	38.185	38.215	63884.0
2017-07-25 17:00:00	AAPL	Stock	38.215	38.22	38.185	38.22	141360.0
2017-07-25 17:30:00	AAPL	Stock	38.225	38.225	38.225	38.225	7396.0
2017-07-25 18:00:00	AAPL	Stock	38.225	38.2375	38.22	38.225	19044.0
2017-07-25 18:30:00	AAPL	Stock	38.225	38.2375	38.215	38.215	8040.0
2017-07-25 19:00:00	AAPL	Stock	38.215	38.215	38.21	38.21	6164.0
2017-07-25 19:30:00	AAPL	Stock	38.2225	38.2225	38.2125	38.22	12520.0
2017-07-25 04:30:00	MSFT	Stock	73.48	73.58	73.48	73.58	1063.0
2017-07-25 06:00:00	MSFT	Stock	73.5	73.56	73.5	73.56	3500.0
2017-07-25 07:00:00	MSFT	Stock	73.6	73.6	73.6	73.6	100.0
2017-07-25 07:30:00	MSFT	Stock	73.6	73.6	73.6	73.6	7300.0
2017-07-25 08:00:00	MSFT	Stock	73.57	73.59	73.55	73.59	2959.0
2017-07-25 08:30:00	MSFT	Stock	73.58	73.58	73.45	73.49	10651.0
2017-07-25 09:00:00	MSFT	Stock	73.49	73.78	73.48	73.78	70217.0
2017-07-25 09:30:00	MSFT	Stock	73.8	74.01	73.5	73.96	2866710.0
2017-07-25 10:00:00	MSFT	Stock	73.95	73.98	73.68	73.815	1403349.0
2017-07-25 10:30:00	MSFT	Stock	73.815	73.825	73.63	73.76	835154.0
2017-07-25 11:00:00	MSFT	Stock	73.76	73.91	73.76	73.86	927691.0
2017-07-25 11:30:00	MSFT	Stock	73.85	73.93	73.82	73.89	895186.0
2017-07-25 12:00:00	MSFT	Stock	73.88	73.9	73.79	73.89	840805.0
2017-07-25 12:30:00	MSFT	Stock	73.89	74.01	73.88	73.985	771720.0
2017-07-25 13:00:00	MSFT	Stock	73.99	74.01	73.95	73.99	524265.0
2017-07-25 13:30:00	MSFT	Stock	74.0	74.14	73.99	74.14	702450.0
2017-07-25 14:00:00	MSFT	Stock	74.14	74.3	74.12	74.26	1169432.0
2017-07-25 14:30:00	MSFT	Stock	74.25	74.26	74.14	74.197	1117897.0
2017-07-25 15:00:00	MSFT	Stock	74.2	74.23	74.12	74.22	1142937.0
2017-07-25 15:30:00	MSFT	Stock	74.226	74.31	74.14	74.199	4462204.0

> showing 50 of 83,555 rows — these rows as CSV

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