PREVIEW / stock_30min / 2022-04-20

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-20.parquet
  size:    2.2 MB
  rows:    106,757
  symbols: 2,494

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-04-20 04:00:00	AAPL	Stock	166.8	166.8	166.31	166.69	8923.0
2022-04-20 04:30:00	AAPL	Stock	166.69	167.0	166.69	166.99	8994.0
2022-04-20 05:00:00	AAPL	Stock	167.02	167.62	167.0	167.53	9648.0
2022-04-20 05:30:00	AAPL	Stock	167.49	168.0	167.41	167.85	13058.0
2022-04-20 06:00:00	AAPL	Stock	167.71	167.89	167.51	167.8	8427.0
2022-04-20 06:30:00	AAPL	Stock	167.87	168.12	167.59	167.74	31052.0
2022-04-20 07:00:00	AAPL	Stock	167.75	167.9	167.56	167.69	34370.0
2022-04-20 07:30:00	AAPL	Stock	167.69	169.15	167.63	169.0	94483.0
2022-04-20 08:00:00	AAPL	Stock	167.847	169.15	166.8	169.01	300017.0
2022-04-20 08:30:00	AAPL	Stock	168.96	169.14	168.5	169.1	146492.0
2022-04-20 09:00:00	AAPL	Stock	169.11	169.12	168.33	168.68	313724.0
2022-04-20 09:30:00	AAPL	Stock	168.76	168.88	166.51	166.7144	8258040.0
2022-04-20 10:00:00	AAPL	Stock	166.67	168.2	166.55	168.08	5231438.0
2022-04-20 10:30:00	AAPL	Stock	168.09	168.4	167.72	167.79	3611877.0
2022-04-20 11:00:00	AAPL	Stock	167.78	167.82	166.58	166.79	3516138.0
2022-04-20 11:30:00	AAPL	Stock	166.8	167.285	166.46	166.7761	2815018.0
2022-04-20 12:00:00	AAPL	Stock	166.765	166.9562	166.1	166.4842	2863159.0
2022-04-20 12:30:00	AAPL	Stock	166.4807	167.285	166.41	167.0814	2428148.0
2022-04-20 13:00:00	AAPL	Stock	167.08	167.59	166.95	167.435	2845432.0
2022-04-20 13:30:00	AAPL	Stock	167.41	168.08	167.36	167.765	2786877.0
2022-04-20 14:00:00	AAPL	Stock	167.76	167.82	167.08	167.13	2485629.0
2022-04-20 14:30:00	AAPL	Stock	167.14	167.28	166.45	166.88	2631673.0
2022-04-20 15:00:00	AAPL	Stock	166.88	167.6	166.8267	167.425	3883208.0
2022-04-20 15:30:00	AAPL	Stock	167.42	167.94	167.01	167.23	8406110.0
2022-04-20 16:00:00	AAPL	Stock	167.23	167.8799	167.18	167.4	6239848.0
2022-04-20 16:30:00	AAPL	Stock	167.4	167.61	167.23	167.59	49885.0
2022-04-20 17:00:00	AAPL	Stock	167.53	167.7	167.5168	167.68	36233.0
2022-04-20 17:30:00	AAPL	Stock	167.67	167.6956	167.5	167.68	3759.0
2022-04-20 18:00:00	AAPL	Stock	167.54	167.7	167.53	167.65	16156.0
2022-04-20 18:30:00	AAPL	Stock	167.69	167.85	167.64	167.66	16377.0
2022-04-20 19:00:00	AAPL	Stock	167.66	167.8	167.65	167.76	33741.0
2022-04-20 19:30:00	AAPL	Stock	167.85	167.99	167.8	167.93	21999.0
2022-04-20 04:00:00	MSFT	Stock	283.44	284.69	283.3	284.69	2195.0
2022-04-20 04:30:00	MSFT	Stock	284.41	284.77	284.1	284.77	8139.0
2022-04-20 05:00:00	MSFT	Stock	284.78	286.29	284.66	285.7	2949.0
2022-04-20 05:30:00	MSFT	Stock	285.95	286.47	285.94	286.34	7414.0
2022-04-20 06:00:00	MSFT	Stock	286.2	286.2	285.42	286.14	426.0
2022-04-20 06:30:00	MSFT	Stock	286.1	286.3	285.87	286.3	9844.0
2022-04-20 07:00:00	MSFT	Stock	286.03	286.3	285.85	286.3	5483.0
2022-04-20 07:30:00	MSFT	Stock	286.25	288.88	286.2	288.55	35294.0
2022-04-20 08:00:00	MSFT	Stock	286.0	288.88	284.15	288.01	43207.0
2022-04-20 08:30:00	MSFT	Stock	288.3	288.35	287.54	288.27	24778.0
2022-04-20 09:00:00	MSFT	Stock	288.2	289.98	287.5	289.31	91146.0
2022-04-20 09:30:00	MSFT	Stock	289.38	289.74	285.98	286.4	2494487.0
2022-04-20 10:00:00	MSFT	Stock	286.38	288.39	285.8	288.1	1283106.0
2022-04-20 10:30:00	MSFT	Stock	288.15	288.89	287.59	288.085	833945.0
2022-04-20 11:00:00	MSFT	Stock	288.08	288.13	286.22	286.51	1033595.0
2022-04-20 11:30:00	MSFT	Stock	286.52	287.6	286.34	287.17	633161.0
2022-04-20 12:00:00	MSFT	Stock	287.21	287.38	285.3702	285.75	761142.0
2022-04-20 12:30:00	MSFT	Stock	285.741	287.24	285.68	286.48	562359.0

> showing 50 of 106,757 rows — these rows as CSV

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