PREVIEW / stock_30min / 2023-08-08

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-08.parquet
  size:    2.1 MB
  rows:    101,634
  symbols: 1,478

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
2023-08-08 04:00:00	AAPL	Stock	178.78	178.78	178.25	178.44	13293.0
2023-08-08 04:30:00	AAPL	Stock	178.42	178.7	178.42	178.7	10304.0
2023-08-08 05:00:00	AAPL	Stock	178.73	178.78	178.48	178.65	24821.0
2023-08-08 05:30:00	AAPL	Stock	178.73	179.19	178.73	179.19	10224.0
2023-08-08 06:00:00	AAPL	Stock	179.18	179.5	179.17	179.32	12644.0
2023-08-08 06:30:00	AAPL	Stock	179.31	179.31	179.1	179.2	11890.0
2023-08-08 07:00:00	AAPL	Stock	179.25	179.26	178.52	178.52	45398.0
2023-08-08 07:30:00	AAPL	Stock	178.5	178.64	178.29	178.64	24701.0
2023-08-08 08:00:00	AAPL	Stock	179.17	179.47	178.16	179.0601	241318.0
2023-08-08 08:30:00	AAPL	Stock	179.1399	179.44	178.91	179.02	156000.0
2023-08-08 09:00:00	AAPL	Stock	179.02	179.84	178.9	179.7	230803.0
2023-08-08 09:30:00	AAPL	Stock	179.7	179.76	177.58	178.05	9110101.0
2023-08-08 10:00:00	AAPL	Stock	178.045	179.2082	177.76	179.19	6350255.0
2023-08-08 10:30:00	AAPL	Stock	179.19	179.22	178.1	178.13	3560743.0
2023-08-08 11:00:00	AAPL	Stock	178.13	178.3482	177.935	178.04	3069574.0
2023-08-08 11:30:00	AAPL	Stock	178.04	178.26	177.825	177.865	2505779.0
2023-08-08 12:00:00	AAPL	Stock	177.8678	178.805	177.84	178.69	2339934.0
2023-08-08 12:30:00	AAPL	Stock	178.68	178.99	178.58	178.91	1636878.0
2023-08-08 13:00:00	AAPL	Stock	178.919	179.48	178.88	178.8933	3214587.0
2023-08-08 13:30:00	AAPL	Stock	178.89	179.2	178.7	179.045	1923685.0
2023-08-08 14:00:00	AAPL	Stock	179.05	179.42	178.91	179.16	1909477.0
2023-08-08 14:30:00	AAPL	Stock	179.17	179.55	179.04	179.485	1932834.0
2023-08-08 15:00:00	AAPL	Stock	179.49	179.94	179.34	179.81	3227266.0
2023-08-08 15:30:00	AAPL	Stock	179.815	180.27	179.555	179.8	7006762.0
2023-08-08 16:00:00	AAPL	Stock	179.8	179.94	179.7	179.75	5742064.0
2023-08-08 16:30:00	AAPL	Stock	179.75	179.8	179.6	179.76	76223.0
2023-08-08 17:00:00	AAPL	Stock	179.75	179.77	179.62	179.68	20534.0
2023-08-08 17:30:00	AAPL	Stock	179.7	179.75	179.63	179.73	8156.0
2023-08-08 18:00:00	AAPL	Stock	179.75	179.9	179.74	179.85	13349.0
2023-08-08 18:30:00	AAPL	Stock	179.81	179.87	179.78	179.85	17017.0
2023-08-08 19:00:00	AAPL	Stock	179.84	179.84	179.75	179.79	6904.0
2023-08-08 19:30:00	AAPL	Stock	179.8	179.91	179.56	179.79	32000.0
2023-08-08 04:00:00	MSFT	Stock	330.0	330.0	329.29	329.29	3564.0
2023-08-08 05:00:00	MSFT	Stock	329.27	329.27	329.01	329.01	443.0
2023-08-08 05:30:00	MSFT	Stock	328.96	328.96	328.96	328.96	100.0
2023-08-08 06:00:00	MSFT	Stock	328.97	329.92	328.95	329.13	2743.0
2023-08-08 06:30:00	MSFT	Stock	328.83	329.32	328.83	329.3	2327.0
2023-08-08 07:00:00	MSFT	Stock	329.0	329.09	327.18	327.18	15621.0
2023-08-08 07:30:00	MSFT	Stock	327.14	327.5	326.5	327.5	15487.0
2023-08-08 08:00:00	MSFT	Stock	328.75	329.69	326.43	327.0	19520.0
2023-08-08 08:30:00	MSFT	Stock	327.27	327.95	327.0	327.6	6418.0
2023-08-08 09:00:00	MSFT	Stock	327.5	327.71	326.8	327.01	18811.0
2023-08-08 09:30:00	MSFT	Stock	327.16	328.75	325.54	325.78	1806182.0
2023-08-08 10:00:00	MSFT	Stock	325.74	326.2885	323.62	324.7	1728504.0
2023-08-08 10:30:00	MSFT	Stock	324.69	325.13	323.08	323.32	1233282.0
2023-08-08 11:00:00	MSFT	Stock	323.335	324.64	323.0	324.53	1085120.0
2023-08-08 11:30:00	MSFT	Stock	324.52	324.62	323.25	323.31	914228.0
2023-08-08 12:00:00	MSFT	Stock	323.3	324.54	323.19	323.99	778969.0
2023-08-08 12:30:00	MSFT	Stock	324.02	324.61	323.79	324.13	588812.0
2023-08-08 13:00:00	MSFT	Stock	324.17	324.9	323.95	324.47	653000.0

> showing 50 of 101,634 rows — these rows as CSV

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