PREVIEW / stock_30min / 2024-03-14

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-03-14.parquet
  size:    2.1 MB
  rows:    100,644
  symbols: 1,072

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
2024-03-14 04:00:00	AAPL	Stock	171.6	172.0	171.6	171.96	6966.0
2024-03-14 04:30:00	AAPL	Stock	171.83	172.14	171.81	172.14	5740.0
2024-03-14 05:00:00	AAPL	Stock	172.18	172.5	172.15	172.5	18362.0
2024-03-14 05:30:00	AAPL	Stock	172.47	172.53	172.43	172.45	9872.0
2024-03-14 06:00:00	AAPL	Stock	172.51	172.59	172.49	172.59	5480.0
2024-03-14 06:30:00	AAPL	Stock	172.59	172.65	172.28	172.5	13430.0
2024-03-14 07:00:00	AAPL	Stock	172.51	172.55	172.08	172.25	31852.0
2024-03-14 07:30:00	AAPL	Stock	172.22	172.35	172.03	172.25	20099.0
2024-03-14 08:00:00	AAPL	Stock	172.25	172.5	171.51	172.5	139154.0
2024-03-14 08:30:00	AAPL	Stock	172.3	172.51	171.84	172.0	113287.0
2024-03-14 09:00:00	AAPL	Stock	172.0	173.0	171.9001	172.94	158478.0
2024-03-14 09:30:00	AAPL	Stock	172.91	173.275	172.05	172.81	6767797.0
2024-03-14 10:00:00	AAPL	Stock	172.8	173.825	172.38	173.665	4852926.0
2024-03-14 10:30:00	AAPL	Stock	173.67	173.89	173.3	173.84	3319556.0
2024-03-14 11:00:00	AAPL	Stock	173.85	174.3078	173.32	173.34	3671134.0
2024-03-14 11:30:00	AAPL	Stock	173.345	173.49	173.06	173.19	3020281.0
2024-03-14 12:00:00	AAPL	Stock	173.18	173.36	172.4	172.67	2482201.0
2024-03-14 12:30:00	AAPL	Stock	172.68	172.74	172.29	172.36	2381608.0
2024-03-14 13:00:00	AAPL	Stock	172.37	173.3692	172.24	172.963	5005231.0
2024-03-14 13:30:00	AAPL	Stock	172.9689	173.86	172.9	173.695	3101609.0
2024-03-14 14:00:00	AAPL	Stock	173.7	174.0	173.59	173.825	2688838.0
2024-03-14 14:30:00	AAPL	Stock	173.83	173.84	172.88	172.92	2093301.0
2024-03-14 15:00:00	AAPL	Stock	172.92	172.92	172.22	172.66	3074817.0
2024-03-14 15:30:00	AAPL	Stock	172.66	173.2825	172.5033	173.08	6533288.0
2024-03-14 16:00:00	AAPL	Stock	173.09	173.43	172.57	173.37	9771874.0
2024-03-14 16:30:00	AAPL	Stock	173.3874	173.56	173.0	173.5	107984.0
2024-03-14 17:00:00	AAPL	Stock	173.5	173.5	173.35	173.4353	18694.0
2024-03-14 17:30:00	AAPL	Stock	173.4	173.46	173.0	173.42	31660.0
2024-03-14 18:00:00	AAPL	Stock	173.45	173.6899	173.43	173.504	24724.0
2024-03-14 18:30:00	AAPL	Stock	173.54	173.54	173.42	173.42	8975.0
2024-03-14 19:00:00	AAPL	Stock	173.42	173.42	173.16	173.25	24162.0
2024-03-14 19:30:00	AAPL	Stock	173.18	173.39	173.09	173.25	13840.0
2024-03-14 04:00:00	MSFT	Stock	416.72	418.15	416.72	417.92	1698.0
2024-03-14 04:30:00	MSFT	Stock	417.59	418.24	417.59	418.17	951.0
2024-03-14 05:00:00	MSFT	Stock	417.95	418.1	417.7	417.7	1538.0
2024-03-14 05:30:00	MSFT	Stock	417.71	418.0	417.71	418.0	2330.0
2024-03-14 06:00:00	MSFT	Stock	418.44	418.77	418.44	418.71	3220.0
2024-03-14 06:30:00	MSFT	Stock	418.55	418.8	418.55	418.8	1025.0
2024-03-14 07:00:00	MSFT	Stock	418.55	419.18	418.55	419.15	9332.0
2024-03-14 07:30:00	MSFT	Stock	419.0	419.0	418.64	418.7	3650.0
2024-03-14 08:00:00	MSFT	Stock	418.76	419.2484	417.0	418.7985	32168.0
2024-03-14 08:30:00	MSFT	Stock	418.6	419.3	417.24	418.0523	34566.0
2024-03-14 09:00:00	MSFT	Stock	418.5	420.17	417.0019	420.17	79177.0
2024-03-14 09:30:00	MSFT	Stock	420.17	424.95	417.99	422.7	4592383.0
2024-03-14 10:00:00	MSFT	Stock	422.59	426.09	420.81	426.0814	2408552.0
2024-03-14 10:30:00	MSFT	Stock	426.08	426.88	424.56	425.3701	1460831.0
2024-03-14 11:00:00	MSFT	Stock	425.41	427.82	425.35	426.72	1680833.0
2024-03-14 11:30:00	MSFT	Stock	426.76	426.97	424.85	425.33	1098196.0
2024-03-14 12:00:00	MSFT	Stock	425.324	425.5899	423.62	424.99	996636.0
2024-03-14 12:30:00	MSFT	Stock	425.01	425.58	424.55	424.63	643358.0

> showing 50 of 100,644 rows — these rows as CSV

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