PREVIEW / stock_30min / 2022-07-22

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-22.parquet
  size:    2.0 MB
  rows:    100,419
  symbols: 2,278

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-07-22 04:00:00	AAPL	Stock	154.75	155.0	154.72	154.99	19880.0
2022-07-22 04:30:00	AAPL	Stock	154.99	155.0	154.79	154.95	10537.0
2022-07-22 05:00:00	AAPL	Stock	155.0	155.2	155.0	155.15	11454.0
2022-07-22 05:30:00	AAPL	Stock	155.17	155.32	155.02	155.26	45071.0
2022-07-22 06:00:00	AAPL	Stock	155.15	155.22	154.98	155.18	22816.0
2022-07-22 06:30:00	AAPL	Stock	155.23	155.73	155.22	155.45	30877.0
2022-07-22 07:00:00	AAPL	Stock	155.45	155.55	155.0	155.45	29595.0
2022-07-22 07:30:00	AAPL	Stock	155.45	155.9	155.41	155.86	90672.0
2022-07-22 08:00:00	AAPL	Stock	155.37	155.86	154.58	155.59	197103.0
2022-07-22 08:30:00	AAPL	Stock	155.61	155.7	155.45	155.49	107292.0
2022-07-22 09:00:00	AAPL	Stock	155.5	155.68	155.33	155.34	119275.0
2022-07-22 09:30:00	AAPL	Stock	155.39	156.28	154.92	155.2644	7781222.0
2022-07-22 10:00:00	AAPL	Stock	155.27	155.97	154.9811	155.58	4799037.0
2022-07-22 10:30:00	AAPL	Stock	155.58	156.0	155.28	155.6703	3562036.0
2022-07-22 11:00:00	AAPL	Stock	155.6699	155.72	154.7	154.77	4218755.0
2022-07-22 11:30:00	AAPL	Stock	154.78	154.88	154.07	154.6155	3690127.0
2022-07-22 12:00:00	AAPL	Stock	154.61	154.8	153.97	154.39	3349699.0
2022-07-22 12:30:00	AAPL	Stock	154.39	154.92	154.37	154.5183	2619324.0
2022-07-22 13:00:00	AAPL	Stock	154.52	154.53	153.7	153.82	2664831.0
2022-07-22 13:30:00	AAPL	Stock	153.825	154.15	153.41	154.005	2659326.0
2022-07-22 14:00:00	AAPL	Stock	154.02	154.05	153.41	153.76	2457329.0
2022-07-22 14:30:00	AAPL	Stock	153.76	154.0	153.44	153.795	2651417.0
2022-07-22 15:00:00	AAPL	Stock	153.8	154.53	153.56	154.4	3657198.0
2022-07-22 15:30:00	AAPL	Stock	154.39	154.45	153.69	154.14	6821299.0
2022-07-22 16:00:00	AAPL	Stock	154.14	154.28	154.05	154.28	6631077.0
2022-07-22 16:30:00	AAPL	Stock	154.28	154.32	154.09	154.3	34276.0
2022-07-22 17:00:00	AAPL	Stock	154.34	154.35	154.23	154.23	22835.0
2022-07-22 17:30:00	AAPL	Stock	154.24	154.29	153.95	154.04	39741.0
2022-07-22 18:00:00	AAPL	Stock	154.08	154.09	153.96	154.01	7797.0
2022-07-22 18:30:00	AAPL	Stock	154.0	154.01	153.85	153.99	14258.0
2022-07-22 19:00:00	AAPL	Stock	153.91	153.98	153.82	153.85	8604.0
2022-07-22 19:30:00	AAPL	Stock	153.83	153.95	153.83	153.93	10773.0
2022-07-22 04:00:00	MSFT	Stock	263.69	264.27	263.17	264.1	4483.0
2022-07-22 04:30:00	MSFT	Stock	264.12	264.59	263.99	264.25	1021.0
2022-07-22 05:00:00	MSFT	Stock	264.77	264.89	264.49	264.89	1411.0
2022-07-22 05:30:00	MSFT	Stock	264.28	264.43	263.98	264.0	4275.0
2022-07-22 06:00:00	MSFT	Stock	264.18	264.5	264.18	264.35	1104.0
2022-07-22 06:30:00	MSFT	Stock	264.35	264.84	264.27	264.4	5949.0
2022-07-22 07:00:00	MSFT	Stock	264.45	264.5	264.25	264.49	3746.0
2022-07-22 07:30:00	MSFT	Stock	264.54	265.5	264.53	265.5	16552.0
2022-07-22 08:00:00	MSFT	Stock	264.2598	265.6598	263.57	265.1	30945.0
2022-07-22 08:30:00	MSFT	Stock	265.55	265.55	265.0	265.35	9204.0
2022-07-22 09:00:00	MSFT	Stock	265.23	265.8	265.01	265.23	17383.0
2022-07-22 09:30:00	MSFT	Stock	265.24	265.41	262.35	263.21	3365252.0
2022-07-22 10:00:00	MSFT	Stock	263.195	263.92	261.9	263.2599	1296880.0
2022-07-22 10:30:00	MSFT	Stock	263.25	263.63	261.965	262.62	929423.0
2022-07-22 11:00:00	MSFT	Stock	262.62	262.7	260.91	260.9205	769581.0
2022-07-22 11:30:00	MSFT	Stock	260.9331	261.15	259.66	260.83	831620.0
2022-07-22 12:00:00	MSFT	Stock	260.81	261.1299	259.36	260.36	729637.0
2022-07-22 12:30:00	MSFT	Stock	260.4	260.88	260.075	260.43	413936.0

> showing 50 of 100,419 rows — these rows as CSV

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