PREVIEW / stock_30min / 2023-07-20

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-07-20.parquet
  size:    2.1 MB
  rows:    100,432
  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-20 04:00:00	AAPL	Stock	193.78	193.81	193.25	193.37	19206.0
2023-07-20 04:30:00	AAPL	Stock	193.44	193.54	193.25	193.29	9349.0
2023-07-20 05:00:00	AAPL	Stock	193.47	193.69	193.34	193.69	876.0
2023-07-20 05:30:00	AAPL	Stock	193.73	193.8	193.55	193.55	1778.0
2023-07-20 06:00:00	AAPL	Stock	193.76	193.96	193.74	193.9	8942.0
2023-07-20 06:30:00	AAPL	Stock	193.89	194.0	193.87	193.9	4432.0
2023-07-20 07:00:00	AAPL	Stock	193.9	194.04	193.65	193.95	24266.0
2023-07-20 07:30:00	AAPL	Stock	193.91	194.38	193.9	194.3	23235.0
2023-07-20 08:00:00	AAPL	Stock	193.95	194.7	193.74	194.15	83110.0
2023-07-20 08:30:00	AAPL	Stock	194.03	194.14	193.8	194.01	70508.0
2023-07-20 09:00:00	AAPL	Stock	194.0	195.08	193.81	195.08	168865.0
2023-07-20 09:30:00	AAPL	Stock	195.08	196.47	195.02	195.7303	7014827.0
2023-07-20 10:00:00	AAPL	Stock	195.74	195.77	194.702	194.908	4837914.0
2023-07-20 10:30:00	AAPL	Stock	194.9026	194.9026	193.9501	194.45	4018356.0
2023-07-20 11:00:00	AAPL	Stock	194.445	194.965	194.21	194.6	2508343.0
2023-07-20 11:30:00	AAPL	Stock	194.61	195.14	194.55	194.93	2037274.0
2023-07-20 12:00:00	AAPL	Stock	194.94	195.5899	194.26	194.62	4307584.0
2023-07-20 12:30:00	AAPL	Stock	194.58	194.98	194.43	194.48	2427155.0
2023-07-20 13:00:00	AAPL	Stock	194.475	194.48	193.88	194.26	2122165.0
2023-07-20 13:30:00	AAPL	Stock	194.25	194.55	193.96	194.3099	1444501.0
2023-07-20 14:00:00	AAPL	Stock	194.3	194.36	193.12	193.1901	2171833.0
2023-07-20 14:30:00	AAPL	Stock	193.19	193.49	193.1061	193.27	1848250.0
2023-07-20 15:00:00	AAPL	Stock	193.275	193.45	192.495	192.545	3047925.0
2023-07-20 15:30:00	AAPL	Stock	192.545	193.41	192.52	193.14	5747935.0
2023-07-20 16:00:00	AAPL	Stock	193.14	193.58	192.91	193.19	7028316.0
2023-07-20 16:30:00	AAPL	Stock	193.2	193.25	192.94	192.96	139707.0
2023-07-20 17:00:00	AAPL	Stock	192.96	193.0393	192.6	192.89	66720.0
2023-07-20 17:30:00	AAPL	Stock	192.78	193.0	192.75	192.92	25835.0
2023-07-20 18:00:00	AAPL	Stock	192.9	193.15	192.89	193.05	16409.0
2023-07-20 18:30:00	AAPL	Stock	193.07	193.14	192.8	193.0	53195.0
2023-07-20 19:00:00	AAPL	Stock	193.04	193.09	192.6	192.76	31413.0
2023-07-20 19:30:00	AAPL	Stock	192.84	192.99	192.62	192.99	34100.0
2023-07-20 04:00:00	MSFT	Stock	354.84	354.84	352.55	352.8	7863.0
2023-07-20 04:30:00	MSFT	Stock	352.47	352.6	352.01	352.05	4437.0
2023-07-20 05:00:00	MSFT	Stock	352.05	352.6	352.05	352.6	2156.0
2023-07-20 05:30:00	MSFT	Stock	352.93	352.93	352.35	352.53	1200.0
2023-07-20 06:00:00	MSFT	Stock	352.75	353.48	352.75	353.4	2143.0
2023-07-20 06:30:00	MSFT	Stock	353.69	353.83	353.55	353.55	1716.0
2023-07-20 07:00:00	MSFT	Stock	353.99	354.68	353.4	354.68	8244.0
2023-07-20 07:30:00	MSFT	Stock	354.66	356.25	354.41	356.1	24565.0
2023-07-20 08:00:00	MSFT	Stock	353.55	356.25	352.4514	355.14	41096.0
2023-07-20 08:30:00	MSFT	Stock	354.9	354.9	353.61	354.33	19378.0
2023-07-20 09:00:00	MSFT	Stock	354.33	354.47	353.2	353.57	34238.0
2023-07-20 09:30:00	MSFT	Stock	353.57	357.97	353.55	355.8407	2735321.0
2023-07-20 10:00:00	MSFT	Stock	355.819	356.18	349.3588	350.02	2164724.0
2023-07-20 10:30:00	MSFT	Stock	350.02	350.68	348.53	350.24	2021648.0
2023-07-20 11:00:00	MSFT	Stock	350.23	351.59	349.6689	349.83	1341163.0
2023-07-20 11:30:00	MSFT	Stock	349.82	351.47	349.452	349.54	1141674.0
2023-07-20 12:00:00	MSFT	Stock	349.54	350.59	347.9289	348.0	1293232.0
2023-07-20 12:30:00	MSFT	Stock	348.02	348.75	347.73	347.98	915001.0

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

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