PREVIEW / stock_30min / 2023-03-31

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-31.parquet
  size:    2.1 MB
  rows:    101,450
  symbols: 1,721

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
2023-03-31 04:00:00	AAPL	Stock	162.39	162.5	161.97	162.04	5343.0
2023-03-31 04:30:00	AAPL	Stock	162.09	162.1	162.0	162.01	1937.0
2023-03-31 05:00:00	AAPL	Stock	162.01	162.14	161.93	162.06	2710.0
2023-03-31 05:30:00	AAPL	Stock	162.11	162.14	162.05	162.05	2060.0
2023-03-31 06:00:00	AAPL	Stock	162.12	162.12	162.0	162.0	4043.0
2023-03-31 06:30:00	AAPL	Stock	162.05	162.07	161.84	162.04	12000.0
2023-03-31 07:00:00	AAPL	Stock	162.08	162.19	162.02	162.19	13104.0
2023-03-31 07:30:00	AAPL	Stock	162.2	162.24	162.11	162.11	10517.0
2023-03-31 08:00:00	AAPL	Stock	162.21	162.64	161.955	162.25	50647.0
2023-03-31 08:30:00	AAPL	Stock	162.13	162.8	162.05	162.16	175520.0
2023-03-31 09:00:00	AAPL	Stock	162.19	162.57	162.02	162.42	112261.0
2023-03-31 09:30:00	AAPL	Stock	162.43	163.09	161.91	162.705	5060696.0
2023-03-31 10:00:00	AAPL	Stock	162.71	162.9	162.25	162.56	3167065.0
2023-03-31 10:30:00	AAPL	Stock	162.565	163.02	162.52	162.785	2627808.0
2023-03-31 11:00:00	AAPL	Stock	162.8	163.17	162.7093	163.0962	2395991.0
2023-03-31 11:30:00	AAPL	Stock	163.0975	163.26	162.92	163.22	1860951.0
2023-03-31 12:00:00	AAPL	Stock	163.22	163.9	163.15	163.89	2376905.0
2023-03-31 12:30:00	AAPL	Stock	163.885	164.04	163.65	163.8	2966724.0
2023-03-31 13:00:00	AAPL	Stock	163.81	164.075	163.57	163.885	2415595.0
2023-03-31 13:30:00	AAPL	Stock	163.88	163.98	163.65	163.9571	1486000.0
2023-03-31 14:00:00	AAPL	Stock	163.96	164.175	163.92	164.075	1915539.0
2023-03-31 14:30:00	AAPL	Stock	164.075	164.24	164.0	164.23	2028545.0
2023-03-31 15:00:00	AAPL	Stock	164.22	164.94	164.21	164.88	4243537.0
2023-03-31 15:30:00	AAPL	Stock	164.88	165.0	164.125	164.84	10826604.0
2023-03-31 16:00:00	AAPL	Stock	164.83	164.96	164.63	164.82	16322051.0
2023-03-31 16:30:00	AAPL	Stock	164.82	164.9	164.8	164.82	66900.0
2023-03-31 17:00:00	AAPL	Stock	164.82	164.9	164.81	164.84	19706.0
2023-03-31 17:30:00	AAPL	Stock	164.84	164.84	164.74	164.75	36137.0
2023-03-31 18:00:00	AAPL	Stock	164.75	164.82	164.71	164.73	14925.0
2023-03-31 18:30:00	AAPL	Stock	164.76	164.87	164.75	164.87	15088.0
2023-03-31 19:00:00	AAPL	Stock	164.87	164.9	164.81	164.85	7298.0
2023-03-31 19:30:00	AAPL	Stock	164.86	164.93	164.86	164.9	10193.0
2023-03-31 04:00:00	MSFT	Stock	283.95	284.3	283.83	283.98	3619.0
2023-03-31 04:30:00	MSFT	Stock	283.98	283.99	283.65	283.73	1900.0
2023-03-31 05:30:00	MSFT	Stock	283.9	283.9	283.81	283.81	1322.0
2023-03-31 06:00:00	MSFT	Stock	283.6	283.7	283.53	283.7	321.0
2023-03-31 06:30:00	MSFT	Stock	283.5	283.6	283.5	283.55	1459.0
2023-03-31 07:00:00	MSFT	Stock	283.55	283.9	283.55	283.7	3848.0
2023-03-31 07:30:00	MSFT	Stock	283.75	283.75	283.25	283.25	4867.0
2023-03-31 08:00:00	MSFT	Stock	283.85	285.0	283.0	283.33	16630.0
2023-03-31 08:30:00	MSFT	Stock	283.15	284.4	283.05	284.3	55870.0
2023-03-31 09:00:00	MSFT	Stock	284.2	284.8489	283.5	283.95	44344.0
2023-03-31 09:30:00	MSFT	Stock	283.73	284.565	283.25	283.77	2234819.0
2023-03-31 10:00:00	MSFT	Stock	283.81	284.27	283.0	283.3501	1578757.0
2023-03-31 10:30:00	MSFT	Stock	283.37	284.07	283.22	283.89	1257204.0
2023-03-31 11:00:00	MSFT	Stock	283.9	284.66	283.78	284.13	1026888.0
2023-03-31 11:30:00	MSFT	Stock	284.125	285.35	284.0978	285.32	1126738.0
2023-03-31 12:00:00	MSFT	Stock	285.32	285.835	284.91	285.78	1155094.0
2023-03-31 12:30:00	MSFT	Stock	285.76	286.85	285.69	286.64	1330403.0
2023-03-31 13:00:00	MSFT	Stock	286.64	286.8299	286.2153	286.34	986835.0

> showing 50 of 101,450 rows — these rows as CSV

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