PREVIEW / stock_30min / 2021-12-23

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-12-23.parquet
  size:    2.2 MB
  rows:    108,301
  symbols: 2,638

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
2021-12-23 04:00:00	AAPL	Stock	175.7	176.11	175.65	175.97	5979.0
2021-12-23 04:30:00	AAPL	Stock	175.94	176.07	175.85	176.02	10345.0
2021-12-23 05:00:00	AAPL	Stock	176.08	176.2	176.04	176.18	9778.0
2021-12-23 05:30:00	AAPL	Stock	176.18	176.37	176.14	176.33	5226.0
2021-12-23 06:00:00	AAPL	Stock	176.28	176.4	176.16	176.2	15480.0
2021-12-23 06:30:00	AAPL	Stock	176.2	176.23	176.12	176.19	10495.0
2021-12-23 07:00:00	AAPL	Stock	176.19	176.3	176.1	176.13	53781.0
2021-12-23 07:30:00	AAPL	Stock	176.15	176.25	176.11	176.24	15539.0
2021-12-23 08:00:00	AAPL	Stock	176.19	176.35	176.05	176.18	225036.0
2021-12-23 08:30:00	AAPL	Stock	176.18	176.19	175.7	175.94	212330.0
2021-12-23 09:00:00	AAPL	Stock	175.92	176.1	175.75	175.83	135472.0
2021-12-23 09:30:00	AAPL	Stock	175.82	176.28	175.27	175.89	9555633.0
2021-12-23 10:00:00	AAPL	Stock	175.8884	176.45	175.75	176.4413	5248895.0
2021-12-23 10:30:00	AAPL	Stock	176.45	176.54	176.0602	176.47	4113976.0
2021-12-23 11:00:00	AAPL	Stock	176.48	176.51	175.67	175.7161	3227898.0
2021-12-23 11:30:00	AAPL	Stock	175.72	176.18	175.71	176.18	3127519.0
2021-12-23 12:00:00	AAPL	Stock	176.18	176.24	175.8444	175.9823	2957332.0
2021-12-23 12:30:00	AAPL	Stock	175.9884	176.31	175.795	176.255	2601594.0
2021-12-23 13:00:00	AAPL	Stock	176.26	176.34	175.99	176.19	1977161.0
2021-12-23 13:30:00	AAPL	Stock	176.19	176.28	175.99	175.99	1643259.0
2021-12-23 14:00:00	AAPL	Stock	175.99	176.19	175.76	176.06	2966544.0
2021-12-23 14:30:00	AAPL	Stock	176.06	176.6414	175.9522	176.49	3085130.0
2021-12-23 15:00:00	AAPL	Stock	176.5	176.53	176.08	176.215	3348209.0
2021-12-23 15:30:00	AAPL	Stock	176.21	176.8499	175.97	176.29	7795224.0
2021-12-23 16:00:00	AAPL	Stock	176.28	176.28	175.77	176.07	5416862.0
2021-12-23 16:30:00	AAPL	Stock	176.05	176.28	175.95	176.02	49354.0
2021-12-23 17:00:00	AAPL	Stock	176.02	176.02	175.93	175.99	18326.0
2021-12-23 17:30:00	AAPL	Stock	175.98	176.0	175.9	175.99	16420.0
2021-12-23 18:00:00	AAPL	Stock	175.98	176.05	175.95	176.04	18051.0
2021-12-23 18:30:00	AAPL	Stock	175.98	176.06	175.98	176.02	19401.0
2021-12-23 19:00:00	AAPL	Stock	176.03	176.1	175.85	176.09	36688.0
2021-12-23 19:30:00	AAPL	Stock	176.09	176.5	176.09	176.32	54519.0
2021-12-23 04:00:00	MSFT	Stock	333.86	333.86	333.86	333.86	100.0
2021-12-23 04:30:00	MSFT	Stock	333.56	333.57	333.56	333.57	232.0
2021-12-23 05:00:00	MSFT	Stock	333.56	333.56	333.4	333.4	360.0
2021-12-23 05:30:00	MSFT	Stock	333.5	333.5	333.5	333.5	186.0
2021-12-23 06:30:00	MSFT	Stock	333.85	334.01	333.85	333.9	695.0
2021-12-23 07:00:00	MSFT	Stock	333.91	334.03	333.33	333.48	13901.0
2021-12-23 07:30:00	MSFT	Stock	333.5	333.75	333.47	333.65	1849.0
2021-12-23 08:00:00	MSFT	Stock	333.9993	334.1	333.4009	333.66	12501.0
2021-12-23 08:30:00	MSFT	Stock	333.7	333.7	332.7	333.332	16976.0
2021-12-23 09:00:00	MSFT	Stock	333.31	333.5	332.71	332.71	17457.0
2021-12-23 09:30:00	MSFT	Stock	332.75	334.97	332.73	334.81	1844264.0
2021-12-23 10:00:00	MSFT	Stock	334.86	336.39	334.6	335.56	1308118.0
2021-12-23 10:30:00	MSFT	Stock	335.57	335.78	334.6401	335.62	882229.0
2021-12-23 11:00:00	MSFT	Stock	335.631	335.94	334.97	335.02	648892.0
2021-12-23 11:30:00	MSFT	Stock	335.03	335.52	334.94	335.23	505655.0
2021-12-23 12:00:00	MSFT	Stock	335.28	335.4	334.38	334.43	611021.0
2021-12-23 12:30:00	MSFT	Stock	334.42	335.16	334.37	334.84	553713.0
2021-12-23 13:00:00	MSFT	Stock	334.85	334.94	334.0631	334.6199	491375.0

> showing 50 of 108,301 rows — these rows as CSV

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