PREVIEW / stock_30min / 2023-06-06

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-06.parquet
  size:    2.1 MB
  rows:    100,896
  symbols: 1,603

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-06-06 04:00:00	AAPL	Stock	179.05	179.51	178.51	178.8	49150.0
2023-06-06 04:30:00	AAPL	Stock	178.81	178.87	178.49	178.87	24273.0
2023-06-06 05:00:00	AAPL	Stock	178.86	178.9	178.61	178.61	14606.0
2023-06-06 05:30:00	AAPL	Stock	178.74	178.74	178.17	178.22	31268.0
2023-06-06 06:00:00	AAPL	Stock	178.27	178.45	178.2	178.31	14913.0
2023-06-06 06:30:00	AAPL	Stock	178.38	178.53	178.34	178.45	14009.0
2023-06-06 07:00:00	AAPL	Stock	178.45	178.93	178.33	178.74	83508.0
2023-06-06 07:30:00	AAPL	Stock	178.74	179.0	178.7	178.77	29892.0
2023-06-06 08:00:00	AAPL	Stock	178.4393	180.21	178.4393	178.64	107881.0
2023-06-06 08:30:00	AAPL	Stock	178.58	179.18	178.39	179.08	116597.0
2023-06-06 09:00:00	AAPL	Stock	179.1	180.4	179.1	180.02	422000.0
2023-06-06 09:30:00	AAPL	Stock	179.965	180.12	177.58	177.88	9501018.0
2023-06-06 10:00:00	AAPL	Stock	177.875	179.04	177.43	178.94	6177985.0
2023-06-06 10:30:00	AAPL	Stock	178.95	179.2123	178.42	178.52	4111467.0
2023-06-06 11:00:00	AAPL	Stock	178.52	178.53	177.665	177.79	3666564.0
2023-06-06 11:30:00	AAPL	Stock	177.795	178.86	177.7501	178.83	2983467.0
2023-06-06 12:00:00	AAPL	Stock	178.8201	179.11	178.48	178.69	2974074.0
2023-06-06 12:30:00	AAPL	Stock	178.685	178.79	178.04	178.091	2182287.0
2023-06-06 13:00:00	AAPL	Stock	178.11	178.79	178.03	178.7185	2393036.0
2023-06-06 13:30:00	AAPL	Stock	178.7	179.28	178.6104	178.83	2725227.0
2023-06-06 14:00:00	AAPL	Stock	178.84	179.4	178.71	179.32	2335074.0
2023-06-06 14:30:00	AAPL	Stock	179.325	179.48	179.13	179.4	1689659.0
2023-06-06 15:00:00	AAPL	Stock	179.39	179.7	179.36	179.41	2062793.0
2023-06-06 15:30:00	AAPL	Stock	179.42	179.5599	179.05	179.16	4583591.0
2023-06-06 16:00:00	AAPL	Stock	179.15	179.3	178.93	179.0	4255466.0
2023-06-06 16:30:00	AAPL	Stock	178.99	179.21	178.99	179.04	56747.0
2023-06-06 17:00:00	AAPL	Stock	179.04	179.06	179.0	179.0295	16525.0
2023-06-06 17:30:00	AAPL	Stock	179.01	179.14	179.01	179.1	13217.0
2023-06-06 18:00:00	AAPL	Stock	179.1	179.1	178.89	178.9	19917.0
2023-06-06 18:30:00	AAPL	Stock	178.93	178.9683	178.9	178.9	8622.0
2023-06-06 19:00:00	AAPL	Stock	178.92	178.99	178.9	178.92	6905.0
2023-06-06 19:30:00	AAPL	Stock	178.92	179.05	178.92	179.0	14882.0
2023-06-06 04:00:00	MSFT	Stock	335.58	336.3	335.58	335.84	1199.0
2023-06-06 04:30:00	MSFT	Stock	335.7	335.7	335.7	335.7	140.0
2023-06-06 05:00:00	MSFT	Stock	335.9	336.1	335.9	336.1	421.0
2023-06-06 06:00:00	MSFT	Stock	335.76	335.76	335.65	335.65	251.0
2023-06-06 06:30:00	MSFT	Stock	335.77	335.77	335.77	335.77	100.0
2023-06-06 07:00:00	MSFT	Stock	335.99	336.0	335.62	336.0	4684.0
2023-06-06 07:30:00	MSFT	Stock	336.0	336.0	335.92	336.0	2412.0
2023-06-06 08:00:00	MSFT	Stock	335.95	336.1999	335.7	335.7	5348.0
2023-06-06 08:30:00	MSFT	Stock	335.8	336.41	335.62	336.22	7919.0
2023-06-06 09:00:00	MSFT	Stock	336.27	336.5	335.18	335.41	27203.0
2023-06-06 09:30:00	MSFT	Stock	335.57	335.57	332.77	333.755	2144604.0
2023-06-06 10:00:00	MSFT	Stock	333.765	334.88	333.25	334.5371	1217092.0
2023-06-06 10:30:00	MSFT	Stock	334.5259	334.54	333.42	333.85	1131713.0
2023-06-06 11:00:00	MSFT	Stock	333.89	333.97	332.17	332.6501	1082152.0
2023-06-06 11:30:00	MSFT	Stock	332.66	334.5	332.63	334.4263	936006.0
2023-06-06 12:00:00	MSFT	Stock	334.44	334.63	333.3	333.4788	661565.0
2023-06-06 12:30:00	MSFT	Stock	333.48	333.808	332.59	332.73	574530.0
2023-06-06 13:00:00	MSFT	Stock	332.74	333.84	332.65	333.195	553912.0

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

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