PREVIEW / stock_30min / 2023-12-07

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-12-07.parquet
  size:    2.1 MB
  rows:    99,041
  symbols: 1,268

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-12-07 04:00:00	AAPL	Stock	192.22	192.22	191.81	192.0	4484.0
2023-12-07 04:30:00	AAPL	Stock	192.14	192.38	192.14	192.32	5738.0
2023-12-07 05:00:00	AAPL	Stock	192.39	192.4	192.33	192.38	2110.0
2023-12-07 05:30:00	AAPL	Stock	192.36	192.4	192.12	192.4	5606.0
2023-12-07 06:00:00	AAPL	Stock	192.27	192.36	192.22	192.36	3137.0
2023-12-07 06:30:00	AAPL	Stock	192.27	192.29	192.27	192.29	218.0
2023-12-07 07:00:00	AAPL	Stock	192.3	192.39	192.25	192.39	1499.0
2023-12-07 07:30:00	AAPL	Stock	192.4	192.43	192.34	192.35	7103.0
2023-12-07 08:00:00	AAPL	Stock	192.26	192.6986	191.88	192.62	36596.0
2023-12-07 08:30:00	AAPL	Stock	192.65	193.17	192.5	192.94	54831.0
2023-12-07 09:00:00	AAPL	Stock	193.0	193.84	192.93	193.68	187794.0
2023-12-07 09:30:00	AAPL	Stock	193.63	194.92	193.59	193.89	6448865.0
2023-12-07 10:00:00	AAPL	Stock	193.89	194.87	193.88	194.725	2920150.0
2023-12-07 10:30:00	AAPL	Stock	194.725	194.98	194.53	194.7937	2399899.0
2023-12-07 11:00:00	AAPL	Stock	194.8	194.8788	194.02	194.3	1947801.0
2023-12-07 11:30:00	AAPL	Stock	194.29	194.9	194.215	194.87	1677041.0
2023-12-07 12:00:00	AAPL	Stock	194.87	195.0	194.58	194.94	1760651.0
2023-12-07 12:30:00	AAPL	Stock	194.94	194.97	194.51	194.515	1271981.0
2023-12-07 13:00:00	AAPL	Stock	194.52	194.78	194.3131	194.43	1434322.0
2023-12-07 13:30:00	AAPL	Stock	194.43	194.53	194.23	194.32	1023108.0
2023-12-07 14:00:00	AAPL	Stock	194.32	194.4911	194.17	194.47	1185551.0
2023-12-07 14:30:00	AAPL	Stock	194.47	194.475	194.13	194.15	988289.0
2023-12-07 15:00:00	AAPL	Stock	194.15	194.34	194.12	194.17	1435467.0
2023-12-07 15:30:00	AAPL	Stock	194.17	194.35	194.01	194.24	3494234.0
2023-12-07 16:00:00	AAPL	Stock	194.21	194.29	193.85	194.07	7969874.0
2023-12-07 16:30:00	AAPL	Stock	194.04	194.27	193.95	193.9625	57187.0
2023-12-07 17:00:00	AAPL	Stock	194.0	194.05	193.97	194.04	3287.0
2023-12-07 17:30:00	AAPL	Stock	194.07	194.14	194.0403	194.06	5507.0
2023-12-07 18:00:00	AAPL	Stock	194.0616	194.11	194.06	194.1	7734.0
2023-12-07 18:30:00	AAPL	Stock	194.07	194.17	194.06	194.1001	4460.0
2023-12-07 19:00:00	AAPL	Stock	194.11	194.15	194.07	194.14	3296.0
2023-12-07 19:30:00	AAPL	Stock	194.13	194.15	194.05	194.0814	7672.0
2023-12-07 04:00:00	MSFT	Stock	368.58	368.58	366.0	366.36	6896.0
2023-12-07 04:30:00	MSFT	Stock	366.7	367.44	366.7	367.39	5915.0
2023-12-07 05:00:00	MSFT	Stock	367.3	367.3	366.68	366.7	1330.0
2023-12-07 05:30:00	MSFT	Stock	366.7	366.71	366.01	366.01	2106.0
2023-12-07 06:00:00	MSFT	Stock	366.17	366.36	365.8	366.1	3163.0
2023-12-07 06:30:00	MSFT	Stock	366.08	366.26	365.92	365.92	3831.0
2023-12-07 07:00:00	MSFT	Stock	366.25	366.92	366.25	366.92	2713.0
2023-12-07 07:30:00	MSFT	Stock	366.94	367.05	366.67	367.05	5680.0
2023-12-07 08:00:00	MSFT	Stock	366.21	369.0	366.21	367.26	26040.0
2023-12-07 08:30:00	MSFT	Stock	367.1	368.2	366.86	368.14	19368.0
2023-12-07 09:00:00	MSFT	Stock	368.1	368.3983	367.7	368.18	45091.0
2023-12-07 09:30:00	MSFT	Stock	368.2	370.49	366.32	367.04	2588650.0
2023-12-07 10:00:00	MSFT	Stock	366.995	370.11	366.8	369.735	1293844.0
2023-12-07 10:30:00	MSFT	Stock	369.77	369.92	367.89	368.6748	1107037.0
2023-12-07 11:00:00	MSFT	Stock	368.68	369.09	367.71	368.53	820744.0
2023-12-07 11:30:00	MSFT	Stock	368.54	370.59	368.54	370.59	903670.0
2023-12-07 12:00:00	MSFT	Stock	370.6	371.25	369.86	370.87	659157.0
2023-12-07 12:30:00	MSFT	Stock	370.875	370.986	370.25	370.44	466667.0

> showing 50 of 99,041 rows — these rows as CSV

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