PREVIEW / stock_30min / 2024-06-17

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-06-17.parquet
  size:    2.1 MB
  rows:    99,534
  symbols: 969

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
2024-06-17 04:00:00	AAPL	Stock	212.62	214.61	212.62	214.34	89248.0
2024-06-17 04:30:00	AAPL	Stock	214.41	214.61	214.0	214.04	34952.0
2024-06-17 05:00:00	AAPL	Stock	214.01	214.02	213.7	214.0	17937.0
2024-06-17 05:30:00	AAPL	Stock	214.0	214.0	213.8	213.8	11764.0
2024-06-17 06:00:00	AAPL	Stock	213.9	214.09	213.65	213.65	28945.0
2024-06-17 06:30:00	AAPL	Stock	213.71	214.16	213.71	213.89	32135.0
2024-06-17 07:00:00	AAPL	Stock	213.71	214.1	213.65	213.97	40884.0
2024-06-17 07:30:00	AAPL	Stock	213.95	214.03	213.69	213.92	40752.0
2024-06-17 08:00:00	AAPL	Stock	213.78	214.3	212.43	214.18	289084.0
2024-06-17 08:30:00	AAPL	Stock	214.1	214.29	213.61	213.82	177091.0
2024-06-17 09:00:00	AAPL	Stock	213.87	213.87	213.06	213.36	230426.0
2024-06-17 09:30:00	AAPL	Stock	213.36	214.8	212.72	213.55	9475149.0
2024-06-17 10:00:00	AAPL	Stock	213.54	216.49	213.53	216.09	8762007.0
2024-06-17 10:30:00	AAPL	Stock	216.09	217.02	215.31	216.88	5118322.0
2024-06-17 11:00:00	AAPL	Stock	216.88	217.33	216.15	216.3315	4555257.0
2024-06-17 11:30:00	AAPL	Stock	216.335	218.0	215.82	216.345	3673075.0
2024-06-17 12:00:00	AAPL	Stock	216.34	216.8122	216.18	216.54	2344443.0
2024-06-17 12:30:00	AAPL	Stock	216.54	217.27	216.13	217.074	2845608.0
2024-06-17 13:00:00	AAPL	Stock	217.08	218.1	216.8	217.82	3412014.0
2024-06-17 13:30:00	AAPL	Stock	217.83	218.7436	217.75	217.9399	3358508.0
2024-06-17 14:00:00	AAPL	Stock	217.92	218.75	217.87	218.35	3488622.0
2024-06-17 14:30:00	AAPL	Stock	218.3452	218.95	218.02	218.7066	3296211.0
2024-06-17 15:00:00	AAPL	Stock	218.705	218.705	217.96	218.155	3529048.0
2024-06-17 15:30:00	AAPL	Stock	218.16	218.34	215.48	216.71	9978861.0
2024-06-17 16:00:00	AAPL	Stock	216.69	217.01	216.46	216.68	12075818.0
2024-06-17 16:30:00	AAPL	Stock	216.5607	217.1	216.5607	216.58	281858.0
2024-06-17 17:00:00	AAPL	Stock	216.58	216.9999	216.56	216.9	46218.0
2024-06-17 17:30:00	AAPL	Stock	216.9	217.2	216.9	217.05	23172.0
2024-06-17 18:00:00	AAPL	Stock	217.05	217.1	216.67	216.98	29806.0
2024-06-17 18:30:00	AAPL	Stock	217.0	217.0	216.7412	216.82	15039.0
2024-06-17 19:00:00	AAPL	Stock	216.8	216.8475	216.67	216.77	23001.0
2024-06-17 19:30:00	AAPL	Stock	216.7343	216.93	216.72	216.76	42075.0
2024-06-17 04:00:00	MSFT	Stock	442.6	444.09	442.6	443.51	2385.0
2024-06-17 04:30:00	MSFT	Stock	443.51	443.51	443.0	443.26	3448.0
2024-06-17 05:30:00	MSFT	Stock	443.71	443.84	443.71	443.84	209.0
2024-06-17 06:00:00	MSFT	Stock	443.66	443.66	443.13	443.13	2753.0
2024-06-17 06:30:00	MSFT	Stock	443.4	443.4	443.4	443.4	2228.0
2024-06-17 07:00:00	MSFT	Stock	443.35	443.35	442.23	443.24	4453.0
2024-06-17 07:30:00	MSFT	Stock	443.0	443.05	442.63	442.63	2184.0
2024-06-17 08:00:00	MSFT	Stock	443.16	443.26	442.09	442.8479	20230.0
2024-06-17 08:30:00	MSFT	Stock	442.75	442.8	442.0	442.39	15007.0
2024-06-17 09:00:00	MSFT	Stock	442.49	442.9	441.85	442.15	19079.0
2024-06-17 09:30:00	MSFT	Stock	442.585	444.28	440.72	441.81	1464905.0
2024-06-17 10:00:00	MSFT	Stock	441.88	443.44	441.66	442.8385	727913.0
2024-06-17 10:30:00	MSFT	Stock	442.84	443.0	441.7701	442.38	506382.0
2024-06-17 11:00:00	MSFT	Stock	442.39	445.2	442.35	443.95	676730.0
2024-06-17 11:30:00	MSFT	Stock	443.97	444.68	443.63	444.34	385221.0
2024-06-17 12:00:00	MSFT	Stock	444.3621	445.41	444.13	445.4	385645.0
2024-06-17 12:30:00	MSFT	Stock	445.405	446.64	445.0305	446.53	522284.0
2024-06-17 13:00:00	MSFT	Stock	446.57	448.0	446.57	447.91	468017.0

> showing 50 of 99,534 rows — these rows as CSV

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