PREVIEW / stock_30min / 2022-01-25

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-25.parquet
  size:    2.2 MB
  rows:    110,688
  symbols: 2,645

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-01-25 04:00:00	AAPL	Stock	159.75	159.75	158.2	159.45	36150.0
2022-01-25 04:30:00	AAPL	Stock	159.5	160.37	159.29	160.0	23109.0
2022-01-25 05:00:00	AAPL	Stock	159.98	160.0	159.5	159.7	10741.0
2022-01-25 05:30:00	AAPL	Stock	159.8	159.8	158.6	158.99	21667.0
2022-01-25 06:00:00	AAPL	Stock	158.83	159.46	158.8	158.97	20773.0
2022-01-25 06:30:00	AAPL	Stock	158.97	158.97	157.84	158.6	27062.0
2022-01-25 07:00:00	AAPL	Stock	158.59	158.8	157.72	158.45	85506.0
2022-01-25 07:30:00	AAPL	Stock	158.4	158.6	157.85	158.27	71387.0
2022-01-25 08:00:00	AAPL	Stock	158.35	158.72	157.25	157.65	338817.0
2022-01-25 08:30:00	AAPL	Stock	157.66	158.86	157.51	158.61	268221.0
2022-01-25 09:00:00	AAPL	Stock	158.57	161.6976	158.27	158.93	284201.0
2022-01-25 09:30:00	AAPL	Stock	158.93	159.75	157.27	157.62	9730575.0
2022-01-25 10:00:00	AAPL	Stock	157.64	158.8399	157.02	158.81	6971857.0
2022-01-25 10:30:00	AAPL	Stock	158.8199	159.79	158.15	158.41	6080966.0
2022-01-25 11:00:00	AAPL	Stock	158.41	158.95	157.81	158.58	5033422.0
2022-01-25 11:30:00	AAPL	Stock	158.59	158.78	157.22	157.34	4743518.0
2022-01-25 12:00:00	AAPL	Stock	157.35	158.96	157.135	158.68	4689333.0
2022-01-25 12:30:00	AAPL	Stock	158.68	158.74	157.6199	158.35	3675557.0
2022-01-25 13:00:00	AAPL	Stock	158.36	159.48	157.92	159.3874	3701119.0
2022-01-25 13:30:00	AAPL	Stock	159.38	160.531	159.2511	160.4927	4548330.0
2022-01-25 14:00:00	AAPL	Stock	160.49	161.78	159.83	161.72	6504875.0
2022-01-25 14:30:00	AAPL	Stock	161.71	162.76	161.14	162.475	6543821.0
2022-01-25 15:00:00	AAPL	Stock	162.47	162.555	160.44	160.67	6047764.0
2022-01-25 15:30:00	AAPL	Stock	160.665	161.5	159.39	159.88	10164271.0
2022-01-25 16:00:00	AAPL	Stock	159.89	160.37	158.11	158.25	10702372.0
2022-01-25 16:30:00	AAPL	Stock	158.25	159.78	157.01	157.42	218642.0
2022-01-25 17:00:00	AAPL	Stock	157.49	157.6	157.3	157.45	62853.0
2022-01-25 17:30:00	AAPL	Stock	157.47	157.95	157.45	157.95	62302.0
2022-01-25 18:00:00	AAPL	Stock	157.98	160.1	157.98	160.0	332525.0
2022-01-25 18:30:00	AAPL	Stock	160.09	160.72	159.43	159.98	152090.0
2022-01-25 19:00:00	AAPL	Stock	160.0	160.36	159.51	159.78	92752.0
2022-01-25 19:30:00	AAPL	Stock	159.7	160.03	159.57	160.03	53527.0
2022-01-25 04:00:00	MSFT	Stock	292.6	294.72	291.89	294.72	30735.0
2022-01-25 04:30:00	MSFT	Stock	294.83	295.12	294.3	295.0	12107.0
2022-01-25 05:00:00	MSFT	Stock	295.1	295.82	295.0	295.34	3976.0
2022-01-25 05:30:00	MSFT	Stock	295.33	295.33	293.15	293.62	17057.0
2022-01-25 06:00:00	MSFT	Stock	293.6	294.2	293.43	294.0	8021.0
2022-01-25 06:30:00	MSFT	Stock	293.64	293.64	292.11	293.34	10072.0
2022-01-25 07:00:00	MSFT	Stock	293.51	294.45	292.36	293.75	25933.0
2022-01-25 07:30:00	MSFT	Stock	293.6	293.68	291.65	292.78	12424.0
2022-01-25 08:00:00	MSFT	Stock	292.72	293.9699	290.39	291.0	79700.0
2022-01-25 08:30:00	MSFT	Stock	290.77	292.63	290.6	292.5	30619.0
2022-01-25 09:00:00	MSFT	Stock	292.4	292.59	291.2	291.55	79762.0
2022-01-25 09:30:00	MSFT	Stock	291.38	293.73	286.8905	288.13	4771239.0
2022-01-25 10:00:00	MSFT	Stock	288.12	290.59	287.05	290.59	2922988.0
2022-01-25 10:30:00	MSFT	Stock	290.52	290.655	287.63	288.01	2528357.0
2022-01-25 11:00:00	MSFT	Stock	288.01	288.51	285.63	287.34	2812499.0
2022-01-25 11:30:00	MSFT	Stock	287.32	287.47	285.17	285.74	2671883.0
2022-01-25 12:00:00	MSFT	Stock	285.75	288.3	285.4	288.01	2111056.0
2022-01-25 12:30:00	MSFT	Stock	287.99	288.72	286.8101	288.32	1914910.0

> showing 50 of 110,688 rows — these rows as CSV

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