PREVIEW / stock_30min / 2024-04-19

all stock 30-min files

  file:    by_date/stock_30min/2024/2024-04-19.parquet
  size:    2.0 MB
  rows:    96,840
  symbols: 992

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
2024-04-19 04:00:00	AAPL	Stock	165.18	166.7	164.72	166.38	23156.0
2024-04-19 04:30:00	AAPL	Stock	166.16	166.35	166.0	166.24	10588.0
2024-04-19 05:00:00	AAPL	Stock	166.29	166.57	166.29	166.57	3974.0
2024-04-19 05:30:00	AAPL	Stock	166.58	166.71	166.5	166.5	3169.0
2024-04-19 06:00:00	AAPL	Stock	166.42	167.88	166.42	167.6	33911.0
2024-04-19 06:30:00	AAPL	Stock	167.49	167.49	167.0	167.19	2603.0
2024-04-19 07:00:00	AAPL	Stock	167.02	167.24	166.9	167.15	20106.0
2024-04-19 07:30:00	AAPL	Stock	167.1	167.29	166.92	167.04	16018.0
2024-04-19 08:00:00	AAPL	Stock	166.9	167.23	165.24	167.16	66042.0
2024-04-19 08:30:00	AAPL	Stock	167.16	167.41	166.77	166.86	46154.0
2024-04-19 09:00:00	AAPL	Stock	166.86	167.0	165.7	166.23	378057.0
2024-04-19 09:30:00	AAPL	Stock	166.24	166.4	165.22	165.3663	8261711.0
2024-04-19 10:00:00	AAPL	Stock	165.365	165.55	164.82	165.27	4591313.0
2024-04-19 10:30:00	AAPL	Stock	165.26	165.66	165.089	165.61	2891543.0
2024-04-19 11:00:00	AAPL	Stock	165.565	165.61	164.86	164.985	2353688.0
2024-04-19 11:30:00	AAPL	Stock	164.98	165.16	164.35	164.375	2569604.0
2024-04-19 12:00:00	AAPL	Stock	164.37	164.78	164.075	164.3624	2646721.0
2024-04-19 12:30:00	AAPL	Stock	164.37	165.3	164.18	165.2088	3140881.0
2024-04-19 13:00:00	AAPL	Stock	165.2	165.29	164.84	164.92	1932966.0
2024-04-19 13:30:00	AAPL	Stock	164.9	165.4996	164.9	165.25	1920531.0
2024-04-19 14:00:00	AAPL	Stock	165.25	165.67	165.01	165.04	2218151.0
2024-04-19 14:30:00	AAPL	Stock	165.02	165.145	164.52	164.965	2563024.0
2024-04-19 15:00:00	AAPL	Stock	164.96	165.24	164.82	165.165	2476339.0
2024-04-19 15:30:00	AAPL	Stock	165.16	165.2	164.79	164.93	6187083.0
2024-04-19 16:00:00	AAPL	Stock	165.0	165.1	164.8	165.03	10848128.0
2024-04-19 16:30:00	AAPL	Stock	165.01	165.03	164.96	164.98	165817.0
2024-04-19 17:00:00	AAPL	Stock	164.99	165.0	164.92	164.93	18074.0
2024-04-19 17:30:00	AAPL	Stock	164.94	164.94	164.8	164.8206	13274.0
2024-04-19 18:00:00	AAPL	Stock	164.85	164.9	164.83	164.85	3876.0
2024-04-19 18:30:00	AAPL	Stock	164.85	165.0	164.57	164.65	26068.0
2024-04-19 19:00:00	AAPL	Stock	164.66	164.67	164.5	164.55	12499.0
2024-04-19 19:30:00	AAPL	Stock	164.51	164.54	164.32	164.4	14259.0
2024-04-19 04:00:00	MSFT	Stock	400.98	403.04	400.98	403.04	8153.0
2024-04-19 04:30:00	MSFT	Stock	402.44	402.44	401.96	402.15	4112.0
2024-04-19 05:00:00	MSFT	Stock	402.01	402.15	401.9	402.05	2627.0
2024-04-19 05:30:00	MSFT	Stock	402.27	403.0	402.27	402.68	1869.0
2024-04-19 06:00:00	MSFT	Stock	402.68	402.7	401.6	401.88	4268.0
2024-04-19 06:30:00	MSFT	Stock	401.99	402.15	401.6	402.15	1868.0
2024-04-19 07:00:00	MSFT	Stock	402.65	403.68	401.86	403.48	10868.0
2024-04-19 07:30:00	MSFT	Stock	403.33	403.76	402.96	403.44	7413.0
2024-04-19 08:00:00	MSFT	Stock	402.2	404.5	396.0	404.4999	25759.0
2024-04-19 08:30:00	MSFT	Stock	404.4899	405.35	404.15	405.1992	20001.0
2024-04-19 09:00:00	MSFT	Stock	405.15	405.15	402.57	404.11	53713.0
2024-04-19 09:30:00	MSFT	Stock	404.11	405.48	402.15	402.34	2612945.0
2024-04-19 10:00:00	MSFT	Stock	402.315	403.055	399.39	400.44	1245558.0
2024-04-19 10:30:00	MSFT	Stock	400.4	402.8391	400.25	402.38	749380.0
2024-04-19 11:00:00	MSFT	Stock	402.3	402.81	401.05	401.36	499026.0
2024-04-19 11:30:00	MSFT	Stock	401.32	401.78	400.41	400.47	457683.0
2024-04-19 12:00:00	MSFT	Stock	400.45	401.14	398.22	398.29	701337.0
2024-04-19 12:30:00	MSFT	Stock	398.33	399.885	398.061	399.79	698517.0

> showing 50 of 96,840 rows — these rows as CSV

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