PREVIEW / stock_30min / 2019-04-08

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-08.parquet
  size:    1.7 MB
  rows:    83,913
  symbols: 2,651

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-04-08 04:00:00	AAPL	Stock	49.0875	49.0875	49.0675	49.0875	3380.0
2019-04-08 04:30:00	AAPL	Stock	49.075	49.15	49.0675	49.15	2640.0
2019-04-08 05:00:00	AAPL	Stock	49.15	49.15	49.15	49.15	400.0
2019-04-08 05:30:00	AAPL	Stock	49.1625	49.18	49.075	49.075	6800.0
2019-04-08 06:00:00	AAPL	Stock	49.095	49.125	49.095	49.1	6872.0
2019-04-08 06:30:00	AAPL	Stock	49.13	49.13	49.1	49.1	5200.0
2019-04-08 07:00:00	AAPL	Stock	49.16	49.16	49.05	49.0725	19084.0
2019-04-08 07:30:00	AAPL	Stock	49.0775	49.1275	49.075	49.1275	23696.0
2019-04-08 08:00:00	AAPL	Stock	49.145	49.3725	49.0325	49.0325	79832.0
2019-04-08 08:30:00	AAPL	Stock	49.04	49.0875	49.0375	49.0475	60216.0
2019-04-08 09:00:00	AAPL	Stock	49.045	49.1325	49.0325	49.13	77856.0
2019-04-08 09:30:00	AAPL	Stock	49.105	49.4768	49.085	49.4475	12223444.0
2019-04-08 10:00:00	AAPL	Stock	49.4475	49.4475	49.2975	49.395	5751136.0
2019-04-08 10:30:00	AAPL	Stock	49.3972	49.6875	49.3775	49.675	8417116.0
2019-04-08 11:00:00	AAPL	Stock	49.675	49.8425	49.6675	49.7775	10143136.0
2019-04-08 11:30:00	AAPL	Stock	49.775	49.875	49.7525	49.7925	6013052.0
2019-04-08 12:00:00	AAPL	Stock	49.795	49.8125	49.6525	49.7	5376336.0
2019-04-08 12:30:00	AAPL	Stock	49.7	49.8225	49.675	49.7925	3793560.0
2019-04-08 13:00:00	AAPL	Stock	49.795	49.85	49.7575	49.84	2891792.0
2019-04-08 13:30:00	AAPL	Stock	49.8415	49.945	49.815	49.9425	3721632.0
2019-04-08 14:00:00	AAPL	Stock	49.945	49.99	49.9172	49.975	3984044.0
2019-04-08 14:30:00	AAPL	Stock	49.975	49.9812	49.89	49.9675	3321804.0
2019-04-08 15:00:00	AAPL	Stock	49.9675	50.0	49.965	49.975	4873160.0
2019-04-08 15:30:00	AAPL	Stock	49.975	50.0575	49.9525	50.02	13534864.0
2019-04-08 16:00:00	AAPL	Stock	50.025	50.0875	50.025	50.0875	7388324.0
2019-04-08 16:30:00	AAPL	Stock	50.11	50.1125	50.0675	50.1	67088.0
2019-04-08 17:00:00	AAPL	Stock	50.1	50.125	50.0975	50.1	42172.0
2019-04-08 17:30:00	AAPL	Stock	50.1125	50.1125	50.09	50.105	27712.0
2019-04-08 18:00:00	AAPL	Stock	50.105	50.1625	50.1025	50.125	60872.0
2019-04-08 18:30:00	AAPL	Stock	50.125	50.1625	50.12	50.14	26116.0
2019-04-08 19:00:00	AAPL	Stock	50.15	50.15	50.125	50.1375	17124.0
2019-04-08 19:30:00	AAPL	Stock	50.1475	50.1575	50.1125	50.145	41536.0
2019-04-08 04:00:00	MSFT	Stock	119.97	120.13	119.86	119.86	700.0
2019-04-08 05:00:00	MSFT	Stock	119.97	120.0	119.96	119.96	600.0
2019-04-08 05:30:00	MSFT	Stock	119.95	119.95	119.95	119.95	602.0
2019-04-08 06:00:00	MSFT	Stock	119.9	120.3	119.87	120.3	753.0
2019-04-08 06:30:00	MSFT	Stock	120.01	120.01	120.01	120.01	200.0
2019-04-08 07:00:00	MSFT	Stock	120.1	120.1	119.75	119.83	2682.0
2019-04-08 07:30:00	MSFT	Stock	119.98	120.0	119.98	120.0	1674.0
2019-04-08 08:00:00	MSFT	Stock	120.0	120.0	119.71	119.76	18112.0
2019-04-08 08:30:00	MSFT	Stock	119.73	119.88	119.65	119.72	8935.0
2019-04-08 09:00:00	MSFT	Stock	119.658	119.85	119.63	119.63	8887.0
2019-04-08 09:30:00	MSFT	Stock	119.85	119.955	118.64	119.085	2162446.0
2019-04-08 10:00:00	MSFT	Stock	119.08	119.59	118.93	119.41	1061175.0
2019-04-08 10:30:00	MSFT	Stock	119.41	119.71	119.35	119.45	1003940.0
2019-04-08 11:00:00	MSFT	Stock	119.45	119.74	119.39	119.66	885564.0
2019-04-08 11:30:00	MSFT	Stock	119.66	119.74	119.51	119.556	634605.0
2019-04-08 12:00:00	MSFT	Stock	119.56	119.64	119.405	119.579	615476.0
2019-04-08 12:30:00	MSFT	Stock	119.575	119.71	119.555	119.7	468290.0
2019-04-08 13:00:00	MSFT	Stock	119.7	119.82	119.655	119.795	359616.0

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

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