PREVIEW / stock_30min / 2023-07-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-27.parquet
  size:    2.1 MB
  rows:    102,391
  symbols: 1,537

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-07-27 04:00:00	AAPL	Stock	195.42	196.34	195.42	196.23	18171.0
2023-07-27 04:30:00	AAPL	Stock	196.25	196.25	195.98	196.12	15964.0
2023-07-27 05:00:00	AAPL	Stock	196.19	196.2	196.01	196.01	14277.0
2023-07-27 05:30:00	AAPL	Stock	196.1	196.25	196.1	196.24	5247.0
2023-07-27 06:00:00	AAPL	Stock	196.22	196.34	196.17	196.33	2884.0
2023-07-27 06:30:00	AAPL	Stock	196.29	196.36	196.01	196.25	20968.0
2023-07-27 07:00:00	AAPL	Stock	196.19	196.25	196.0	196.16	45473.0
2023-07-27 07:30:00	AAPL	Stock	196.2	196.44	196.2	196.2	28648.0
2023-07-27 08:00:00	AAPL	Stock	196.09	196.4201	194.5	196.2	131904.0
2023-07-27 08:30:00	AAPL	Stock	196.19	196.39	195.97	196.08	92004.0
2023-07-27 09:00:00	AAPL	Stock	196.08	196.25	195.9	196.03	75196.0
2023-07-27 09:30:00	AAPL	Stock	196.05	197.2	195.82	196.9118	5296663.0
2023-07-27 10:00:00	AAPL	Stock	196.92	197.035	195.9201	195.97	2740429.0
2023-07-27 10:30:00	AAPL	Stock	195.98	196.6499	195.45	195.5434	2392414.0
2023-07-27 11:00:00	AAPL	Stock	195.545	196.15	195.49	196.14	2285156.0
2023-07-27 11:30:00	AAPL	Stock	196.15	196.44	195.71	195.83	1930254.0
2023-07-27 12:00:00	AAPL	Stock	195.8471	196.32	195.83	196.305	1508439.0
2023-07-27 12:30:00	AAPL	Stock	196.308	196.43	195.9899	196.075	1139685.0
2023-07-27 13:00:00	AAPL	Stock	196.08	196.26	194.96	195.01	2358993.0
2023-07-27 13:30:00	AAPL	Stock	195.0	195.1102	194.47	194.676	1736685.0
2023-07-27 14:00:00	AAPL	Stock	194.67	194.87	193.72	193.73	2524995.0
2023-07-27 14:30:00	AAPL	Stock	193.725	193.91	192.92	192.96	2842486.0
2023-07-27 15:00:00	AAPL	Stock	192.94	193.66	192.83	193.01	2424079.0
2023-07-27 15:30:00	AAPL	Stock	193.02	193.56	192.55	193.23	4433652.0
2023-07-27 16:00:00	AAPL	Stock	193.24	193.43	193.1	193.3	3806792.0
2023-07-27 16:30:00	AAPL	Stock	193.3	193.34	193.22	193.3	53682.0
2023-07-27 17:00:00	AAPL	Stock	193.33	193.33	193.2801	193.2801	5178.0
2023-07-27 17:30:00	AAPL	Stock	193.2801	193.38	193.27	193.375	19385.0
2023-07-27 18:00:00	AAPL	Stock	193.31	193.39	193.06	193.35	33620.0
2023-07-27 18:30:00	AAPL	Stock	193.338	193.39	193.22	193.39	4899.0
2023-07-27 19:00:00	AAPL	Stock	193.4	193.49	193.35	193.35	7826.0
2023-07-27 19:30:00	AAPL	Stock	193.35	193.55	193.33	193.4	10598.0
2023-07-27 04:00:00	MSFT	Stock	338.5	340.87	338.5	340.54	26655.0
2023-07-27 04:30:00	MSFT	Stock	340.54	340.75	340.0	340.6	10685.0
2023-07-27 05:00:00	MSFT	Stock	340.7	340.94	340.6	340.66	14311.0
2023-07-27 05:30:00	MSFT	Stock	340.93	341.0	340.33	340.33	6545.0
2023-07-27 06:00:00	MSFT	Stock	340.39	340.8	340.1	340.8	2876.0
2023-07-27 06:30:00	MSFT	Stock	340.95	340.95	340.47	340.77	4373.0
2023-07-27 07:00:00	MSFT	Stock	340.6	340.81	339.89	340.03	47510.0
2023-07-27 07:30:00	MSFT	Stock	340.02	340.5	340.02	340.25	32225.0
2023-07-27 08:00:00	MSFT	Stock	340.25	341.42	337.77	340.3	127573.0
2023-07-27 08:30:00	MSFT	Stock	340.3	340.45	339.8	340.15	59187.0
2023-07-27 09:00:00	MSFT	Stock	340.19	340.6	339.06	340.39	127123.0
2023-07-27 09:30:00	MSFT	Stock	340.48	341.33	338.0	338.035	4627975.0
2023-07-27 10:00:00	MSFT	Stock	338.045	338.25	334.58	334.67	2921287.0
2023-07-27 10:30:00	MSFT	Stock	334.64	336.305	334.28	335.3998	2168066.0
2023-07-27 11:00:00	MSFT	Stock	335.43	337.0	335.43	336.68	1448831.0
2023-07-27 11:30:00	MSFT	Stock	336.67	337.25	334.82	335.31	1180494.0
2023-07-27 12:00:00	MSFT	Stock	335.2995	336.48	335.1105	336.41	936527.0
2023-07-27 12:30:00	MSFT	Stock	336.4	336.5	335.28	335.585	838816.0

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

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