PREVIEW / stock_30min / 2023-09-27

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-09-27.parquet
  size:    2.0 MB
  rows:    97,587
  symbols: 1,400

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-09-27 04:00:00	AAPL	Stock	172.71	173.32	172.5	172.88	17484.0
2023-09-27 04:30:00	AAPL	Stock	172.95	173.03	172.95	172.95	2897.0
2023-09-27 05:00:00	AAPL	Stock	172.9	172.9	172.83	172.88	1158.0
2023-09-27 05:30:00	AAPL	Stock	172.88	172.88	172.62	172.67	3289.0
2023-09-27 06:00:00	AAPL	Stock	172.69	172.74	172.54	172.74	6010.0
2023-09-27 06:30:00	AAPL	Stock	172.8	172.84	172.5	172.6	7854.0
2023-09-27 07:00:00	AAPL	Stock	172.65	172.85	172.5	172.85	23312.0
2023-09-27 07:30:00	AAPL	Stock	172.8	172.91	172.55	172.89	56204.0
2023-09-27 08:00:00	AAPL	Stock	172.6	173.17	172.3	172.9	143264.0
2023-09-27 08:30:00	AAPL	Stock	172.83	173.12	172.59	172.94	75632.0
2023-09-27 09:00:00	AAPL	Stock	172.9	173.05	172.46	172.56	119392.0
2023-09-27 09:30:00	AAPL	Stock	172.62	173.04	171.45	171.51	6245197.0
2023-09-27 10:00:00	AAPL	Stock	171.5	171.66	170.31	171.27	5836905.0
2023-09-27 10:30:00	AAPL	Stock	171.25	171.48	170.27	170.409	3269124.0
2023-09-27 11:00:00	AAPL	Stock	170.405	171.1479	170.37	170.975	2801610.0
2023-09-27 11:30:00	AAPL	Stock	170.98	171.08	170.02	170.4	2636669.0
2023-09-27 12:00:00	AAPL	Stock	170.4011	170.41	169.64	169.84	3313060.0
2023-09-27 12:30:00	AAPL	Stock	169.85	170.11	169.73	169.94	2332417.0
2023-09-27 13:00:00	AAPL	Stock	169.93	170.2	169.29	169.3	2710257.0
2023-09-27 13:30:00	AAPL	Stock	169.2999	169.65	169.05	169.53	2555339.0
2023-09-27 14:00:00	AAPL	Stock	169.54	170.1	169.195	170.07	2485015.0
2023-09-27 14:30:00	AAPL	Stock	170.065	170.67	170.065	170.2	3301061.0
2023-09-27 15:00:00	AAPL	Stock	170.2	170.96	170.03	170.16	4286997.0
2023-09-27 15:30:00	AAPL	Stock	170.16	170.48	169.76	170.43	7587741.0
2023-09-27 16:00:00	AAPL	Stock	170.43	170.64	170.25	170.51	6801318.0
2023-09-27 16:30:00	AAPL	Stock	170.47	170.57	170.25	170.43	158218.0
2023-09-27 17:00:00	AAPL	Stock	170.44	170.4693	170.34	170.4693	31853.0
2023-09-27 17:30:00	AAPL	Stock	170.46	170.49	170.43	170.43	10610.0
2023-09-27 18:00:00	AAPL	Stock	170.47	170.4991	170.22	170.24	32136.0
2023-09-27 18:30:00	AAPL	Stock	170.2302	170.33	170.2302	170.2986	16028.0
2023-09-27 19:00:00	AAPL	Stock	170.29	170.35	170.22	170.31	12274.0
2023-09-27 19:30:00	AAPL	Stock	170.31	170.39	170.25	170.34	20288.0
2023-09-27 04:00:00	MSFT	Stock	313.03	314.44	313.03	314.4	2225.0
2023-09-27 04:30:00	MSFT	Stock	314.4	314.4	314.0	314.0	1540.0
2023-09-27 05:00:00	MSFT	Stock	313.76	313.83	313.76	313.83	1263.0
2023-09-27 05:30:00	MSFT	Stock	314.0	314.02	313.66	313.97	3268.0
2023-09-27 06:00:00	MSFT	Stock	313.95	313.95	313.7	313.7	326.0
2023-09-27 06:30:00	MSFT	Stock	313.9	313.94	313.9	313.94	328.0
2023-09-27 07:00:00	MSFT	Stock	313.95	314.08	313.8	314.08	2878.0
2023-09-27 07:30:00	MSFT	Stock	313.93	313.95	313.33	313.33	7344.0
2023-09-27 08:00:00	MSFT	Stock	313.5	314.05	312.9001	313.3	25149.0
2023-09-27 08:30:00	MSFT	Stock	312.95	314.0	312.6	313.68	7654.0
2023-09-27 09:00:00	MSFT	Stock	313.66	314.16	312.36	312.36	32448.0
2023-09-27 09:30:00	MSFT	Stock	312.3	313.7	311.81	312.19	1502749.0
2023-09-27 10:00:00	MSFT	Stock	312.205	312.5024	310.59	311.61	1662836.0
2023-09-27 10:30:00	MSFT	Stock	311.58	312.03	310.1755	310.3472	897027.0
2023-09-27 11:00:00	MSFT	Stock	310.35	311.8483	310.3	311.81	868684.0
2023-09-27 11:30:00	MSFT	Stock	311.8177	311.877	310.51	310.84	466802.0
2023-09-27 12:00:00	MSFT	Stock	310.83	310.9	310.27	310.81	441676.0
2023-09-27 12:30:00	MSFT	Stock	310.83	311.28	310.58	311.0135	522620.0

> showing 50 of 97,587 rows — these rows as CSV

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