PREVIEW / stock_30min / 2023-03-17

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-17.parquet
  size:    2.1 MB
  rows:    103,136
  symbols: 1,728

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-03-17 04:00:00	AAPL	Stock	155.83	156.21	155.83	156.21	4154.0
2023-03-17 04:30:00	AAPL	Stock	156.2	156.26	156.01	156.01	7204.0
2023-03-17 05:00:00	AAPL	Stock	156.11	156.16	155.85	156.06	3968.0
2023-03-17 05:30:00	AAPL	Stock	156.15	156.15	156.01	156.05	2507.0
2023-03-17 06:00:00	AAPL	Stock	156.11	156.12	155.91	156.0	5363.0
2023-03-17 06:30:00	AAPL	Stock	156.0	156.14	155.99	156.06	2171.0
2023-03-17 07:00:00	AAPL	Stock	156.0	156.06	155.85	155.85	21238.0
2023-03-17 07:30:00	AAPL	Stock	155.87	156.13	155.76	156.08	33487.0
2023-03-17 08:00:00	AAPL	Stock	156.0009	156.19	155.36	155.36	144283.0
2023-03-17 08:30:00	AAPL	Stock	155.36	155.8	155.3	155.74	101619.0
2023-03-17 09:00:00	AAPL	Stock	155.76	156.88	155.76	155.93	740136.0
2023-03-17 09:30:00	AAPL	Stock	156.08	156.31	155.079	155.81	20479607.0
2023-03-17 10:00:00	AAPL	Stock	155.81	156.74	154.88	155.12	5981746.0
2023-03-17 10:30:00	AAPL	Stock	155.13	155.5	154.4201	155.04	4144210.0
2023-03-17 11:00:00	AAPL	Stock	155.05	155.37	154.28	154.665	3248438.0
2023-03-17 11:30:00	AAPL	Stock	154.68	155.13	154.38	155.05	2528057.0
2023-03-17 12:00:00	AAPL	Stock	155.06	155.4	154.9	155.23	2448278.0
2023-03-17 12:30:00	AAPL	Stock	155.24	155.71	154.955	155.27	2248114.0
2023-03-17 13:00:00	AAPL	Stock	155.275	155.85	155.2546	155.56	2238051.0
2023-03-17 13:30:00	AAPL	Stock	155.55	155.84	155.24	155.7995	1985535.0
2023-03-17 14:00:00	AAPL	Stock	155.8	156.0299	154.88	154.98	2342276.0
2023-03-17 14:30:00	AAPL	Stock	154.98	155.2	154.67	154.92	2749924.0
2023-03-17 15:00:00	AAPL	Stock	154.93	155.22	154.39	155.12	3742355.0
2023-03-17 15:30:00	AAPL	Stock	155.11	155.43	154.76	155.005	6097253.0
2023-03-17 16:00:00	AAPL	Stock	155.06	155.18	154.89	155.0	21864523.0
2023-03-17 16:30:00	AAPL	Stock	155.0	155.04	154.9	154.97	93865.0
2023-03-17 17:00:00	AAPL	Stock	154.9797	155.05	154.93	155.0	129982.0
2023-03-17 17:30:00	AAPL	Stock	155.02	155.03	154.8	154.84	159761.0
2023-03-17 18:00:00	AAPL	Stock	154.81	154.83	154.6	154.7	26758.0
2023-03-17 18:30:00	AAPL	Stock	154.7	154.8	154.56	154.6	16670.0
2023-03-17 19:00:00	AAPL	Stock	154.65	154.77	154.63	154.7	5616.0
2023-03-17 19:30:00	AAPL	Stock	154.7	154.74	154.52	154.6	6552.0
2023-03-17 04:00:00	MSFT	Stock	276.4	278.0	276.4	277.65	20654.0
2023-03-17 04:30:00	MSFT	Stock	277.66	277.66	277.08	277.43	15794.0
2023-03-17 05:00:00	MSFT	Stock	277.6	277.7	276.78	276.8	5762.0
2023-03-17 05:30:00	MSFT	Stock	276.8	276.92	276.32	276.92	3906.0
2023-03-17 06:00:00	MSFT	Stock	276.93	276.99	276.5	276.9	2214.0
2023-03-17 06:30:00	MSFT	Stock	276.95	278.0	276.95	277.21	17000.0
2023-03-17 07:00:00	MSFT	Stock	277.4	278.17	277.12	277.13	28798.0
2023-03-17 07:30:00	MSFT	Stock	277.16	278.26	276.81	278.21	31049.0
2023-03-17 08:00:00	MSFT	Stock	277.75	278.87	276.2	276.63	114420.0
2023-03-17 08:30:00	MSFT	Stock	276.4	277.8	276.3	277.32	58819.0
2023-03-17 09:00:00	MSFT	Stock	277.3205	279.5	277.31	278.13	268270.0
2023-03-17 09:30:00	MSFT	Stock	278.1	281.89	277.39	281.52	13378839.0
2023-03-17 10:00:00	MSFT	Stock	281.545	283.33	281.43	282.23	4417976.0
2023-03-17 10:30:00	MSFT	Stock	282.245	282.75	279.2155	280.55	3177477.0
2023-03-17 11:00:00	MSFT	Stock	280.59	280.59	276.95	277.5229	2764822.0
2023-03-17 11:30:00	MSFT	Stock	277.54	278.39	276.3201	277.475	2077693.0
2023-03-17 12:00:00	MSFT	Stock	277.49	278.42	276.88	277.74	1507700.0
2023-03-17 12:30:00	MSFT	Stock	277.77	279.11	277.7557	278.5351	1413412.0

> showing 50 of 103,136 rows — these rows as CSV

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