PREVIEW / stock_30min / 2022-09-14

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-14.parquet
  size:    2.1 MB
  rows:    103,602
  symbols: 2,206

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
2022-09-14 04:00:00	AAPL	Stock	154.9	155.26	154.59	155.0	38972.0
2022-09-14 04:30:00	AAPL	Stock	155.04	155.33	155.04	155.2	17401.0
2022-09-14 05:00:00	AAPL	Stock	155.12	155.17	154.91	155.11	14485.0
2022-09-14 05:30:00	AAPL	Stock	155.1	155.1	154.71	154.8	17149.0
2022-09-14 06:00:00	AAPL	Stock	154.81	155.03	154.81	154.95	3691.0
2022-09-14 06:30:00	AAPL	Stock	154.95	154.95	154.76	154.89	5970.0
2022-09-14 07:00:00	AAPL	Stock	154.84	154.89	154.21	154.21	91635.0
2022-09-14 07:30:00	AAPL	Stock	154.2	154.3	153.26	153.38	122801.0
2022-09-14 08:00:00	AAPL	Stock	154.73	156.7	153.25	154.102	249378.0
2022-09-14 08:30:00	AAPL	Stock	154.1	154.67	153.72	154.54	345674.0
2022-09-14 09:00:00	AAPL	Stock	154.49	154.87	154.25	154.81	263306.0
2022-09-14 09:30:00	AAPL	Stock	154.76	156.19	154.03	156.05	11426602.0
2022-09-14 10:00:00	AAPL	Stock	156.06	156.45	154.98	155.0	7435095.0
2022-09-14 10:30:00	AAPL	Stock	155.01	156.6	154.8801	156.561	5961165.0
2022-09-14 11:00:00	AAPL	Stock	156.56	157.1	155.9	155.93	5577340.0
2022-09-14 11:30:00	AAPL	Stock	155.92	156.315	155.72	155.79	3948362.0
2022-09-14 12:00:00	AAPL	Stock	155.8	155.8675	155.1903	155.34	3022725.0
2022-09-14 12:30:00	AAPL	Stock	155.34	155.455	154.93	155.1401	3550174.0
2022-09-14 13:00:00	AAPL	Stock	155.14	155.3	154.81	155.065	2768141.0
2022-09-14 13:30:00	AAPL	Stock	155.07	155.16	154.14	154.33	3567808.0
2022-09-14 14:00:00	AAPL	Stock	154.33	154.46	153.88	154.31	3525568.0
2022-09-14 14:30:00	AAPL	Stock	154.31	154.6352	154.02	154.115	3102622.0
2022-09-14 15:00:00	AAPL	Stock	154.12	154.51	153.6106	154.01	3822582.0
2022-09-14 15:30:00	AAPL	Stock	154.0	155.585	153.66	155.31	7808340.0
2022-09-14 16:00:00	AAPL	Stock	155.31	155.71	155.25	155.57	8526816.0
2022-09-14 16:30:00	AAPL	Stock	155.57	155.68	155.52	155.63	55124.0
2022-09-14 17:00:00	AAPL	Stock	155.64	155.71	155.31	155.71	30052.0
2022-09-14 17:30:00	AAPL	Stock	155.71	155.75	155.66	155.7	25402.0
2022-09-14 18:00:00	AAPL	Stock	155.67	155.7	155.55	155.65	24483.0
2022-09-14 18:30:00	AAPL	Stock	155.65	155.89	155.6	155.84	19017.0
2022-09-14 19:00:00	AAPL	Stock	155.82	155.88	155.71	155.75	23472.0
2022-09-14 19:30:00	AAPL	Stock	155.75	156.0	155.75	155.99	31128.0
2022-09-14 04:00:00	MSFT	Stock	253.97	254.33	253.32	253.9	5537.0
2022-09-14 04:30:00	MSFT	Stock	254.28	254.5	254.11	254.36	12724.0
2022-09-14 05:00:00	MSFT	Stock	254.39	254.97	254.35	254.51	6925.0
2022-09-14 05:30:00	MSFT	Stock	254.47	254.47	254.01	254.01	915.0
2022-09-14 06:00:00	MSFT	Stock	254.06	254.06	254.0	254.0	1554.0
2022-09-14 06:30:00	MSFT	Stock	253.94	253.94	253.31	253.31	1198.0
2022-09-14 07:00:00	MSFT	Stock	253.57	253.63	252.64	252.91	13068.0
2022-09-14 07:30:00	MSFT	Stock	252.8	253.26	252.0	252.2	8800.0
2022-09-14 08:00:00	MSFT	Stock	253.4341	253.79	251.361	253.32	23047.0
2022-09-14 08:30:00	MSFT	Stock	253.36	253.6	252.24	253.579	24780.0
2022-09-14 09:00:00	MSFT	Stock	253.35	253.76	253.05	253.53	9677.0
2022-09-14 09:30:00	MSFT	Stock	253.51	254.23	251.13	253.46	2053737.0
2022-09-14 10:00:00	MSFT	Stock	253.47	253.92	251.06	251.1099	1009279.0
2022-09-14 10:30:00	MSFT	Stock	251.1599	253.43	250.8947	253.415	959695.0
2022-09-14 11:00:00	MSFT	Stock	253.4	254.005	252.3	252.35	829560.0
2022-09-14 11:30:00	MSFT	Stock	252.355	253.1014	251.9	251.96	647677.0
2022-09-14 12:00:00	MSFT	Stock	251.99	252.19	251.43	251.92	553061.0
2022-09-14 12:30:00	MSFT	Stock	251.97	252.7	251.77	252.5	1014986.0

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

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