PREVIEW / stock_30min / 2022-08-16

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-16.parquet
  size:    2.2 MB
  rows:    107,606
  symbols: 2,232

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-08-16 04:00:00	AAPL	Stock	172.86	172.94	172.7	172.94	15813.0
2022-08-16 04:30:00	AAPL	Stock	172.84	173.0	172.84	172.88	6187.0
2022-08-16 05:00:00	AAPL	Stock	172.89	172.91	172.75	172.84	5228.0
2022-08-16 05:30:00	AAPL	Stock	172.8	172.84	172.68	172.75	5426.0
2022-08-16 06:00:00	AAPL	Stock	172.8	172.8	172.71	172.78	3196.0
2022-08-16 06:30:00	AAPL	Stock	172.79	172.88	172.75	172.81	6482.0
2022-08-16 07:00:00	AAPL	Stock	172.86	173.19	172.8	173.19	33389.0
2022-08-16 07:30:00	AAPL	Stock	173.15	173.18	173.0	173.08	36952.0
2022-08-16 08:00:00	AAPL	Stock	172.87	173.19	172.0	173.05	259964.0
2022-08-16 08:30:00	AAPL	Stock	173.09	173.09	172.55	172.7446	306717.0
2022-08-16 09:00:00	AAPL	Stock	172.78	172.98	172.52	172.77	128939.0
2022-08-16 09:30:00	AAPL	Stock	172.78	172.87	172.14	172.3299	6329754.0
2022-08-16 10:00:00	AAPL	Stock	172.33	172.43	171.6618	172.11	4694960.0
2022-08-16 10:30:00	AAPL	Stock	172.115	172.605	171.77	172.38	3591714.0
2022-08-16 11:00:00	AAPL	Stock	172.37	173.3	172.35	173.16	3530189.0
2022-08-16 11:30:00	AAPL	Stock	173.16	173.49	172.7801	173.34	2733977.0
2022-08-16 12:00:00	AAPL	Stock	173.34	173.38	172.97	172.975	1773234.0
2022-08-16 12:30:00	AAPL	Stock	172.97	173.01	172.58	172.825	1601924.0
2022-08-16 13:00:00	AAPL	Stock	172.83	173.14	172.715	172.95	1448170.0
2022-08-16 13:30:00	AAPL	Stock	172.95	173.3	172.88	173.09	1652797.0
2022-08-16 14:00:00	AAPL	Stock	173.099	173.71	173.07	173.24	2439398.0
2022-08-16 14:30:00	AAPL	Stock	173.235	173.2401	171.83	172.4	3247635.0
2022-08-16 15:00:00	AAPL	Stock	172.3907	172.7	172.04	172.615	2319834.0
2022-08-16 15:30:00	AAPL	Stock	172.62	173.27	172.6	173.03	4651360.0
2022-08-16 16:00:00	AAPL	Stock	173.02	173.72	172.94	173.46	4650440.0
2022-08-16 16:30:00	AAPL	Stock	173.5	173.9	173.03	173.8967	166638.0
2022-08-16 17:00:00	AAPL	Stock	173.89	174.09	173.852	173.93	111058.0
2022-08-16 17:30:00	AAPL	Stock	173.9	173.9167	173.81	173.84	26326.0
2022-08-16 18:00:00	AAPL	Stock	173.85	173.85	173.65	173.65	29644.0
2022-08-16 18:30:00	AAPL	Stock	173.67	173.72	173.63	173.67	21274.0
2022-08-16 19:00:00	AAPL	Stock	173.69	173.82	173.48	173.53	49628.0
2022-08-16 19:30:00	AAPL	Stock	173.52	173.79	173.5	173.7	74658.0
2022-08-16 04:00:00	MSFT	Stock	292.28	292.7	292.28	292.5	1412.0
2022-08-16 04:30:00	MSFT	Stock	292.97	293.0	292.97	293.0	361.0
2022-08-16 05:00:00	MSFT	Stock	292.75	292.75	292.75	292.75	507.0
2022-08-16 05:30:00	MSFT	Stock	292.75	292.75	292.75	292.75	237.0
2022-08-16 06:30:00	MSFT	Stock	292.75	292.75	292.75	292.75	432.0
2022-08-16 07:00:00	MSFT	Stock	292.86	293.28	292.81	293.28	3788.0
2022-08-16 07:30:00	MSFT	Stock	293.25	293.25	292.7	292.87	4794.0
2022-08-16 08:00:00	MSFT	Stock	292.7523	293.49	292.7	293.0	19864.0
2022-08-16 08:30:00	MSFT	Stock	292.91	292.92	292.22	292.5	27370.0
2022-08-16 09:00:00	MSFT	Stock	292.69	292.75	291.43	291.75	46438.0
2022-08-16 09:30:00	MSFT	Stock	292.03	292.88	291.62	292.47	1764229.0
2022-08-16 10:00:00	MSFT	Stock	292.49	292.5	290.8651	291.4	1019322.0
2022-08-16 10:30:00	MSFT	Stock	291.35	291.6	290.42	291.08	988273.0
2022-08-16 11:00:00	MSFT	Stock	291.06	292.4299	290.9803	292.13	556257.0
2022-08-16 11:30:00	MSFT	Stock	292.115	293.49	291.99	293.1588	559758.0
2022-08-16 12:00:00	MSFT	Stock	293.15	293.23	292.27	292.34	412120.0
2022-08-16 12:30:00	MSFT	Stock	292.34	292.67	292.03	292.33	271970.0
2022-08-16 13:00:00	MSFT	Stock	292.36	292.97	292.2335	292.81	309015.0

> showing 50 of 107,606 rows — these rows as CSV

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