PREVIEW / stock_30min / 2021-07-29

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-29.parquet
  size:    2.2 MB
  rows:    110,455
  symbols: 2,835

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-07-29 04:00:00	AAPL	Stock	145.14	145.69	144.98	145.15	20484.0
2021-07-29 04:30:00	AAPL	Stock	145.25	145.25	145.0	145.0	4540.0
2021-07-29 05:00:00	AAPL	Stock	145.0	145.11	144.94	145.05	7048.0
2021-07-29 05:30:00	AAPL	Stock	145.16	145.38	145.12	145.23	4512.0
2021-07-29 06:00:00	AAPL	Stock	145.21	145.21	144.98	145.03	11383.0
2021-07-29 06:30:00	AAPL	Stock	145.03	145.03	144.5	144.8	12113.0
2021-07-29 07:00:00	AAPL	Stock	144.79	145.01	144.73	144.78	67798.0
2021-07-29 07:30:00	AAPL	Stock	144.77	145.17	144.7	145.15	44182.0
2021-07-29 08:00:00	AAPL	Stock	145.02	145.3	144.618	145.25	168254.0
2021-07-29 08:30:00	AAPL	Stock	145.28	145.46	144.68	144.83	231029.0
2021-07-29 09:00:00	AAPL	Stock	144.84	144.9	144.65	144.7	151520.0
2021-07-29 09:30:00	AAPL	Stock	144.66	146.55	144.58	146.2257	9735398.0
2021-07-29 10:00:00	AAPL	Stock	146.22	146.49	145.61	145.84	5566260.0
2021-07-29 10:30:00	AAPL	Stock	145.85	146.24	145.74	146.075	3923417.0
2021-07-29 11:00:00	AAPL	Stock	146.075	146.12	145.53	145.635	3788275.0
2021-07-29 11:30:00	AAPL	Stock	145.64	145.9309	145.52	145.76	2792816.0
2021-07-29 12:00:00	AAPL	Stock	145.765	146.07	145.68	145.87	2372736.0
2021-07-29 12:30:00	AAPL	Stock	145.88	145.995	145.71	145.95	1578724.0
2021-07-29 13:00:00	AAPL	Stock	145.95	146.17	145.81	145.95	2044195.0
2021-07-29 13:30:00	AAPL	Stock	145.9575	146.01	145.68	145.8015	1835385.0
2021-07-29 14:00:00	AAPL	Stock	145.81	146.01	145.78	145.9218	1643908.0
2021-07-29 14:30:00	AAPL	Stock	145.925	145.96	145.76	145.805	1651278.0
2021-07-29 15:00:00	AAPL	Stock	145.8	145.86	145.645	145.67	2025209.0
2021-07-29 15:30:00	AAPL	Stock	145.68	145.76	145.55	145.62	4460743.0
2021-07-29 16:00:00	AAPL	Stock	145.64	145.64	145.27	145.37	4707662.0
2021-07-29 16:30:00	AAPL	Stock	145.365	145.37	144.8	144.83	262858.0
2021-07-29 17:00:00	AAPL	Stock	144.83	145.64	144.71	144.89	90347.0
2021-07-29 17:30:00	AAPL	Stock	144.85	144.91	144.6	144.6	42937.0
2021-07-29 18:00:00	AAPL	Stock	144.6	145.25	144.6	144.97	93050.0
2021-07-29 18:30:00	AAPL	Stock	144.87	144.97	144.72	144.75	26314.0
2021-07-29 19:00:00	AAPL	Stock	144.71	144.76	144.5	144.51	36019.0
2021-07-29 19:30:00	AAPL	Stock	144.51	144.62	144.33	144.34	69291.0
2021-07-29 04:00:00	MSFT	Stock	286.25	286.79	285.73	286.79	1570.0
2021-07-29 04:30:00	MSFT	Stock	286.8	286.8	286.5	286.56	427.0
2021-07-29 05:00:00	MSFT	Stock	286.43	286.99	286.0	286.5	1974.0
2021-07-29 05:30:00	MSFT	Stock	286.6	287.2	286.3	286.3	1130.0
2021-07-29 06:00:00	MSFT	Stock	286.3	286.3	286.3	286.3	535.0
2021-07-29 06:30:00	MSFT	Stock	286.23	286.23	285.43	286.09	1870.0
2021-07-29 07:00:00	MSFT	Stock	286.0	286.22	285.7	285.75	4083.0
2021-07-29 07:30:00	MSFT	Stock	285.79	286.4	285.79	286.4	5201.0
2021-07-29 08:00:00	MSFT	Stock	285.9866	286.9	285.5901	286.53	10180.0
2021-07-29 08:30:00	MSFT	Stock	286.6	286.66	285.66	285.77	14824.0
2021-07-29 09:00:00	MSFT	Stock	285.86	286.31	285.73	286.07	12031.0
2021-07-29 09:30:00	MSFT	Stock	286.05	288.618	286.05	288.21	2023897.0
2021-07-29 10:00:00	MSFT	Stock	288.21	288.39	286.26	287.185	1512037.0
2021-07-29 10:30:00	MSFT	Stock	287.2	287.315	286.47	286.94	840263.0
2021-07-29 11:00:00	MSFT	Stock	286.9436	287.16	286.38	286.65	753733.0
2021-07-29 11:30:00	MSFT	Stock	286.65	286.82	286.08	286.26	716846.0
2021-07-29 12:00:00	MSFT	Stock	286.26	286.665	286.24	286.6	597298.0
2021-07-29 12:30:00	MSFT	Stock	286.6	286.61	286.17	286.26	428164.0

> showing 50 of 110,455 rows — these rows as CSV

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