PREVIEW / stock_30min / 2023-01-30

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-01-30.parquet
  size:    2.1 MB
  rows:    104,837
  symbols: 1,928

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-01-30 04:00:00	AAPL	Stock	145.54	145.54	143.93	144.19	32420.0
2023-01-30 04:30:00	AAPL	Stock	144.12	144.21	143.92	144.13	16362.0
2023-01-30 05:00:00	AAPL	Stock	144.12	144.14	143.97	144.06	5799.0
2023-01-30 05:30:00	AAPL	Stock	144.05	144.16	143.99	144.0	6926.0
2023-01-30 06:00:00	AAPL	Stock	144.03	144.07	143.81	143.81	7890.0
2023-01-30 06:30:00	AAPL	Stock	143.82	144.06	143.56	143.93	14262.0
2023-01-30 07:00:00	AAPL	Stock	143.95	144.5	143.95	144.43	48642.0
2023-01-30 07:30:00	AAPL	Stock	144.45	144.89	144.3	144.8	31448.0
2023-01-30 08:00:00	AAPL	Stock	144.31	145.64	144.0	145.07	260093.0
2023-01-30 08:30:00	AAPL	Stock	145.11	145.11	144.65	144.859	100658.0
2023-01-30 09:00:00	AAPL	Stock	144.8573	145.0	144.68	145.0	122345.0
2023-01-30 09:30:00	AAPL	Stock	144.955	145.55	144.171	145.185	6952551.0
2023-01-30 10:00:00	AAPL	Stock	145.18	145.35	143.85	144.19	4293797.0
2023-01-30 10:30:00	AAPL	Stock	144.19	144.23	143.37	143.995	3957677.0
2023-01-30 11:00:00	AAPL	Stock	143.99	144.32	143.71	143.88	2767177.0
2023-01-30 11:30:00	AAPL	Stock	143.87	144.23	143.5	144.1882	2296274.0
2023-01-30 12:00:00	AAPL	Stock	144.18	144.26	143.15	143.675	3010022.0
2023-01-30 12:30:00	AAPL	Stock	143.675	143.785	143.17	143.415	2582052.0
2023-01-30 13:00:00	AAPL	Stock	143.41	143.82	143.31	143.4978	1939681.0
2023-01-30 13:30:00	AAPL	Stock	143.49	143.49	143.01	143.375	2507459.0
2023-01-30 14:00:00	AAPL	Stock	143.3703	143.5899	143.03	143.15	2462416.0
2023-01-30 14:30:00	AAPL	Stock	143.155	143.517	142.881	143.19	3101986.0
2023-01-30 15:00:00	AAPL	Stock	143.19	143.46	142.93	143.055	3415727.0
2023-01-30 15:30:00	AAPL	Stock	143.06	143.52	142.85	143.03	6568312.0
2023-01-30 16:00:00	AAPL	Stock	143.0	143.4584	142.9967	143.21	8256544.0
2023-01-30 16:30:00	AAPL	Stock	143.19	143.27	143.0	143.11	52400.0
2023-01-30 17:00:00	AAPL	Stock	143.12	144.9	143.0	143.01	26814.0
2023-01-30 17:30:00	AAPL	Stock	143.01	143.05	142.94	142.95	8478.0
2023-01-30 18:00:00	AAPL	Stock	143.06	143.16	143.03	143.08	9421.0
2023-01-30 18:30:00	AAPL	Stock	143.1	143.32	143.05	143.2	18375.0
2023-01-30 19:00:00	AAPL	Stock	143.2	143.2	143.04	143.1	7753.0
2023-01-30 19:30:00	AAPL	Stock	143.1	143.17	143.0	143.0	19205.0
2023-01-30 04:00:00	MSFT	Stock	246.0	246.49	245.48	245.6	5237.0
2023-01-30 04:30:00	MSFT	Stock	245.54	245.54	245.0	245.3	1126.0
2023-01-30 05:00:00	MSFT	Stock	245.2	245.34	245.16	245.3	1301.0
2023-01-30 05:30:00	MSFT	Stock	245.3	245.3	245.24	245.24	1164.0
2023-01-30 06:00:00	MSFT	Stock	245.24	245.24	244.78	244.78	2567.0
2023-01-30 06:30:00	MSFT	Stock	244.5	245.0	244.14	244.27	3286.0
2023-01-30 07:00:00	MSFT	Stock	244.86	245.0	244.61	244.64	33040.0
2023-01-30 07:30:00	MSFT	Stock	244.69	244.85	244.41	244.77	16217.0
2023-01-30 08:00:00	MSFT	Stock	244.9011	247.8	244.36	244.48	25066.0
2023-01-30 08:30:00	MSFT	Stock	244.37	244.689	244.03	244.55	24127.0
2023-01-30 09:00:00	MSFT	Stock	244.55	245.25	244.25	244.6	38488.0
2023-01-30 09:30:00	MSFT	Stock	244.5	245.6	243.56	244.76	2454047.0
2023-01-30 10:00:00	MSFT	Stock	244.72	245.0472	242.77	243.42	1632508.0
2023-01-30 10:30:00	MSFT	Stock	243.37	243.37	242.26	242.992	1309380.0
2023-01-30 11:00:00	MSFT	Stock	243.0	243.955	242.695	243.8	860867.0
2023-01-30 11:30:00	MSFT	Stock	243.8	244.08	242.76	243.67	731794.0
2023-01-30 12:00:00	MSFT	Stock	243.67	244.1099	243.12	243.68	646747.0
2023-01-30 12:30:00	MSFT	Stock	243.66	243.69	242.62	242.94	709896.0

> showing 50 of 104,837 rows — these rows as CSV

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