PREVIEW / stock_30min / 2021-08-03

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-03.parquet
  size:    2.2 MB
  rows:    109,271
  symbols: 2,801

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-08-03 04:00:00	AAPL	Stock	146.1	146.35	145.79	145.91	11321.0
2021-08-03 04:30:00	AAPL	Stock	145.9	145.9	145.88	145.9	1552.0
2021-08-03 05:00:00	AAPL	Stock	145.9	145.9	145.43	145.53	5440.0
2021-08-03 05:30:00	AAPL	Stock	145.56	145.86	145.56	145.75	5223.0
2021-08-03 06:00:00	AAPL	Stock	145.83	145.87	145.68	145.68	7717.0
2021-08-03 06:30:00	AAPL	Stock	145.7	145.79	145.66	145.79	3905.0
2021-08-03 07:00:00	AAPL	Stock	145.74	145.8	145.39	145.7	51936.0
2021-08-03 07:30:00	AAPL	Stock	145.7	145.78	145.6	145.69	29178.0
2021-08-03 08:00:00	AAPL	Stock	145.6001	145.79	145.49	145.6	91505.0
2021-08-03 08:30:00	AAPL	Stock	145.58	145.89	145.52	145.85	540575.0
2021-08-03 09:00:00	AAPL	Stock	145.86	145.93	145.72	145.82	77812.0
2021-08-03 09:30:00	AAPL	Stock	145.81	146.6	145.18	145.5232	9201307.0
2021-08-03 10:00:00	AAPL	Stock	145.53	146.15	145.33	146.11	4967911.0
2021-08-03 10:30:00	AAPL	Stock	146.11	146.15	145.3399	145.94	3556442.0
2021-08-03 11:00:00	AAPL	Stock	145.93	146.09	145.435	145.8099	2959685.0
2021-08-03 11:30:00	AAPL	Stock	145.8	147.06	145.76	147.0101	5126543.0
2021-08-03 12:00:00	AAPL	Stock	147.0201	147.43	146.9492	147.0701	4128098.0
2021-08-03 12:30:00	AAPL	Stock	147.074	147.75	147.0701	147.73	2757596.0
2021-08-03 13:00:00	AAPL	Stock	147.73	148.045	147.71	147.875	3137475.0
2021-08-03 13:30:00	AAPL	Stock	147.875	148.0287	147.77	147.825	2135234.0
2021-08-03 14:00:00	AAPL	Stock	147.83	147.96	147.57	147.575	2054104.0
2021-08-03 14:30:00	AAPL	Stock	147.585	147.5943	147.13	147.44	2852867.0
2021-08-03 15:00:00	AAPL	Stock	147.44	147.6399	147.4001	147.59	2682489.0
2021-08-03 15:30:00	AAPL	Stock	147.5801	147.74	147.14	147.34	5301307.0
2021-08-03 16:00:00	AAPL	Stock	147.36	147.42	147.32	147.36	4456594.0
2021-08-03 16:30:00	AAPL	Stock	147.36	147.41	147.31	147.36	40454.0
2021-08-03 17:00:00	AAPL	Stock	147.36	147.47	147.35	147.47	17416.0
2021-08-03 17:30:00	AAPL	Stock	147.48	147.48	147.35	147.42	15865.0
2021-08-03 18:00:00	AAPL	Stock	147.42	147.48	147.37	147.43	21225.0
2021-08-03 18:30:00	AAPL	Stock	147.4001	147.42	147.1	147.2	32408.0
2021-08-03 19:00:00	AAPL	Stock	147.15	147.2	147.02	147.16	22692.0
2021-08-03 19:30:00	AAPL	Stock	147.09	147.16	147.01	147.1	43381.0
2021-08-03 04:00:00	MSFT	Stock	284.97	285.44	284.97	285.44	557.0
2021-08-03 05:00:00	MSFT	Stock	285.54	285.6	285.1	285.6	932.0
2021-08-03 05:30:00	MSFT	Stock	285.4	285.4	285.4	285.4	288.0
2021-08-03 06:00:00	MSFT	Stock	285.27	285.4	285.25	285.4	1060.0
2021-08-03 06:30:00	MSFT	Stock	285.35	285.35	285.35	285.35	100.0
2021-08-03 07:00:00	MSFT	Stock	285.33	285.37	284.9	284.9	2788.0
2021-08-03 07:30:00	MSFT	Stock	284.82	284.82	284.76	284.76	454.0
2021-08-03 08:00:00	MSFT	Stock	285.0	285.3895	284.75	284.79	4606.0
2021-08-03 08:30:00	MSFT	Stock	284.99	285.3	284.8	285.3	108709.0
2021-08-03 09:00:00	MSFT	Stock	285.4	286.0	285.03	285.6	16879.0
2021-08-03 09:30:00	MSFT	Stock	285.51	286.89	284.54	284.93	1688051.0
2021-08-03 10:00:00	MSFT	Stock	284.915	285.82	284.5	285.52	1143749.0
2021-08-03 10:30:00	MSFT	Stock	285.52	285.56	284.21	285.1	879317.0
2021-08-03 11:00:00	MSFT	Stock	285.09	285.44	284.25	284.78	733228.0
2021-08-03 11:30:00	MSFT	Stock	284.78	286.84	284.72	286.68	1108005.0
2021-08-03 12:00:00	MSFT	Stock	286.68	287.05	286.37	286.59	813094.0
2021-08-03 12:30:00	MSFT	Stock	286.5963	286.952	286.53	286.952	391261.0
2021-08-03 13:00:00	MSFT	Stock	286.96	287.1	286.56	286.63	560519.0

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

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