PREVIEW / stock_30min / 2023-06-08

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-08.parquet
  size:    2.1 MB
  rows:    100,387
  symbols: 1,621

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-06-08 04:00:00	AAPL	Stock	177.69	177.69	177.21	177.65	6669.0
2023-06-08 04:30:00	AAPL	Stock	177.77	177.77	177.61	177.77	3689.0
2023-06-08 05:00:00	AAPL	Stock	177.82	177.99	177.82	177.99	3957.0
2023-06-08 05:30:00	AAPL	Stock	177.98	178.27	177.89	178.27	7406.0
2023-06-08 06:00:00	AAPL	Stock	178.01	178.36	178.01	178.17	2360.0
2023-06-08 06:30:00	AAPL	Stock	178.03	178.15	177.83	177.91	6757.0
2023-06-08 07:00:00	AAPL	Stock	177.94	178.1	177.74	177.79	32829.0
2023-06-08 07:30:00	AAPL	Stock	177.82	177.82	177.52	177.75	14022.0
2023-06-08 08:00:00	AAPL	Stock	177.99	178.2685	176.58	177.6	67932.0
2023-06-08 08:30:00	AAPL	Stock	177.65	178.5	177.57	177.96	122814.0
2023-06-08 09:00:00	AAPL	Stock	177.93	178.0	177.51	177.89	119567.0
2023-06-08 09:30:00	AAPL	Stock	177.89	178.75	177.76	177.86	4909938.0
2023-06-08 10:00:00	AAPL	Stock	177.865	178.63	177.46	178.47	3549429.0
2023-06-08 10:30:00	AAPL	Stock	178.49	179.19	178.39	179.11	2645448.0
2023-06-08 11:00:00	AAPL	Stock	179.12	179.43	178.971	179.2391	2254376.0
2023-06-08 11:30:00	AAPL	Stock	179.2394	179.88	179.14	179.5099	2214312.0
2023-06-08 12:00:00	AAPL	Stock	179.505	180.0	179.31	179.9699	1986355.0
2023-06-08 12:30:00	AAPL	Stock	179.96	179.97	179.4	179.615	1400352.0
2023-06-08 13:00:00	AAPL	Stock	179.615	179.87	179.405	179.47	1394597.0
2023-06-08 13:30:00	AAPL	Stock	179.465	179.5543	179.01	179.53	1477080.0
2023-06-08 14:00:00	AAPL	Stock	179.54	179.98	179.466	179.945	1745054.0
2023-06-08 14:30:00	AAPL	Stock	179.95	180.24	179.84	179.926	2629521.0
2023-06-08 15:00:00	AAPL	Stock	179.93	180.29	179.73	180.255	2385796.0
2023-06-08 15:30:00	AAPL	Stock	180.25	180.84	180.21	180.55	5388023.0
2023-06-08 16:00:00	AAPL	Stock	180.54	180.6868	180.5	180.61	5755056.0
2023-06-08 16:30:00	AAPL	Stock	180.6	180.67	180.56	180.56	82940.0
2023-06-08 17:00:00	AAPL	Stock	180.57	180.57	180.43	180.5	50658.0
2023-06-08 17:30:00	AAPL	Stock	180.5	180.53	180.45	180.47	7973.0
2023-06-08 18:00:00	AAPL	Stock	180.47	180.55	180.45	180.55	30398.0
2023-06-08 18:30:00	AAPL	Stock	180.54	180.56	180.4229	180.43	17611.0
2023-06-08 19:00:00	AAPL	Stock	180.45	180.45	180.32	180.36	23636.0
2023-06-08 19:30:00	AAPL	Stock	180.43	180.52	180.33	180.5	18621.0
2023-06-08 04:00:00	MSFT	Stock	322.0	322.18	321.4	322.18	4588.0
2023-06-08 04:30:00	MSFT	Stock	322.46	322.76	322.46	322.63	1625.0
2023-06-08 05:00:00	MSFT	Stock	322.9	323.29	322.66	322.9	4271.0
2023-06-08 05:30:00	MSFT	Stock	322.87	323.42	322.55	323.42	993.0
2023-06-08 06:00:00	MSFT	Stock	323.45	323.59	323.45	323.59	521.0
2023-06-08 06:30:00	MSFT	Stock	323.52	323.9	323.01	323.01	4935.0
2023-06-08 07:00:00	MSFT	Stock	323.36	323.52	322.91	323.32	7681.0
2023-06-08 07:30:00	MSFT	Stock	323.23	323.23	322.65	322.85	7097.0
2023-06-08 08:00:00	MSFT	Stock	322.2	323.5	320.0	322.1025	30005.0
2023-06-08 08:30:00	MSFT	Stock	322.4	324.46	322.4	323.71	30475.0
2023-06-08 09:00:00	MSFT	Stock	323.78	324.27	323.32	323.95	21491.0
2023-06-08 09:30:00	MSFT	Stock	323.935	325.21	323.35	324.2599	2836834.0
2023-06-08 10:00:00	MSFT	Stock	324.3	325.7699	323.5	325.2	1456627.0
2023-06-08 10:30:00	MSFT	Stock	325.2281	326.04	324.13	325.81	1102037.0
2023-06-08 11:00:00	MSFT	Stock	325.81	326.52	325.7201	326.14	1008385.0
2023-06-08 11:30:00	MSFT	Stock	326.1622	326.49	325.61	326.16	649228.0
2023-06-08 12:00:00	MSFT	Stock	326.13	326.64	325.74	326.53	653291.0
2023-06-08 12:30:00	MSFT	Stock	326.52	326.6	324.64	324.923	710072.0

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

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