PREVIEW / stock_30min / 2021-03-29

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-29.parquet
  size:    2.2 MB
  rows:    113,445
  symbols: 2,938

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
2021-03-29 04:00:00	AAPL	Stock	120.69	120.72	120.21	120.4	14888.0
2021-03-29 04:30:00	AAPL	Stock	120.4	120.53	120.36	120.5	3905.0
2021-03-29 05:00:00	AAPL	Stock	120.5	120.6	120.43	120.6	4450.0
2021-03-29 05:30:00	AAPL	Stock	120.55	120.88	120.52	120.88	5872.0
2021-03-29 06:00:00	AAPL	Stock	120.81	120.81	120.74	120.74	426.0
2021-03-29 06:30:00	AAPL	Stock	120.8	120.96	120.8	120.85	6609.0
2021-03-29 07:00:00	AAPL	Stock	120.86	121.44	120.84	121.07	60328.0
2021-03-29 07:30:00	AAPL	Stock	121.03	121.12	120.96	121.05	37371.0
2021-03-29 08:00:00	AAPL	Stock	121.0999	122.0	120.8	121.66	365907.0
2021-03-29 08:30:00	AAPL	Stock	121.71	121.71	121.029	121.13	134811.0
2021-03-29 09:00:00	AAPL	Stock	121.15	121.75	121.0	121.67	246889.0
2021-03-29 09:30:00	AAPL	Stock	121.65	122.58	121.21	121.3299	10914630.0
2021-03-29 10:00:00	AAPL	Stock	121.33	121.45	120.81	121.1899	6777884.0
2021-03-29 10:30:00	AAPL	Stock	121.18	122.09	121.11	121.6	5109218.0
2021-03-29 11:00:00	AAPL	Stock	121.6	121.6093	120.935	121.215	4594635.0
2021-03-29 11:30:00	AAPL	Stock	121.22	121.365	121.02	121.195	3033502.0
2021-03-29 12:00:00	AAPL	Stock	121.1983	121.23	120.7299	120.9117	3463084.0
2021-03-29 12:30:00	AAPL	Stock	120.919	121.39	120.845	121.3615	3491130.0
2021-03-29 13:00:00	AAPL	Stock	121.37	121.86	121.37	121.5947	3870257.0
2021-03-29 13:30:00	AAPL	Stock	121.6	121.98	121.545	121.65	2996113.0
2021-03-29 14:00:00	AAPL	Stock	121.655	121.69	121.315	121.405	3089163.0
2021-03-29 14:30:00	AAPL	Stock	121.4	121.455	121.02	121.17	3005121.0
2021-03-29 15:00:00	AAPL	Stock	121.18	121.73	121.18	121.66	3814300.0
2021-03-29 15:30:00	AAPL	Stock	121.67	121.7	120.97	121.4	6964567.0
2021-03-29 16:00:00	AAPL	Stock	121.39	121.4	120.95	121.35	6780199.0
2021-03-29 16:30:00	AAPL	Stock	121.31	121.4	121.3	121.32	23842.0
2021-03-29 17:00:00	AAPL	Stock	121.31	121.32	121.27	121.32	11262.0
2021-03-29 17:30:00	AAPL	Stock	121.3	121.32	121.28	121.32	9617.0
2021-03-29 18:00:00	AAPL	Stock	121.32	121.45	121.32	121.45	33075.0
2021-03-29 18:30:00	AAPL	Stock	121.43	121.43	121.33	121.35	10461.0
2021-03-29 19:00:00	AAPL	Stock	121.37	121.42	121.3	121.37	11676.0
2021-03-29 19:30:00	AAPL	Stock	121.33	121.44	121.25	121.35	26729.0
2021-03-29 04:00:00	MSFT	Stock	235.96	235.96	235.66	235.66	531.0
2021-03-29 04:30:00	MSFT	Stock	234.95	234.95	234.95	234.95	392.0
2021-03-29 05:00:00	MSFT	Stock	234.9	235.6	234.9	235.6	1205.0
2021-03-29 05:30:00	MSFT	Stock	235.7	235.8	235.7	235.8	1053.0
2021-03-29 06:00:00	MSFT	Stock	235.8	235.8	235.6	235.6	496.0
2021-03-29 06:30:00	MSFT	Stock	235.89	235.94	235.83	235.94	1340.0
2021-03-29 07:00:00	MSFT	Stock	236.4	236.5	235.72	236.5	4461.0
2021-03-29 07:30:00	MSFT	Stock	236.31	236.4	236.14	236.25	6774.0
2021-03-29 08:00:00	MSFT	Stock	235.95	236.5373	235.75	235.75	11651.0
2021-03-29 08:30:00	MSFT	Stock	235.81	235.81	235.0	235.1	8950.0
2021-03-29 09:00:00	MSFT	Stock	235.1	237.0	235.0	236.96	27851.0
2021-03-29 09:30:00	MSFT	Stock	236.94	236.94	232.98	233.1	2362665.0
2021-03-29 10:00:00	MSFT	Stock	233.1	233.1	231.88	232.07	1711193.0
2021-03-29 10:30:00	MSFT	Stock	232.06	233.975	231.98	233.56	1061314.0
2021-03-29 11:00:00	MSFT	Stock	233.58	233.85	232.95	233.6901	878545.0
2021-03-29 11:30:00	MSFT	Stock	233.7	234.0	233.3	233.6	706215.0
2021-03-29 12:00:00	MSFT	Stock	233.6	233.79	233.02	233.53	536661.0
2021-03-29 12:30:00	MSFT	Stock	233.54	234.96	233.49	234.9305	1014743.0

> showing 50 of 113,445 rows — these rows as CSV

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