PREVIEW / stock_30min / 2023-10-31

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-31.parquet
  size:    2.0 MB
  rows:    95,584
  symbols: 1,340

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-10-31 04:00:00	AAPL	Stock	169.6	169.6	169.28	169.45	5864.0
2023-10-31 04:30:00	AAPL	Stock	169.56	169.8	169.54	169.8	6003.0
2023-10-31 05:00:00	AAPL	Stock	169.76	169.8	169.6	169.6	2259.0
2023-10-31 05:30:00	AAPL	Stock	169.63	169.82	169.63	169.8	4866.0
2023-10-31 06:00:00	AAPL	Stock	169.88	170.15	169.88	170.0	2160.0
2023-10-31 06:30:00	AAPL	Stock	170.0	170.0	169.81	169.95	1699.0
2023-10-31 07:00:00	AAPL	Stock	169.91	170.1	169.63	169.68	39735.0
2023-10-31 07:30:00	AAPL	Stock	169.73	169.74	169.5	169.5	12305.0
2023-10-31 08:00:00	AAPL	Stock	169.45	170.19	168.52	170.13	136319.0
2023-10-31 08:30:00	AAPL	Stock	170.02	170.02	169.06	169.09	86672.0
2023-10-31 09:00:00	AAPL	Stock	169.09	169.39	168.6	169.27	108047.0
2023-10-31 09:30:00	AAPL	Stock	169.27	169.45	167.9	168.56	4439901.0
2023-10-31 10:00:00	AAPL	Stock	168.55	169.55	168.32	169.13	2895431.0
2023-10-31 10:30:00	AAPL	Stock	169.15	169.87	168.75	169.71	2611507.0
2023-10-31 11:00:00	AAPL	Stock	169.71	169.8155	169.205	169.23	1758078.0
2023-10-31 11:30:00	AAPL	Stock	169.23	169.79	168.845	169.76	2181362.0
2023-10-31 12:00:00	AAPL	Stock	169.75	169.7699	169.38	169.55	1542916.0
2023-10-31 12:30:00	AAPL	Stock	169.55	170.07	169.27	169.9958	1750289.0
2023-10-31 13:00:00	AAPL	Stock	170.01	170.295	169.77	170.282	1544383.0
2023-10-31 13:30:00	AAPL	Stock	170.29	170.75	170.2657	170.645	2010474.0
2023-10-31 14:00:00	AAPL	Stock	170.64	170.74	169.95	169.96	1491155.0
2023-10-31 14:30:00	AAPL	Stock	169.94	170.63	169.931	170.53	1381053.0
2023-10-31 15:00:00	AAPL	Stock	170.54	170.77	170.485	170.645	1520639.0
2023-10-31 15:30:00	AAPL	Stock	170.64	170.9	170.38	170.77	3848434.0
2023-10-31 16:00:00	AAPL	Stock	170.76	170.77	170.3	170.36	5752842.0
2023-10-31 16:30:00	AAPL	Stock	170.32	170.77	170.17	170.21	218624.0
2023-10-31 17:00:00	AAPL	Stock	170.23	170.49	170.18	170.47	29847.0
2023-10-31 17:30:00	AAPL	Stock	170.44	170.48	170.33	170.37	6529.0
2023-10-31 18:00:00	AAPL	Stock	170.37	170.44	170.22	170.2202	2481.0
2023-10-31 18:30:00	AAPL	Stock	170.32	170.3966	170.3	170.3483	5130.0
2023-10-31 19:00:00	AAPL	Stock	170.32	170.32	170.25	170.25	4158.0
2023-10-31 19:30:00	AAPL	Stock	170.22	170.39	170.02	170.3801	8377.0
2023-10-31 04:00:00	MSFT	Stock	336.5	337.0	336.5	337.0	1008.0
2023-10-31 04:30:00	MSFT	Stock	337.64	337.64	337.53	337.53	476.0
2023-10-31 05:00:00	MSFT	Stock	337.83	337.97	337.81	337.97	1022.0
2023-10-31 05:30:00	MSFT	Stock	337.91	338.0	337.91	337.97	600.0
2023-10-31 06:00:00	MSFT	Stock	338.22	338.89	337.83	338.36	3314.0
2023-10-31 06:30:00	MSFT	Stock	338.8	338.8	338.42	338.46	1130.0
2023-10-31 07:00:00	MSFT	Stock	338.49	339.13	338.49	339.0	6515.0
2023-10-31 07:30:00	MSFT	Stock	338.81	339.24	338.68	339.24	7444.0
2023-10-31 08:00:00	MSFT	Stock	338.84	339.7	335.25	339.69	37406.0
2023-10-31 08:30:00	MSFT	Stock	339.5	339.5	338.55	339.0	25697.0
2023-10-31 09:00:00	MSFT	Stock	339.0	339.44	338.55	338.76	17741.0
2023-10-31 09:30:00	MSFT	Stock	338.89	339.0	335.12	336.19	1741327.0
2023-10-31 10:00:00	MSFT	Stock	336.17	337.8498	335.58	337.21	1205012.0
2023-10-31 10:30:00	MSFT	Stock	337.23	337.5499	335.78	336.62	972408.0
2023-10-31 11:00:00	MSFT	Stock	336.64	336.9798	335.41	335.5	757332.0
2023-10-31 11:30:00	MSFT	Stock	335.505	336.2	334.69	336.11	747241.0
2023-10-31 12:00:00	MSFT	Stock	336.09	336.12	335.2	335.93	535339.0
2023-10-31 12:30:00	MSFT	Stock	335.95	336.87	335.34	336.71	505609.0

> showing 50 of 95,584 rows — these rows as CSV

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