PREVIEW / stock_30min / 2022-03-17

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-03-17.parquet
  size:    2.2 MB
  rows:    108,543
  symbols: 2,480

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-03-17 04:00:00	AAPL	Stock	159.83	160.1	159.35	159.7	20886.0
2022-03-17 04:30:00	AAPL	Stock	159.6	159.69	159.26	159.36	12902.0
2022-03-17 05:00:00	AAPL	Stock	159.31	159.31	158.91	159.15	12013.0
2022-03-17 05:30:00	AAPL	Stock	159.15	159.2	158.85	159.2	10475.0
2022-03-17 06:00:00	AAPL	Stock	159.2	159.2	158.23	158.73	17769.0
2022-03-17 06:30:00	AAPL	Stock	158.8	159.2	158.8	159.19	10694.0
2022-03-17 07:00:00	AAPL	Stock	159.23	159.24	158.61	158.8	38578.0
2022-03-17 07:30:00	AAPL	Stock	158.66	158.98	158.5	158.89	26449.0
2022-03-17 08:00:00	AAPL	Stock	159.0301	160.0	158.52	158.64	280169.0
2022-03-17 08:30:00	AAPL	Stock	158.64	158.9	158.21	158.44	223168.0
2022-03-17 09:00:00	AAPL	Stock	158.43	158.8	158.36	158.55	88760.0
2022-03-17 09:30:00	AAPL	Stock	158.55	159.54	157.73	159.4999	7892250.0
2022-03-17 10:00:00	AAPL	Stock	159.49	159.92	158.6501	158.7101	4929506.0
2022-03-17 10:30:00	AAPL	Stock	158.71	158.85	157.73	158.02	4279808.0
2022-03-17 11:00:00	AAPL	Stock	158.0	158.77	157.63	158.5	3220869.0
2022-03-17 11:30:00	AAPL	Stock	158.49	158.84	157.93	158.58	3307801.0
2022-03-17 12:00:00	AAPL	Stock	158.6	159.3	158.33	159.1379	3115152.0
2022-03-17 12:30:00	AAPL	Stock	159.13	159.26	158.88	159.04	2827411.0
2022-03-17 13:00:00	AAPL	Stock	159.03	159.915	158.52	159.91	3505971.0
2022-03-17 13:30:00	AAPL	Stock	159.92	160.25	159.67	160.0	3484090.0
2022-03-17 14:00:00	AAPL	Stock	160.01	160.13	159.265	159.3399	3096399.0
2022-03-17 14:30:00	AAPL	Stock	159.34	159.99	159.34	159.901	2778930.0
2022-03-17 15:00:00	AAPL	Stock	159.915	160.065	159.3257	159.775	3454854.0
2022-03-17 15:30:00	AAPL	Stock	159.76	161.0	159.7	160.99	8425957.0
2022-03-17 16:00:00	AAPL	Stock	160.99	160.99	159.95	160.12	9898786.0
2022-03-17 16:30:00	AAPL	Stock	160.01	160.62	159.7	159.93	94817.0
2022-03-17 17:00:00	AAPL	Stock	159.9201	160.19	159.85	160.0	24131.0
2022-03-17 17:30:00	AAPL	Stock	160.0	160.0	159.92	160.0	10264.0
2022-03-17 18:00:00	AAPL	Stock	160.0	160.07	159.79	159.85	27364.0
2022-03-17 18:30:00	AAPL	Stock	159.86	159.9	159.6	159.8	31176.0
2022-03-17 19:00:00	AAPL	Stock	159.79	159.99	159.7	159.75	16169.0
2022-03-17 19:30:00	AAPL	Stock	159.78	159.85	159.72	159.81	16487.0
2022-03-17 04:00:00	MSFT	Stock	295.7	295.7	294.01	295.1	2770.0
2022-03-17 04:30:00	MSFT	Stock	294.0	294.39	293.58	293.75	2154.0
2022-03-17 05:00:00	MSFT	Stock	293.99	293.99	293.35	293.89	3046.0
2022-03-17 05:30:00	MSFT	Stock	293.84	294.31	293.37	294.31	3574.0
2022-03-17 06:00:00	MSFT	Stock	294.0	294.0	291.81	293.0	3504.0
2022-03-17 06:30:00	MSFT	Stock	293.84	294.29	293.43	294.29	555.0
2022-03-17 07:00:00	MSFT	Stock	293.57	294.14	293.2	293.27	4129.0
2022-03-17 07:30:00	MSFT	Stock	293.48	293.7	293.1	293.59	9846.0
2022-03-17 08:00:00	MSFT	Stock	293.6	295.75	293.1	293.4	18440.0
2022-03-17 08:30:00	MSFT	Stock	293.3037	293.78	292.07	292.32	13422.0
2022-03-17 09:00:00	MSFT	Stock	292.4	293.27	292.33	293.25	7309.0
2022-03-17 09:30:00	MSFT	Stock	293.41	293.88	291.32	293.44	1950882.0
2022-03-17 10:00:00	MSFT	Stock	293.4499	294.51	292.35	292.5919	1573050.0
2022-03-17 10:30:00	MSFT	Stock	292.65	293.14	290.0	291.07	1483179.0
2022-03-17 11:00:00	MSFT	Stock	291.04	291.52	290.13	290.96	904403.0
2022-03-17 11:30:00	MSFT	Stock	290.96	291.4	289.37	290.731	913450.0
2022-03-17 12:00:00	MSFT	Stock	290.76	291.79	290.36	291.54	938779.0
2022-03-17 12:30:00	MSFT	Stock	291.53	292.235	291.13	291.9692	877705.0

> showing 50 of 108,543 rows — these rows as CSV

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