PREVIEW / stock_30min / 2022-03-22

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-03-22.parquet
  size:    2.2 MB
  rows:    109,762
  symbols: 2,514

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-03-22 04:00:00	AAPL	Stock	165.69	165.7	165.0	165.6	10582.0
2022-03-22 04:30:00	AAPL	Stock	165.7	165.93	165.7	165.72	7076.0
2022-03-22 05:00:00	AAPL	Stock	165.79	166.11	165.79	165.9	11657.0
2022-03-22 05:30:00	AAPL	Stock	165.8	165.85	165.7	165.7	2278.0
2022-03-22 06:00:00	AAPL	Stock	165.62	165.62	165.4	165.57	7482.0
2022-03-22 06:30:00	AAPL	Stock	165.7	165.9	165.6	165.76	8951.0
2022-03-22 07:00:00	AAPL	Stock	165.8	165.8	165.4	165.62	32499.0
2022-03-22 07:30:00	AAPL	Stock	165.66	165.75	165.45	165.49	20864.0
2022-03-22 08:00:00	AAPL	Stock	165.7199	165.95	164.99	165.33	204000.0
2022-03-22 08:30:00	AAPL	Stock	165.28	165.64	165.15	165.59	92737.0
2022-03-22 09:00:00	AAPL	Stock	165.59	165.69	165.3	165.47	159825.0
2022-03-22 09:30:00	AAPL	Stock	165.47	166.7811	164.91	166.14	8356448.0
2022-03-22 10:00:00	AAPL	Stock	166.16	168.05	166.155	168.025	8033483.0
2022-03-22 10:30:00	AAPL	Stock	168.0257	168.79	167.93	168.4	6112690.0
2022-03-22 11:00:00	AAPL	Stock	168.4	169.12	168.27	168.81	4990654.0
2022-03-22 11:30:00	AAPL	Stock	168.8	168.91	168.34	168.6163	3429498.0
2022-03-22 12:00:00	AAPL	Stock	168.62	168.9535	168.19	168.34	3148820.0
2022-03-22 12:30:00	AAPL	Stock	168.34	168.94	168.18	168.85	3055559.0
2022-03-22 13:00:00	AAPL	Stock	168.85	169.0591	168.49	168.75	2682799.0
2022-03-22 13:30:00	AAPL	Stock	168.76	169.42	168.74	169.305	3118994.0
2022-03-22 14:00:00	AAPL	Stock	169.31	169.37	168.32	168.625	3407678.0
2022-03-22 14:30:00	AAPL	Stock	168.625	168.8699	168.45	168.6062	2694979.0
2022-03-22 15:00:00	AAPL	Stock	168.6	169.09	168.57	168.855	3801507.0
2022-03-22 15:30:00	AAPL	Stock	168.85	169.25	168.49	168.83	7997183.0
2022-03-22 16:00:00	AAPL	Stock	168.83	169.18	168.81	168.95	8123694.0
2022-03-22 16:30:00	AAPL	Stock	168.91	168.98	168.82	168.95	110423.0
2022-03-22 17:00:00	AAPL	Stock	168.895	168.97	168.7501	168.76	18927.0
2022-03-22 17:30:00	AAPL	Stock	168.8	168.88	168.8	168.88	5249.0
2022-03-22 18:00:00	AAPL	Stock	168.85	168.92	168.71	168.82	13435.0
2022-03-22 18:30:00	AAPL	Stock	168.82	168.97	168.81	168.94	12878.0
2022-03-22 19:00:00	AAPL	Stock	168.93	168.94	168.85	168.89	6482.0
2022-03-22 19:30:00	AAPL	Stock	168.86	168.95	168.85	168.95	21782.0
2022-03-22 04:00:00	MSFT	Stock	299.0	300.0	299.0	299.9	1463.0
2022-03-22 04:30:00	MSFT	Stock	300.14	300.3	299.98	300.3	809.0
2022-03-22 05:00:00	MSFT	Stock	300.5	300.8	300.15	300.15	2115.0
2022-03-22 05:30:00	MSFT	Stock	300.01	300.21	300.0	300.21	3113.0
2022-03-22 06:00:00	MSFT	Stock	300.0	300.22	300.0	300.22	2122.0
2022-03-22 06:30:00	MSFT	Stock	300.46	300.46	300.21	300.21	1633.0
2022-03-22 07:00:00	MSFT	Stock	300.2	300.2	299.16	299.48	16679.0
2022-03-22 07:30:00	MSFT	Stock	299.26	299.5	299.2	299.37	3393.0
2022-03-22 08:00:00	MSFT	Stock	299.62	300.29	298.69	299.1	33446.0
2022-03-22 08:30:00	MSFT	Stock	298.83	299.65	298.78	299.52	9693.0
2022-03-22 09:00:00	MSFT	Stock	299.48	299.6	298.62	299.42	18338.0
2022-03-22 09:30:00	MSFT	Stock	299.68	301.3458	298.77	299.91	2130404.0
2022-03-22 10:00:00	MSFT	Stock	299.94	302.95	299.94	302.8305	1508754.0
2022-03-22 10:30:00	MSFT	Stock	302.855	304.22	302.855	303.34	1309752.0
2022-03-22 11:00:00	MSFT	Stock	303.37	305.0	302.9	304.83	1158724.0
2022-03-22 11:30:00	MSFT	Stock	304.8	304.85	303.73	303.73	829842.0
2022-03-22 12:00:00	MSFT	Stock	303.75	304.15	302.885	303.08	780054.0
2022-03-22 12:30:00	MSFT	Stock	303.0903	303.39	302.46	303.18	817977.0

> showing 50 of 109,762 rows — these rows as CSV

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