PREVIEW / stock_30min / 2023-07-26

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-26.parquet
  size:    2.1 MB
  rows:    100,030
  symbols: 1,522

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-26 04:00:00	AAPL	Stock	193.59	193.92	193.59	193.89	5761.0
2023-07-26 04:30:00	AAPL	Stock	193.86	193.86	193.77	193.8	2613.0
2023-07-26 05:00:00	AAPL	Stock	193.7	193.75	193.68	193.68	2387.0
2023-07-26 05:30:00	AAPL	Stock	193.68	193.68	193.63	193.63	533.0
2023-07-26 06:00:00	AAPL	Stock	193.69	193.69	193.29	193.34	9590.0
2023-07-26 06:30:00	AAPL	Stock	193.21	193.54	193.21	193.3	8161.0
2023-07-26 07:00:00	AAPL	Stock	193.37	193.46	193.3	193.3	7931.0
2023-07-26 07:30:00	AAPL	Stock	193.4	193.44	193.3	193.3	11139.0
2023-07-26 08:00:00	AAPL	Stock	194.05	194.05	193.19	193.59	67490.0
2023-07-26 08:30:00	AAPL	Stock	193.6	193.8	193.59	193.6	40573.0
2023-07-26 09:00:00	AAPL	Stock	193.59	193.72	193.27	193.72	83003.0
2023-07-26 09:30:00	AAPL	Stock	193.71	194.18	193.32	193.65	3522572.0
2023-07-26 10:00:00	AAPL	Stock	193.655	194.17	193.64	193.98	2470681.0
2023-07-26 10:30:00	AAPL	Stock	193.9723	194.72	193.93	194.4106	2874700.0
2023-07-26 11:00:00	AAPL	Stock	194.41	194.53	194.02	194.24	1748482.0
2023-07-26 11:30:00	AAPL	Stock	194.24	194.83	194.2201	194.78	1250513.0
2023-07-26 12:00:00	AAPL	Stock	194.7664	194.94	194.45	194.51	1092529.0
2023-07-26 12:30:00	AAPL	Stock	194.5	194.75	194.185	194.375	1070624.0
2023-07-26 13:00:00	AAPL	Stock	194.37	194.4	194.19	194.36	828939.0
2023-07-26 13:30:00	AAPL	Stock	194.34	194.45	194.05	194.155	1088349.0
2023-07-26 14:00:00	AAPL	Stock	194.1521	194.74	193.94	194.27	1848917.0
2023-07-26 14:30:00	AAPL	Stock	194.25	195.64	194.2001	195.065	3567353.0
2023-07-26 15:00:00	AAPL	Stock	195.08	195.19	193.66	194.215	3257330.0
2023-07-26 15:30:00	AAPL	Stock	194.21	194.85	193.86	194.52	4353902.0
2023-07-26 16:00:00	AAPL	Stock	194.52	195.09	194.42	194.53	7290719.0
2023-07-26 16:30:00	AAPL	Stock	194.55	194.88	194.44	194.48	45644.0
2023-07-26 17:00:00	AAPL	Stock	194.44	194.6339	194.36	194.55	25460.0
2023-07-26 17:30:00	AAPL	Stock	194.57	194.77	194.55	194.71	20880.0
2023-07-26 18:00:00	AAPL	Stock	194.7	194.86	194.65	194.82	54173.0
2023-07-26 18:30:00	AAPL	Stock	194.8	194.91	194.75	194.83	11760.0
2023-07-26 19:00:00	AAPL	Stock	194.81	194.9	194.78	194.88	5956.0
2023-07-26 19:30:00	AAPL	Stock	194.89	195.0	194.86	195.0	13884.0
2023-07-26 04:00:00	MSFT	Stock	337.78	340.0	336.99	337.62	58721.0
2023-07-26 04:30:00	MSFT	Stock	337.22	337.42	335.82	336.3	17733.0
2023-07-26 05:00:00	MSFT	Stock	336.05	337.89	336.05	337.81	26552.0
2023-07-26 05:30:00	MSFT	Stock	337.7	338.23	337.7	338.0	17626.0
2023-07-26 06:00:00	MSFT	Stock	338.11	339.0	337.85	338.26	30663.0
2023-07-26 06:30:00	MSFT	Stock	338.39	339.2	337.8	338.11	18800.0
2023-07-26 07:00:00	MSFT	Stock	338.0	339.8	338.0	339.02	81534.0
2023-07-26 07:30:00	MSFT	Stock	339.0	339.0	338.1	338.94	76793.0
2023-07-26 08:00:00	MSFT	Stock	338.02	341.9	337.58	338.5	279249.0
2023-07-26 08:30:00	MSFT	Stock	338.54	339.6	337.81	338.38	155563.0
2023-07-26 09:00:00	MSFT	Stock	338.4	342.0	338.38	341.49	486426.0
2023-07-26 09:30:00	MSFT	Stock	341.44	344.67	337.1	341.3652	8313656.0
2023-07-26 10:00:00	MSFT	Stock	341.37	341.6	335.8801	336.127	4438956.0
2023-07-26 10:30:00	MSFT	Stock	336.12	337.39	333.93	334.09	4648521.0
2023-07-26 11:00:00	MSFT	Stock	334.106	336.88	333.11	336.81	3308475.0
2023-07-26 11:30:00	MSFT	Stock	336.7901	337.45	336.16	336.95	1930821.0
2023-07-26 12:00:00	MSFT	Stock	336.98	336.98	334.94	335.03	1547343.0
2023-07-26 12:30:00	MSFT	Stock	335.04	335.39	334.58	335.3	1421627.0

> showing 50 of 100,030 rows — these rows as CSV

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