PREVIEW / stock_30min / 2020-01-13

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-13.parquet
  size:    1.8 MB
  rows:    87,985
  symbols: 2,468

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
2020-01-13 04:00:00	AAPL	Stock	77.8825	77.98	77.875	77.9375	22012.0
2020-01-13 04:30:00	AAPL	Stock	77.9	77.9875	77.9	77.975	32944.0
2020-01-13 05:00:00	AAPL	Stock	77.975	77.975	77.9175	77.9175	19524.0
2020-01-13 05:30:00	AAPL	Stock	77.92	78.0	77.9125	78.0	31436.0
2020-01-13 06:00:00	AAPL	Stock	77.9875	77.9975	77.9125	77.95	12744.0
2020-01-13 06:30:00	AAPL	Stock	77.95	78.125	77.9125	77.915	86868.0
2020-01-13 07:00:00	AAPL	Stock	77.925	78.0375	77.8825	77.8925	160436.0
2020-01-13 07:30:00	AAPL	Stock	77.915	77.97	77.8425	77.8875	130380.0
2020-01-13 08:00:00	AAPL	Stock	77.9875	78.0477	77.85	77.9375	365224.0
2020-01-13 08:30:00	AAPL	Stock	77.96	77.9625	77.85	77.853	233912.0
2020-01-13 09:00:00	AAPL	Stock	77.8525	78.0175	77.8375	77.9075	455808.0
2020-01-13 09:30:00	AAPL	Stock	77.925	78.345	77.9075	78.23	18642880.0
2020-01-13 10:00:00	AAPL	Stock	78.235	78.2575	77.935	77.9748	8896160.0
2020-01-13 10:30:00	AAPL	Stock	77.98	78.0425	77.7875	78.0208	6815280.0
2020-01-13 11:00:00	AAPL	Stock	78.0225	78.0975	77.85	78.055	5785860.0
2020-01-13 11:30:00	AAPL	Stock	78.05	78.34	78.0425	78.1975	6077104.0
2020-01-13 12:00:00	AAPL	Stock	78.195	78.2425	78.1125	78.1512	4143744.0
2020-01-13 12:30:00	AAPL	Stock	78.1475	78.33	78.1375	78.2825	5107540.0
2020-01-13 13:00:00	AAPL	Stock	78.2825	78.4375	78.215	78.4	4754696.0
2020-01-13 13:30:00	AAPL	Stock	78.4025	78.4475	78.35	78.405	3226540.0
2020-01-13 14:00:00	AAPL	Stock	78.3905	78.6875	78.3275	78.6575	6424752.0
2020-01-13 14:30:00	AAPL	Stock	78.66	78.745	78.59	78.7325	5662008.0
2020-01-13 15:00:00	AAPL	Stock	78.7325	78.815	78.6575	78.7875	5414732.0
2020-01-13 15:30:00	AAPL	Stock	78.79	79.2675	78.7825	79.2425	14186908.0
2020-01-13 16:00:00	AAPL	Stock	79.24	79.325	79.2375	79.31	7555404.0
2020-01-13 16:30:00	AAPL	Stock	79.3025	79.3725	79.24	79.315	187184.0
2020-01-13 17:00:00	AAPL	Stock	79.3125	79.335	79.24	79.305	74432.0
2020-01-13 17:30:00	AAPL	Stock	79.325	79.3975	79.3025	79.385	94820.0
2020-01-13 18:00:00	AAPL	Stock	79.375	79.4475	79.375	79.4375	50432.0
2020-01-13 18:30:00	AAPL	Stock	79.4025	79.5575	79.4025	79.5	101000.0
2020-01-13 19:00:00	AAPL	Stock	79.5375	79.5675	79.5075	79.5625	127132.0
2020-01-13 19:30:00	AAPL	Stock	79.5625	79.7	79.5625	79.695	225968.0
2020-01-13 04:00:00	MSFT	Stock	161.98	162.38	161.98	162.3	4313.0
2020-01-13 04:30:00	MSFT	Stock	162.3	162.5	162.16	162.5	7414.0
2020-01-13 05:00:00	MSFT	Stock	162.5	162.57	162.4	162.55	1799.0
2020-01-13 05:30:00	MSFT	Stock	162.44	162.47	162.37	162.37	2443.0
2020-01-13 06:00:00	MSFT	Stock	162.47	162.51	162.45	162.45	1171.0
2020-01-13 06:30:00	MSFT	Stock	162.39	162.47	162.15	162.2	2372.0
2020-01-13 07:00:00	MSFT	Stock	162.19	162.33	162.04	162.16	16953.0
2020-01-13 07:30:00	MSFT	Stock	162.23	162.23	162.05	162.2	4841.0
2020-01-13 08:00:00	MSFT	Stock	162.2	162.4	162.039	162.27	25782.0
2020-01-13 08:30:00	MSFT	Stock	162.35	162.35	162.2	162.27	10431.0
2020-01-13 09:00:00	MSFT	Stock	162.22	162.29	161.55	161.9	36849.0
2020-01-13 09:30:00	MSFT	Stock	161.89	162.3	161.49	161.93	2380991.0
2020-01-13 10:00:00	MSFT	Stock	161.93	162.015	161.43	161.5	1094031.0
2020-01-13 10:30:00	MSFT	Stock	161.5	161.62	161.26	161.54	950585.0
2020-01-13 11:00:00	MSFT	Stock	161.55	162.1	161.479	161.91	1191398.0
2020-01-13 11:30:00	MSFT	Stock	161.89	162.18	161.84	162.175	782948.0
2020-01-13 12:00:00	MSFT	Stock	162.19	162.48	162.15	162.432	839380.0
2020-01-13 12:30:00	MSFT	Stock	162.44	162.58	162.39	162.55	518046.0

> showing 50 of 87,985 rows — these rows as CSV

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