PREVIEW / stock_30min / 2020-06-25

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-25.parquet
  size:    1.9 MB
  rows:    97,606
  symbols: 2,432

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-06-25 04:00:00	AAPL	Stock	89.3875	90.0375	89.35	89.9475	17848.0
2020-06-25 04:30:00	AAPL	Stock	89.8125	90.175	89.8125	90.175	3056.0
2020-06-25 05:00:00	AAPL	Stock	90.1675	90.3625	90.1275	90.3625	8068.0
2020-06-25 05:30:00	AAPL	Stock	90.4725	90.4725	90.0875	90.0875	4000.0
2020-06-25 06:00:00	AAPL	Stock	90.16	90.16	90.075	90.075	4696.0
2020-06-25 06:30:00	AAPL	Stock	90.25	90.6	90.15	90.53	21968.0
2020-06-25 07:00:00	AAPL	Stock	90.53	90.7	90.175	90.325	238744.0
2020-06-25 07:30:00	AAPL	Stock	90.3675	90.3925	89.9775	89.9775	105972.0
2020-06-25 08:00:00	AAPL	Stock	90.525	90.745	89.8775	90.18	386872.0
2020-06-25 08:30:00	AAPL	Stock	90.18	90.5	89.9618	90.475	452172.0
2020-06-25 09:00:00	AAPL	Stock	90.45	90.465	90.0425	90.1875	500268.0
2020-06-25 09:30:00	AAPL	Stock	90.185	90.845	89.3925	89.9102	18449408.0
2020-06-25 10:00:00	AAPL	Stock	89.9075	90.72	89.8625	90.6325	10848692.0
2020-06-25 10:30:00	AAPL	Stock	90.635	90.7175	90.04	90.3812	9152960.0
2020-06-25 11:00:00	AAPL	Stock	90.3775	90.4925	89.9	90.3925	7070860.0
2020-06-25 11:30:00	AAPL	Stock	90.4	90.4725	90.055	90.3358	5153312.0
2020-06-25 12:00:00	AAPL	Stock	90.3425	91.005	90.3425	90.715	9348648.0
2020-06-25 12:30:00	AAPL	Stock	90.715	90.8675	90.5425	90.6125	5564020.0
2020-06-25 13:00:00	AAPL	Stock	90.6125	90.665	90.31	90.5288	3888688.0
2020-06-25 13:30:00	AAPL	Stock	90.525	90.735	90.4038	90.49	3134936.0
2020-06-25 14:00:00	AAPL	Stock	90.4925	90.5125	90.1175	90.2775	4309224.0
2020-06-25 14:30:00	AAPL	Stock	90.2725	90.325	90.0	90.2652	6530872.0
2020-06-25 15:00:00	AAPL	Stock	90.255	90.8825	90.1675	90.795	8869716.0
2020-06-25 15:30:00	AAPL	Stock	90.795	91.25	90.6042	91.22	11917896.0
2020-06-25 16:00:00	AAPL	Stock	91.21	91.255	91.105	91.1625	6634308.0
2020-06-25 16:30:00	AAPL	Stock	91.1125	91.175	90.97	91.1275	97260.0
2020-06-25 17:00:00	AAPL	Stock	91.1375	91.2075	91.125	91.2	40536.0
2020-06-25 17:30:00	AAPL	Stock	91.175	91.1875	91.11	91.1125	14388.0
2020-06-25 18:00:00	AAPL	Stock	91.175	91.2475	91.1325	91.225	42952.0
2020-06-25 18:30:00	AAPL	Stock	91.2125	91.225	91.125	91.2125	38424.0
2020-06-25 19:00:00	AAPL	Stock	91.22	91.35	91.18	91.3375	49772.0
2020-06-25 19:30:00	AAPL	Stock	91.345	91.3475	91.225	91.3375	55640.0
2020-06-25 04:00:00	MSFT	Stock	196.5	197.85	196.5	197.85	3050.0
2020-06-25 04:30:00	MSFT	Stock	197.91	197.91	197.91	197.91	100.0
2020-06-25 05:00:00	MSFT	Stock	198.2	198.2	198.2	198.2	100.0
2020-06-25 05:30:00	MSFT	Stock	198.4	198.4	198.4	198.4	100.0
2020-06-25 06:00:00	MSFT	Stock	198.36	198.36	198.0	198.28	3149.0
2020-06-25 06:30:00	MSFT	Stock	198.27	198.36	198.0	198.35	3600.0
2020-06-25 07:00:00	MSFT	Stock	198.03	198.35	198.0	198.11	12821.0
2020-06-25 07:30:00	MSFT	Stock	198.13	198.13	197.5	197.51	8421.0
2020-06-25 08:00:00	MSFT	Stock	198.3	198.36	197.0	197.43	36727.0
2020-06-25 08:30:00	MSFT	Stock	197.44	198.0	197.11	197.8	31754.0
2020-06-25 09:00:00	MSFT	Stock	197.654	198.25	197.621	197.64	30382.0
2020-06-25 09:30:00	MSFT	Stock	197.79	199.03	195.468	196.926	3281657.0
2020-06-25 10:00:00	MSFT	Stock	196.88	197.934	196.61	197.73	1826046.0
2020-06-25 10:30:00	MSFT	Stock	197.74	198.16	197.0	197.495	1537624.0
2020-06-25 11:00:00	MSFT	Stock	197.45	198.06	196.54	197.834	1179570.0
2020-06-25 11:30:00	MSFT	Stock	197.82	197.91	196.79	197.87	1054226.0
2020-06-25 12:00:00	MSFT	Stock	197.9	198.82	197.86	198.455	1190057.0
2020-06-25 12:30:00	MSFT	Stock	198.46	198.75	198.08	198.15	896225.0

> showing 50 of 97,606 rows — these rows as CSV

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