PREVIEW / stock_30min / 2023-05-25

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-25.parquet
  size:    2.1 MB
  rows:    101,757
  symbols: 1,671

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-05-25 04:00:00	AAPL	Stock	171.37	171.8	171.37	171.58	27388.0
2023-05-25 04:30:00	AAPL	Stock	171.6	171.71	171.41	171.64	9683.0
2023-05-25 05:00:00	AAPL	Stock	171.72	171.75	171.52	171.54	12406.0
2023-05-25 05:30:00	AAPL	Stock	171.53	171.68	171.53	171.65	5810.0
2023-05-25 06:00:00	AAPL	Stock	171.59	171.68	171.5	171.59	14622.0
2023-05-25 06:30:00	AAPL	Stock	171.54	171.54	171.08	171.13	24948.0
2023-05-25 07:00:00	AAPL	Stock	171.16	171.2	170.76	170.92	89404.0
2023-05-25 07:30:00	AAPL	Stock	170.91	171.19	170.67	171.15	39468.0
2023-05-25 08:00:00	AAPL	Stock	171.1582	171.7	170.75	171.24	160381.0
2023-05-25 08:30:00	AAPL	Stock	171.24	172.18	171.22	172.16	279338.0
2023-05-25 09:00:00	AAPL	Stock	172.16	172.59	172.14	172.51	276151.0
2023-05-25 09:30:00	AAPL	Stock	172.5	173.22	172.05	172.51	6409594.0
2023-05-25 10:00:00	AAPL	Stock	172.515	172.87	171.69	171.93	2939247.0
2023-05-25 10:30:00	AAPL	Stock	171.935	172.52	171.695	172.42	2325788.0
2023-05-25 11:00:00	AAPL	Stock	172.43	172.8	172.26	172.27	2416296.0
2023-05-25 11:30:00	AAPL	Stock	172.275	172.36	171.755	172.32	1821859.0
2023-05-25 12:00:00	AAPL	Stock	172.315	173.605	172.305	173.6	2868713.0
2023-05-25 12:30:00	AAPL	Stock	173.595	173.73	173.01	173.0988	2382490.0
2023-05-25 13:00:00	AAPL	Stock	173.11	173.295	172.84	173.2	1554856.0
2023-05-25 13:30:00	AAPL	Stock	173.205	173.465	173.09	173.375	1503337.0
2023-05-25 14:00:00	AAPL	Stock	173.38	173.895	173.2857	173.35	2232965.0
2023-05-25 14:30:00	AAPL	Stock	173.35	173.3909	172.7	172.82	1795199.0
2023-05-25 15:00:00	AAPL	Stock	172.826	173.7	172.82	173.6371	2554116.0
2023-05-25 15:30:00	AAPL	Stock	173.63	173.8588	172.86	172.9984	4447220.0
2023-05-25 16:00:00	AAPL	Stock	172.98	173.5442	172.88	173.08	9198583.0
2023-05-25 16:30:00	AAPL	Stock	173.12	173.16	172.91	172.99	49022.0
2023-05-25 17:00:00	AAPL	Stock	172.94	172.99	172.75	172.7871	18879.0
2023-05-25 17:30:00	AAPL	Stock	172.88	172.91	172.8	172.87	3248.0
2023-05-25 18:00:00	AAPL	Stock	172.89	172.99	172.88	172.91	4565.0
2023-05-25 18:30:00	AAPL	Stock	172.91	172.98	172.88	172.98	9133.0
2023-05-25 19:00:00	AAPL	Stock	172.9899	172.9899	172.89	172.9	7337.0
2023-05-25 19:30:00	AAPL	Stock	172.9	172.9	172.6	172.85	12602.0
2023-05-25 04:00:00	MSFT	Stock	318.97	319.97	318.51	319.58	10075.0
2023-05-25 04:30:00	MSFT	Stock	319.5	319.82	319.16	319.34	8596.0
2023-05-25 05:00:00	MSFT	Stock	319.35	319.77	319.11	319.35	15391.0
2023-05-25 05:30:00	MSFT	Stock	319.45	319.7	319.45	319.7	6330.0
2023-05-25 06:00:00	MSFT	Stock	319.81	319.96	319.6	319.85	8611.0
2023-05-25 06:30:00	MSFT	Stock	319.96	320.5	319.89	320.47	22616.0
2023-05-25 07:00:00	MSFT	Stock	320.51	321.84	320.11	321.52	74792.0
2023-05-25 07:30:00	MSFT	Stock	321.32	321.5	321.1	321.45	46312.0
2023-05-25 08:00:00	MSFT	Stock	320.47	322.0	319.52	322.0	104431.0
2023-05-25 08:30:00	MSFT	Stock	321.6822	323.48	321.6822	323.0	130405.0
2023-05-25 09:00:00	MSFT	Stock	323.06	324.5	322.89	323.35	197910.0
2023-05-25 09:30:00	MSFT	Stock	323.24	323.49	320.0	320.62	4866828.0
2023-05-25 10:00:00	MSFT	Stock	320.63	322.44	320.52	322.03	2080684.0
2023-05-25 10:30:00	MSFT	Stock	322.06	323.9	321.74	323.86	2173658.0
2023-05-25 11:00:00	MSFT	Stock	323.8699	325.2299	323.65	325.21	2651583.0
2023-05-25 11:30:00	MSFT	Stock	325.22	325.59	322.97	323.23	1895926.0
2023-05-25 12:00:00	MSFT	Stock	323.25	325.53	323.21	325.36	1240304.0
2023-05-25 12:30:00	MSFT	Stock	325.37	325.43	324.32	324.5504	1033863.0

> showing 50 of 101,757 rows — these rows as CSV

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