PREVIEW / stock_30min / 2023-07-07

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-07.parquet
  size:    2.0 MB
  rows:    98,666
  symbols: 1,519

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-07 04:00:00	AAPL	Stock	192.4	192.46	191.3	191.5	8519.0
2023-07-07 04:30:00	AAPL	Stock	191.58	191.79	191.58	191.79	1837.0
2023-07-07 05:00:00	AAPL	Stock	191.75	191.79	191.65	191.74	4639.0
2023-07-07 05:30:00	AAPL	Stock	191.75	191.8	191.73	191.73	1760.0
2023-07-07 06:00:00	AAPL	Stock	191.73	191.73	191.44	191.5	5508.0
2023-07-07 06:30:00	AAPL	Stock	191.55	191.61	191.5	191.61	1360.0
2023-07-07 07:00:00	AAPL	Stock	191.65	191.76	191.6	191.65	17776.0
2023-07-07 07:30:00	AAPL	Stock	191.61	191.74	191.56	191.56	19660.0
2023-07-07 08:00:00	AAPL	Stock	191.63	191.86	191.5	191.67	43729.0
2023-07-07 08:30:00	AAPL	Stock	191.76	192.44	191.45	191.85	285809.0
2023-07-07 09:00:00	AAPL	Stock	191.75	191.93	191.29	191.4	286108.0
2023-07-07 09:30:00	AAPL	Stock	191.4	191.67	190.71	191.535	5124885.0
2023-07-07 10:00:00	AAPL	Stock	191.535	191.72	190.62	190.62	2844807.0
2023-07-07 10:30:00	AAPL	Stock	190.62	190.91	190.24	190.6899	2460368.0
2023-07-07 11:00:00	AAPL	Stock	190.68	191.29	190.675	191.2095	1805946.0
2023-07-07 11:30:00	AAPL	Stock	191.21	191.78	191.185	191.7525	2063639.0
2023-07-07 12:00:00	AAPL	Stock	191.76	192.25	191.76	192.1299	2652589.0
2023-07-07 12:30:00	AAPL	Stock	192.125	192.53	192.12	192.31	1957606.0
2023-07-07 13:00:00	AAPL	Stock	192.31	192.59	192.31	192.56	1628364.0
2023-07-07 13:30:00	AAPL	Stock	192.56	192.67	192.16	192.315	1695565.0
2023-07-07 14:00:00	AAPL	Stock	192.32	192.5	192.19	192.4	1154073.0
2023-07-07 14:30:00	AAPL	Stock	192.405	192.49	192.17	192.265	1354959.0
2023-07-07 15:00:00	AAPL	Stock	192.26	192.38	191.74	191.75	1820177.0
2023-07-07 15:30:00	AAPL	Stock	191.74	191.93	190.6	190.71	5246614.0
2023-07-07 16:00:00	AAPL	Stock	190.71	190.85	190.5	190.72	6255762.0
2023-07-07 16:30:00	AAPL	Stock	190.71	190.75	190.65	190.75	62171.0
2023-07-07 17:00:00	AAPL	Stock	190.75	190.84	190.75	190.83	7800.0
2023-07-07 17:30:00	AAPL	Stock	190.8	190.85	190.8	190.81	1358.0
2023-07-07 18:00:00	AAPL	Stock	190.81	190.9	190.81	190.89	6832.0
2023-07-07 18:30:00	AAPL	Stock	190.9	190.97	190.88	190.97	6631.0
2023-07-07 19:00:00	AAPL	Stock	190.93	190.98	190.93	190.98	2513.0
2023-07-07 19:30:00	AAPL	Stock	190.93	190.99	190.88	190.89	9089.0
2023-07-07 04:00:00	MSFT	Stock	340.71	340.91	340.0	340.91	4529.0
2023-07-07 04:30:00	MSFT	Stock	340.88	341.0	340.86	341.0	825.0
2023-07-07 05:00:00	MSFT	Stock	341.17	341.27	340.96	340.96	1739.0
2023-07-07 05:30:00	MSFT	Stock	341.02	341.08	340.91	340.91	761.0
2023-07-07 06:00:00	MSFT	Stock	340.91	340.91	340.21	340.3	909.0
2023-07-07 06:30:00	MSFT	Stock	340.37	340.74	340.37	340.74	845.0
2023-07-07 07:00:00	MSFT	Stock	340.84	341.27	340.78	341.1	3882.0
2023-07-07 07:30:00	MSFT	Stock	341.12	341.12	340.69	340.69	3432.0
2023-07-07 08:00:00	MSFT	Stock	342.65	342.65	340.5	340.6	23232.0
2023-07-07 08:30:00	MSFT	Stock	340.87	343.0	340.09	340.54	108388.0
2023-07-07 09:00:00	MSFT	Stock	340.54	341.2	339.0	339.34	110228.0
2023-07-07 09:30:00	MSFT	Stock	339.34	341.2	338.88	340.915	2189321.0
2023-07-07 10:00:00	MSFT	Stock	340.89	340.93	338.56	338.56	1017455.0
2023-07-07 10:30:00	MSFT	Stock	338.55	339.42	337.56	338.9266	1149107.0
2023-07-07 11:00:00	MSFT	Stock	338.91	339.53	338.85	339.06	617301.0
2023-07-07 11:30:00	MSFT	Stock	339.06	339.64	338.62	339.53	538680.0
2023-07-07 12:00:00	MSFT	Stock	339.54	340.56	339.52	340.29	751156.0
2023-07-07 12:30:00	MSFT	Stock	340.28	341.5435	340.28	341.35	784908.0

> showing 50 of 98,666 rows — these rows as CSV

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