PREVIEW / stock_30min / 2023-08-07

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-08-07.parquet
  size:    2.1 MB
  rows:    100,608
  symbols: 1,509

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-08-07 04:00:00	AAPL	Stock	183.04	183.49	182.54	182.97	43855.0
2023-08-07 04:30:00	AAPL	Stock	183.0	183.04	182.75	182.91	28299.0
2023-08-07 05:00:00	AAPL	Stock	182.82	183.0	182.77	183.0	6798.0
2023-08-07 05:30:00	AAPL	Stock	183.08	183.2	182.85	182.86	12050.0
2023-08-07 06:00:00	AAPL	Stock	182.82	182.88	182.43	182.52	22322.0
2023-08-07 06:30:00	AAPL	Stock	182.52	182.75	182.38	182.66	10255.0
2023-08-07 07:00:00	AAPL	Stock	182.69	182.97	182.26	182.39	48041.0
2023-08-07 07:30:00	AAPL	Stock	182.37	182.59	182.37	182.54	38535.0
2023-08-07 08:00:00	AAPL	Stock	182.62	183.88	182.1	182.18	195862.0
2023-08-07 08:30:00	AAPL	Stock	182.21	182.7	182.15	182.61	106459.0
2023-08-07 09:00:00	AAPL	Stock	182.63	182.9	182.07	182.1	269260.0
2023-08-07 09:30:00	AAPL	Stock	182.17	183.13	178.2101	178.39	17202191.0
2023-08-07 10:00:00	AAPL	Stock	178.395	179.79	178.31	179.035	7873398.0
2023-08-07 10:30:00	AAPL	Stock	179.03	179.31	178.065	178.11	5678375.0
2023-08-07 11:00:00	AAPL	Stock	178.1	178.18	177.56	177.77	6468410.0
2023-08-07 11:30:00	AAPL	Stock	177.765	178.785	177.35	178.65	4806927.0
2023-08-07 12:00:00	AAPL	Stock	178.66	178.83	178.32	178.365	3495169.0
2023-08-07 12:30:00	AAPL	Stock	178.365	178.47	177.74	178.23	3235256.0
2023-08-07 13:00:00	AAPL	Stock	178.235	178.41	177.97	178.335	2608705.0
2023-08-07 13:30:00	AAPL	Stock	178.34	178.86	178.05	178.8384	3102953.0
2023-08-07 14:00:00	AAPL	Stock	178.84	179.04	178.31	178.45	2890730.0
2023-08-07 14:30:00	AAPL	Stock	178.47	178.71	178.46	178.475	2171552.0
2023-08-07 15:00:00	AAPL	Stock	178.48	178.62	178.22	178.4801	2576484.0
2023-08-07 15:30:00	AAPL	Stock	178.485	179.22	178.39	178.809	8608548.0
2023-08-07 16:00:00	AAPL	Stock	178.79	178.86	178.69	178.79	5818181.0
2023-08-07 16:30:00	AAPL	Stock	178.78	179.09	178.71	179.03	279854.0
2023-08-07 17:00:00	AAPL	Stock	179.04	179.15	179.03	179.13	95521.0
2023-08-07 17:30:00	AAPL	Stock	179.12	179.15	179.0599	179.11	48029.0
2023-08-07 18:00:00	AAPL	Stock	179.11	179.12	179.0	179.02	21122.0
2023-08-07 18:30:00	AAPL	Stock	179.05	179.15	179.04	179.12	16013.0
2023-08-07 19:00:00	AAPL	Stock	179.11	179.15	179.03	179.1	22982.0
2023-08-07 19:30:00	AAPL	Stock	179.1	179.16	179.1	179.16	31941.0
2023-08-07 04:00:00	MSFT	Stock	329.9	330.3	329.44	329.8	5453.0
2023-08-07 04:30:00	MSFT	Stock	329.6	329.7	329.18	329.22	1613.0
2023-08-07 05:00:00	MSFT	Stock	329.35	329.73	329.35	329.73	311.0
2023-08-07 05:30:00	MSFT	Stock	329.81	329.81	329.22	329.51	1949.0
2023-08-07 06:00:00	MSFT	Stock	329.27	329.27	329.25	329.25	200.0
2023-08-07 06:30:00	MSFT	Stock	328.74	329.13	328.74	329.13	1034.0
2023-08-07 07:00:00	MSFT	Stock	329.31	329.31	328.99	328.99	4485.0
2023-08-07 07:30:00	MSFT	Stock	329.0	329.17	328.79	329.16	1237.0
2023-08-07 08:00:00	MSFT	Stock	329.2	330.0	328.5	328.95	20197.0
2023-08-07 08:30:00	MSFT	Stock	328.66	329.61	328.66	329.5	11120.0
2023-08-07 09:00:00	MSFT	Stock	329.49	329.9	328.18	328.32	25793.0
2023-08-07 09:30:00	MSFT	Stock	328.37	331.11	328.37	329.785	1718923.0
2023-08-07 10:00:00	MSFT	Stock	329.7	330.87	328.81	330.32	940655.0
2023-08-07 10:30:00	MSFT	Stock	330.3	330.5	328.98	329.3	601565.0
2023-08-07 11:00:00	MSFT	Stock	329.21	329.56	327.52	328.42	1082480.0
2023-08-07 11:30:00	MSFT	Stock	328.46	329.3899	327.85	329.28	707164.0
2023-08-07 12:00:00	MSFT	Stock	329.35	329.81	328.33	329.15	577427.0
2023-08-07 12:30:00	MSFT	Stock	329.145	329.15	328.26	329.0023	586193.0

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

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