PREVIEW / stock_30min / 2023-06-02

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-02.parquet
  size:    2.1 MB
  rows:    102,793
  symbols: 1,634

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-02 04:00:00	AAPL	Stock	180.68	180.78	180.52	180.76	11688.0
2023-06-02 04:30:00	AAPL	Stock	180.75	181.02	180.7	181.02	20210.0
2023-06-02 05:00:00	AAPL	Stock	181.0	181.28	180.95	181.26	12386.0
2023-06-02 05:30:00	AAPL	Stock	181.25	181.38	181.16	181.25	11129.0
2023-06-02 06:00:00	AAPL	Stock	181.25	181.35	181.22	181.22	12086.0
2023-06-02 06:30:00	AAPL	Stock	181.26	181.26	181.01	181.09	22375.0
2023-06-02 07:00:00	AAPL	Stock	181.01	181.45	181.0	181.45	63018.0
2023-06-02 07:30:00	AAPL	Stock	181.45	181.45	181.15	181.31	37702.0
2023-06-02 08:00:00	AAPL	Stock	181.04	181.45	180.5615	181.3	185368.0
2023-06-02 08:30:00	AAPL	Stock	181.3	181.36	180.52	180.96	257228.0
2023-06-02 09:00:00	AAPL	Stock	180.9	181.29	180.89	181.05	195946.0
2023-06-02 09:30:00	AAPL	Stock	181.03	181.78	179.69	179.81	9407528.0
2023-06-02 10:00:00	AAPL	Stock	179.81	180.36	179.26	179.73	4748435.0
2023-06-02 10:30:00	AAPL	Stock	179.74	180.64	179.64	180.52	3420309.0
2023-06-02 11:00:00	AAPL	Stock	180.53	180.64	180.14	180.5	2481707.0
2023-06-02 11:30:00	AAPL	Stock	180.51	180.99	180.41	180.9704	2671269.0
2023-06-02 12:00:00	AAPL	Stock	180.98	181.0499	180.47	180.67	2498902.0
2023-06-02 12:30:00	AAPL	Stock	180.675	181.01	180.59	180.85	1717602.0
2023-06-02 13:00:00	AAPL	Stock	180.86	180.88	180.53	180.5867	1797388.0
2023-06-02 13:30:00	AAPL	Stock	180.59	180.77	180.3	180.505	2029477.0
2023-06-02 14:00:00	AAPL	Stock	180.51	180.6	180.06	180.4599	2191407.0
2023-06-02 14:30:00	AAPL	Stock	180.45	180.83	180.4	180.63	2111710.0
2023-06-02 15:00:00	AAPL	Stock	180.625	181.04	180.59	180.755	2845099.0
2023-06-02 15:30:00	AAPL	Stock	180.75	181.1	180.61	180.95	5795454.0
2023-06-02 16:00:00	AAPL	Stock	180.95	181.09	180.83	181.0	5876151.0
2023-06-02 16:30:00	AAPL	Stock	181.03	181.09	180.95	181.06	47740.0
2023-06-02 17:00:00	AAPL	Stock	181.06	181.11	181.03	181.08	24498.0
2023-06-02 17:30:00	AAPL	Stock	181.11	181.11	180.94	180.98	19481.0
2023-06-02 18:00:00	AAPL	Stock	180.98	181.0	180.95	180.9601	8587.0
2023-06-02 18:30:00	AAPL	Stock	180.9649	181.06	180.96	181.06	8626.0
2023-06-02 19:00:00	AAPL	Stock	181.01	181.01	180.96	181.0	9220.0
2023-06-02 19:30:00	AAPL	Stock	181.0	181.11	180.97	181.11	9499.0
2023-06-02 04:00:00	MSFT	Stock	334.3	334.3	333.01	333.01	4772.0
2023-06-02 04:30:00	MSFT	Stock	333.28	333.55	333.28	333.54	2326.0
2023-06-02 05:00:00	MSFT	Stock	333.8	334.25	333.8	334.18	1500.0
2023-06-02 05:30:00	MSFT	Stock	334.0	334.0	333.33	333.41	4055.0
2023-06-02 06:00:00	MSFT	Stock	333.35	333.62	333.33	333.62	1051.0
2023-06-02 06:30:00	MSFT	Stock	333.62	333.62	332.91	333.25	3452.0
2023-06-02 07:00:00	MSFT	Stock	333.19	333.85	333.19	333.85	8980.0
2023-06-02 07:30:00	MSFT	Stock	333.8	333.83	333.3	333.58	6225.0
2023-06-02 08:00:00	MSFT	Stock	333.17	335.0	333.0	333.38	27795.0
2023-06-02 08:30:00	MSFT	Stock	333.3	333.67	330.91	331.5681	54506.0
2023-06-02 09:00:00	MSFT	Stock	331.78	334.3	331.78	334.1	104081.0
2023-06-02 09:30:00	MSFT	Stock	334.0	337.5	333.25	333.25	3424335.0
2023-06-02 10:00:00	MSFT	Stock	333.3	334.31	332.56	333.2	1335843.0
2023-06-02 10:30:00	MSFT	Stock	333.21	334.98	332.55	334.785	1106780.0
2023-06-02 11:00:00	MSFT	Stock	334.785	335.25	334.07	334.7	931665.0
2023-06-02 11:30:00	MSFT	Stock	334.715	335.22	334.31	334.885	627107.0
2023-06-02 12:00:00	MSFT	Stock	334.8827	334.98	333.48	334.26	863516.0
2023-06-02 12:30:00	MSFT	Stock	334.29	334.92	334.085	334.49	601394.0

> showing 50 of 102,793 rows — these rows as CSV

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