PREVIEW / stock_30min / 2023-03-15

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-15.parquet
  size:    2.1 MB
  rows:    105,297
  symbols: 1,739

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-15 04:00:00	AAPL	Stock	152.87	152.98	152.46	152.73	7963.0
2023-03-15 04:30:00	AAPL	Stock	152.6	152.9	152.59	152.7	2705.0
2023-03-15 05:00:00	AAPL	Stock	152.71	152.71	152.12	152.12	8498.0
2023-03-15 05:30:00	AAPL	Stock	152.14	152.2	151.75	151.81	7625.0
2023-03-15 06:00:00	AAPL	Stock	151.93	151.93	151.0	151.0	24603.0
2023-03-15 06:30:00	AAPL	Stock	151.21	151.42	150.38	150.48	37997.0
2023-03-15 07:00:00	AAPL	Stock	150.58	151.05	150.5	150.73	65861.0
2023-03-15 07:30:00	AAPL	Stock	150.8	150.87	150.54	150.75	16270.0
2023-03-15 08:00:00	AAPL	Stock	150.77	152.94	150.48	150.74	150477.0
2023-03-15 08:30:00	AAPL	Stock	150.74	151.32	150.0	150.66	221672.0
2023-03-15 09:00:00	AAPL	Stock	150.65	151.3	150.42	151.24	191397.0
2023-03-15 09:30:00	AAPL	Stock	151.19	151.8	150.7003	151.21	7564538.0
2023-03-15 10:00:00	AAPL	Stock	151.22	151.6502	150.46	150.54	4731353.0
2023-03-15 10:30:00	AAPL	Stock	150.55	151.0	149.92	150.92	4630406.0
2023-03-15 11:00:00	AAPL	Stock	150.94	151.29	150.56	150.82	3598108.0
2023-03-15 11:30:00	AAPL	Stock	150.82	151.8484	150.67	151.17	3412158.0
2023-03-15 12:00:00	AAPL	Stock	151.16	151.35	150.435	150.81	2748483.0
2023-03-15 12:30:00	AAPL	Stock	150.81	151.23	150.4493	150.585	2326197.0
2023-03-15 13:00:00	AAPL	Stock	150.585	151.66	150.5	151.59	2799808.0
2023-03-15 13:30:00	AAPL	Stock	151.59	152.33	151.34	152.13	3667678.0
2023-03-15 14:00:00	AAPL	Stock	152.14	153.09	151.48	152.5	3458120.0
2023-03-15 14:30:00	AAPL	Stock	152.48	153.07	152.345	152.87	3667419.0
2023-03-15 15:00:00	AAPL	Stock	152.88	153.245	152.24	152.66	3822072.0
2023-03-15 15:30:00	AAPL	Stock	152.65	153.01	151.62	152.99	7126501.0
2023-03-15 16:00:00	AAPL	Stock	153.0	153.31	151.7075	152.9	11247426.0
2023-03-15 16:30:00	AAPL	Stock	152.91	152.99	152.71	152.8	61733.0
2023-03-15 17:00:00	AAPL	Stock	152.79	152.84	152.75	152.8	13621.0
2023-03-15 17:30:00	AAPL	Stock	152.79	152.8	152.66	152.77	14077.0
2023-03-15 18:00:00	AAPL	Stock	152.77	152.85	152.67	152.85	6849.0
2023-03-15 18:30:00	AAPL	Stock	152.86	152.95	152.61	152.73	25896.0
2023-03-15 19:00:00	AAPL	Stock	152.75	152.93	152.75	152.85	8503.0
2023-03-15 19:30:00	AAPL	Stock	152.8	152.94	152.67	152.7	18595.0
2023-03-15 04:00:00	MSFT	Stock	261.3	261.61	260.89	261.35	4903.0
2023-03-15 04:30:00	MSFT	Stock	261.89	261.89	261.49	261.49	2140.0
2023-03-15 05:00:00	MSFT	Stock	261.19	261.33	260.5	260.5	4571.0
2023-03-15 05:30:00	MSFT	Stock	260.2	260.2	259.06	259.25	7552.0
2023-03-15 06:00:00	MSFT	Stock	259.3	259.34	258.23	258.25	6945.0
2023-03-15 06:30:00	MSFT	Stock	258.26	259.1	256.75	257.4	17492.0
2023-03-15 07:00:00	MSFT	Stock	257.4	258.13	257.21	257.31	27751.0
2023-03-15 07:30:00	MSFT	Stock	257.01	258.2	256.0	258.2	16506.0
2023-03-15 08:00:00	MSFT	Stock	257.4381	261.0	256.181	257.4	40101.0
2023-03-15 08:30:00	MSFT	Stock	257.5	258.25	256.5	257.7289	40087.0
2023-03-15 09:00:00	MSFT	Stock	257.7	260.0	257.0824	259.93	69978.0
2023-03-15 09:30:00	MSFT	Stock	259.98	263.59	259.21	262.39	4418717.0
2023-03-15 10:00:00	MSFT	Stock	262.3	264.65	261.6	262.4	3089014.0
2023-03-15 10:30:00	MSFT	Stock	262.4	264.88	261.75	264.7549	2558451.0
2023-03-15 11:00:00	MSFT	Stock	264.77	264.79	263.26	263.8	2273978.0
2023-03-15 11:30:00	MSFT	Stock	263.79	264.5	263.21	264.09	1911134.0
2023-03-15 12:00:00	MSFT	Stock	264.11	264.31	261.42	261.95	1548630.0
2023-03-15 12:30:00	MSFT	Stock	261.94	262.64	261.16	261.88	1313179.0

> showing 50 of 105,297 rows — these rows as CSV

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