PREVIEW / stock_30min / 2021-12-01

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-12-01.parquet
  size:    2.4 MB
  rows:    117,563
  symbols: 2,700

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
2021-12-01 04:00:00	AAPL	Stock	167.2	168.0	166.95	167.77	38096.0
2021-12-01 04:30:00	AAPL	Stock	167.77	168.0	167.77	167.95	31964.0
2021-12-01 05:00:00	AAPL	Stock	167.91	167.95	167.76	167.77	20465.0
2021-12-01 05:30:00	AAPL	Stock	167.8	167.81	167.75	167.81	10934.0
2021-12-01 06:00:00	AAPL	Stock	167.8	167.9	167.65	167.82	30906.0
2021-12-01 06:30:00	AAPL	Stock	167.83	168.09	167.78	168.09	18920.0
2021-12-01 07:00:00	AAPL	Stock	168.07	168.43	167.9	168.43	153427.0
2021-12-01 07:30:00	AAPL	Stock	168.4	168.65	168.32	168.5	184111.0
2021-12-01 08:00:00	AAPL	Stock	168.29	168.61	164.887	168.23	502453.0
2021-12-01 08:30:00	AAPL	Stock	168.25	168.39	167.0	167.6	412045.0
2021-12-01 09:00:00	AAPL	Stock	167.6	167.95	167.04	167.42	427376.0
2021-12-01 09:30:00	AAPL	Stock	167.46	168.29	166.04	168.27	17313014.0
2021-12-01 10:00:00	AAPL	Stock	168.27	168.45	167.1	167.62	10337623.0
2021-12-01 10:30:00	AAPL	Stock	167.62	169.5	167.61	169.37	10677172.0
2021-12-01 11:00:00	AAPL	Stock	169.37	170.2	169.12	169.8448	10546552.0
2021-12-01 11:30:00	AAPL	Stock	169.85	170.01	169.0799	169.2613	8173203.0
2021-12-01 12:00:00	AAPL	Stock	169.27	169.9699	169.12	169.9	5185464.0
2021-12-01 12:30:00	AAPL	Stock	169.9	170.3	169.06	169.12	6574341.0
2021-12-01 13:00:00	AAPL	Stock	169.13	169.67	168.46	169.3699	7472706.0
2021-12-01 13:30:00	AAPL	Stock	169.355	169.355	167.38	168.3836	7458593.0
2021-12-01 14:00:00	AAPL	Stock	168.38	168.39	167.01	167.94	6190078.0
2021-12-01 14:30:00	AAPL	Stock	167.93	168.21	167.085	167.18	4916383.0
2021-12-01 15:00:00	AAPL	Stock	167.17	167.4488	164.77	165.57	9962008.0
2021-12-01 15:30:00	AAPL	Stock	165.56	166.89	164.53	164.67	13747086.0
2021-12-01 16:00:00	AAPL	Stock	164.65	165.28	164.02	164.9	7663907.0
2021-12-01 16:30:00	AAPL	Stock	164.9	164.9	164.45	164.6	128035.0
2021-12-01 17:00:00	AAPL	Stock	164.54	164.8	164.44	164.8	65651.0
2021-12-01 17:30:00	AAPL	Stock	164.77	165.6	164.75	165.55	100427.0
2021-12-01 18:00:00	AAPL	Stock	165.55	165.85	164.91	165.3	128272.0
2021-12-01 18:30:00	AAPL	Stock	165.3	165.85	165.3	165.76	108857.0
2021-12-01 19:00:00	AAPL	Stock	165.75	166.08	165.59	166.04	77747.0
2021-12-01 19:30:00	AAPL	Stock	166.09	166.3	165.5	166.0	72339.0
2021-12-01 04:00:00	MSFT	Stock	335.0	336.27	335.0	336.25	2853.0
2021-12-01 04:30:00	MSFT	Stock	336.3	336.8	336.25	336.8	2079.0
2021-12-01 05:00:00	MSFT	Stock	336.6	336.6	336.5	336.5	1227.0
2021-12-01 05:30:00	MSFT	Stock	336.59	336.6	336.37	336.37	1467.0
2021-12-01 06:00:00	MSFT	Stock	336.57	336.6	336.39	336.5	2067.0
2021-12-01 06:30:00	MSFT	Stock	336.84	336.88	336.46	336.86	2104.0
2021-12-01 07:00:00	MSFT	Stock	336.69	337.3	336.55	337.3	17044.0
2021-12-01 07:30:00	MSFT	Stock	337.2	337.2	336.7	337.05	7451.0
2021-12-01 08:00:00	MSFT	Stock	336.95	337.4	336.01	336.13	20018.0
2021-12-01 08:30:00	MSFT	Stock	336.38	336.71	335.1	335.12	25083.0
2021-12-01 09:00:00	MSFT	Stock	335.22	335.58	334.4	335.2	58761.0
2021-12-01 09:30:00	MSFT	Stock	335.13	336.83	334.21	335.81	2405000.0
2021-12-01 10:00:00	MSFT	Stock	335.85	336.1	333.86	334.22	1385100.0
2021-12-01 10:30:00	MSFT	Stock	334.27	335.66	333.93	335.62	1085275.0
2021-12-01 11:00:00	MSFT	Stock	335.6499	337.485	334.96	337.12	1160745.0
2021-12-01 11:30:00	MSFT	Stock	337.18	338.53	337.0	337.32	1505878.0
2021-12-01 12:00:00	MSFT	Stock	337.3	338.3682	337.21	337.7	865738.0
2021-12-01 12:30:00	MSFT	Stock	337.759	339.28	335.7101	335.9	1572716.0

> showing 50 of 117,563 rows — these rows as CSV

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