PREVIEW / stock_30min / 2022-05-09

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-05-09.parquet
  size:    2.3 MB
  rows:    114,273
  symbols: 2,523

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
2022-05-09 04:00:00	AAPL	Stock	155.26	155.32	154.67	154.78	26082.0
2022-05-09 04:30:00	AAPL	Stock	154.72	154.72	154.14	154.43	48828.0
2022-05-09 05:00:00	AAPL	Stock	154.45	154.86	154.39	154.41	13723.0
2022-05-09 05:30:00	AAPL	Stock	154.48	154.53	153.99	154.29	40797.0
2022-05-09 06:00:00	AAPL	Stock	154.28	154.33	154.01	154.19	13726.0
2022-05-09 06:30:00	AAPL	Stock	154.1	154.1	153.16	153.4	37378.0
2022-05-09 07:00:00	AAPL	Stock	153.46	154.0	152.87	152.95	177788.0
2022-05-09 07:30:00	AAPL	Stock	152.95	153.93	152.78	153.72	151654.0
2022-05-09 08:00:00	AAPL	Stock	153.6989	155.7	152.78	153.4999	576166.0
2022-05-09 08:30:00	AAPL	Stock	153.4	154.65	153.16	154.0201	290586.0
2022-05-09 09:00:00	AAPL	Stock	154.0203	155.0	153.7	154.91	344776.0
2022-05-09 09:30:00	AAPL	Stock	154.87	155.83	153.38	153.57	12842269.0
2022-05-09 10:00:00	AAPL	Stock	153.58	154.08	153.07	153.21	7769885.0
2022-05-09 10:30:00	AAPL	Stock	153.2	154.53	152.78	152.85	8438221.0
2022-05-09 11:00:00	AAPL	Stock	152.85	153.17	152.0	152.2567	7904979.0
2022-05-09 11:30:00	AAPL	Stock	152.25	153.31	151.955	152.16	7533305.0
2022-05-09 12:00:00	AAPL	Stock	152.17	153.5	151.56	153.275	6916210.0
2022-05-09 12:30:00	AAPL	Stock	153.25	153.66	152.39	152.41	4510574.0
2022-05-09 13:00:00	AAPL	Stock	152.41	153.44	152.2599	153.332	4307057.0
2022-05-09 13:30:00	AAPL	Stock	153.325	153.54	152.1001	152.55	5030741.0
2022-05-09 14:00:00	AAPL	Stock	152.5483	152.94	152.06	152.19	4307503.0
2022-05-09 14:30:00	AAPL	Stock	152.18	153.2	151.81	153.09	5559484.0
2022-05-09 15:00:00	AAPL	Stock	153.08	153.61	152.13	152.38	6645682.0
2022-05-09 15:30:00	AAPL	Stock	152.37	152.64	151.49	152.15	13089262.0
2022-05-09 16:00:00	AAPL	Stock	152.15	152.93	152.06	152.25	11016992.0
2022-05-09 16:30:00	AAPL	Stock	152.25	152.3	151.85	152.04	82902.0
2022-05-09 17:00:00	AAPL	Stock	152.03	152.05	151.82	151.82	33092.0
2022-05-09 17:30:00	AAPL	Stock	151.83	152.06	151.72	151.95	156819.0
2022-05-09 18:00:00	AAPL	Stock	151.95	152.66	151.95	152.3	63629.0
2022-05-09 18:30:00	AAPL	Stock	152.3	152.67	152.3	152.54	20458.0
2022-05-09 19:00:00	AAPL	Stock	152.6	152.66	152.2	152.36	35110.0
2022-05-09 19:30:00	AAPL	Stock	152.36	152.75	152.3	152.75	52371.0
2022-05-09 04:00:00	MSFT	Stock	271.81	272.2	270.55	271.0	7499.0
2022-05-09 04:30:00	MSFT	Stock	270.3	270.74	269.82	270.74	4507.0
2022-05-09 05:00:00	MSFT	Stock	270.16	270.6	270.05	270.4	2246.0
2022-05-09 05:30:00	MSFT	Stock	270.33	270.36	269.57	269.63	8958.0
2022-05-09 06:00:00	MSFT	Stock	269.8	269.8	268.88	269.14	8294.0
2022-05-09 06:30:00	MSFT	Stock	269.14	269.14	267.09	267.8	31962.0
2022-05-09 07:00:00	MSFT	Stock	268.05	268.77	266.85	267.17	39412.0
2022-05-09 07:30:00	MSFT	Stock	267.17	268.72	267.17	268.7	17521.0
2022-05-09 08:00:00	MSFT	Stock	268.06	269.6812	266.8002	268.21	83446.0
2022-05-09 08:30:00	MSFT	Stock	268.35	269.8	267.7	268.77	49461.0
2022-05-09 09:00:00	MSFT	Stock	268.86	270.4	268.55	270.01	47876.0
2022-05-09 09:30:00	MSFT	Stock	270.01	272.36	267.58	268.26	4425100.0
2022-05-09 10:00:00	MSFT	Stock	268.27	268.65	266.0	266.14	2603683.0
2022-05-09 10:30:00	MSFT	Stock	266.14	266.83	264.55	265.9668	2275269.0
2022-05-09 11:00:00	MSFT	Stock	265.94	266.63	265.06	265.8	1663031.0
2022-05-09 11:30:00	MSFT	Stock	265.78	267.84	264.97	267.08	1655524.0
2022-05-09 12:00:00	MSFT	Stock	267.07	268.97	266.01	268.09	1498540.0
2022-05-09 12:30:00	MSFT	Stock	268.07	269.2	266.83	266.84	1325973.0

> showing 50 of 114,273 rows — these rows as CSV

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