PREVIEW / stock_30min / 2019-06-03

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-03.parquet
  size:    1.7 MB
  rows:    85,233
  symbols: 2,601

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
2019-06-03 04:00:00	AAPL	Stock	43.425	43.425	43.35	43.4125	22284.0
2019-06-03 04:30:00	AAPL	Stock	43.4	43.55	43.375	43.525	71288.0
2019-06-03 05:00:00	AAPL	Stock	43.5525	43.585	43.55	43.55	24580.0
2019-06-03 05:30:00	AAPL	Stock	43.56	43.6625	43.56	43.655	12760.0
2019-06-03 06:00:00	AAPL	Stock	43.655	43.6975	43.625	43.625	16536.0
2019-06-03 06:30:00	AAPL	Stock	43.6225	43.6625	43.5825	43.625	34688.0
2019-06-03 07:00:00	AAPL	Stock	43.65	43.87	43.65	43.87	57800.0
2019-06-03 07:30:00	AAPL	Stock	43.8725	43.8875	43.7725	43.775	43516.0
2019-06-03 08:00:00	AAPL	Stock	43.8875	43.9225	43.61	43.9125	141572.0
2019-06-03 08:30:00	AAPL	Stock	43.885	44.08	43.875	44.08	212688.0
2019-06-03 09:00:00	AAPL	Stock	44.08	44.095	43.86	43.895	340036.0
2019-06-03 09:30:00	AAPL	Stock	43.895	44.48	43.86	44.255	16473528.0
2019-06-03 10:00:00	AAPL	Stock	44.25	44.32	43.9665	44.1475	9816268.0
2019-06-03 10:30:00	AAPL	Stock	44.1575	44.3175	44.0	44.3	6245788.0
2019-06-03 11:00:00	AAPL	Stock	44.2975	44.365	44.1775	44.31	4943352.0
2019-06-03 11:30:00	AAPL	Stock	44.31	44.3575	44.105	44.1618	4019488.0
2019-06-03 12:00:00	AAPL	Stock	44.16	44.1975	43.795	43.875	4987092.0
2019-06-03 12:30:00	AAPL	Stock	43.8775	44.065	43.8	43.9125	4831728.0
2019-06-03 13:00:00	AAPL	Stock	43.915	44.2888	43.05	43.4762	12372040.0
2019-06-03 13:30:00	AAPL	Stock	43.4725	43.475	42.5675	43.3825	25210964.0
2019-06-03 14:00:00	AAPL	Stock	43.385	43.55	43.2325	43.275	8126696.0
2019-06-03 14:30:00	AAPL	Stock	43.2738	43.375	42.985	43.0775	6724180.0
2019-06-03 15:00:00	AAPL	Stock	43.075	43.27	42.9175	42.9725	8762416.0
2019-06-03 15:30:00	AAPL	Stock	42.97	43.4225	42.8675	43.32	15268576.0
2019-06-03 16:00:00	AAPL	Stock	43.325	43.375	43.25	43.325	10212356.0
2019-06-03 16:30:00	AAPL	Stock	43.375	43.415	43.325	43.4125	524524.0
2019-06-03 17:00:00	AAPL	Stock	43.425	43.5	43.425	43.4822	49452.0
2019-06-03 17:30:00	AAPL	Stock	43.4025	43.455	43.335	43.38	10008.0
2019-06-03 18:00:00	AAPL	Stock	43.475	43.49	43.325	43.4375	22712.0
2019-06-03 18:30:00	AAPL	Stock	43.4	43.4875	43.3775	43.4775	10628.0
2019-06-03 19:00:00	AAPL	Stock	43.475	43.5	43.4525	43.5	17460.0
2019-06-03 19:30:00	AAPL	Stock	43.5	43.54	43.47	43.525	37996.0
2019-06-03 04:00:00	MSFT	Stock	122.15	122.68	122.15	122.68	2800.0
2019-06-03 04:30:00	MSFT	Stock	122.71	122.88	122.59	122.85	625.0
2019-06-03 05:00:00	MSFT	Stock	122.9	123.05	122.8	123.05	750.0
2019-06-03 05:30:00	MSFT	Stock	122.96	123.08	122.96	123.08	300.0
2019-06-03 06:00:00	MSFT	Stock	123.0	123.22	123.0	123.11	1583.0
2019-06-03 06:30:00	MSFT	Stock	123.04	123.22	123.04	123.17	1912.0
2019-06-03 07:00:00	MSFT	Stock	123.11	123.55	123.11	123.53	3064.0
2019-06-03 07:30:00	MSFT	Stock	123.53	123.55	123.3	123.3	2675.0
2019-06-03 08:00:00	MSFT	Stock	123.35	123.549	123.12	123.33	33358.0
2019-06-03 08:30:00	MSFT	Stock	123.33	123.55	123.33	123.5	11118.0
2019-06-03 09:00:00	MSFT	Stock	123.543	123.9	123.418	123.9	20186.0
2019-06-03 09:30:00	MSFT	Stock	123.85	124.37	121.9	121.933	3460440.0
2019-06-03 10:00:00	MSFT	Stock	121.92	122.62	121.47	122.605	2163590.0
2019-06-03 10:30:00	MSFT	Stock	122.605	122.86	122.33	122.81	1625231.0
2019-06-03 11:00:00	MSFT	Stock	122.8	122.93	122.33	122.7	1316508.0
2019-06-03 11:30:00	MSFT	Stock	122.69	122.73	121.93	122.075	1232616.0
2019-06-03 12:00:00	MSFT	Stock	122.07	122.19	121.07	121.2	1795095.0
2019-06-03 12:30:00	MSFT	Stock	121.2	121.43	120.97	121.025	1774883.0

> showing 50 of 85,233 rows — these rows as CSV

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