PREVIEW / stock_30min / 2023-03-14

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-14.parquet
  size:    2.1 MB
  rows:    104,436
  symbols: 1,773

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-14 04:00:00	AAPL	Stock	150.95	150.98	150.67	150.91	5122.0
2023-03-14 04:30:00	AAPL	Stock	150.94	151.32	150.92	151.07	10004.0
2023-03-14 05:00:00	AAPL	Stock	151.08	151.08	150.82	150.96	7287.0
2023-03-14 05:30:00	AAPL	Stock	151.03	151.18	150.95	151.0	5226.0
2023-03-14 06:00:00	AAPL	Stock	150.98	151.15	150.92	151.14	8499.0
2023-03-14 06:30:00	AAPL	Stock	151.1	151.14	150.99	151.14	4801.0
2023-03-14 07:00:00	AAPL	Stock	151.14	151.8	151.14	151.65	14210.0
2023-03-14 07:30:00	AAPL	Stock	151.66	151.74	151.52	151.56	14315.0
2023-03-14 08:00:00	AAPL	Stock	151.18	151.7994	150.094	151.64	87852.0
2023-03-14 08:30:00	AAPL	Stock	151.57	152.68	150.0	152.19	324558.0
2023-03-14 09:00:00	AAPL	Stock	152.16	152.7	150.99	151.27	347922.0
2023-03-14 09:30:00	AAPL	Stock	151.28	152.79	151.18	152.5399	6680286.0
2023-03-14 10:00:00	AAPL	Stock	152.52	153.03	152.188	152.78	3635815.0
2023-03-14 10:30:00	AAPL	Stock	152.77	153.2	152.61	152.65	3194102.0
2023-03-14 11:00:00	AAPL	Stock	152.64	153.32	152.62	153.07	2435075.0
2023-03-14 11:30:00	AAPL	Stock	153.06	153.4	152.6601	152.68	2732021.0
2023-03-14 12:00:00	AAPL	Stock	152.675	153.0687	152.5013	152.71	2513396.0
2023-03-14 12:30:00	AAPL	Stock	152.705	152.905	152.3	152.56	2354026.0
2023-03-14 13:00:00	AAPL	Stock	152.5699	152.8015	151.23	151.815	3549363.0
2023-03-14 13:30:00	AAPL	Stock	151.81	152.16	150.52	150.9833	4867703.0
2023-03-14 14:00:00	AAPL	Stock	150.98	151.45	150.43	151.3634	3315363.0
2023-03-14 14:30:00	AAPL	Stock	151.36	151.64	150.94	151.01	2503957.0
2023-03-14 15:00:00	AAPL	Stock	151.0125	151.24	150.1	150.865	3635787.0
2023-03-14 15:30:00	AAPL	Stock	150.86	152.81	150.69	152.55	8990901.0
2023-03-14 16:00:00	AAPL	Stock	152.5	152.69	152.445	152.6	12518042.0
2023-03-14 16:30:00	AAPL	Stock	152.6	152.82	152.57	152.78	164267.0
2023-03-14 17:00:00	AAPL	Stock	152.75	152.8099	152.6	152.7	11574.0
2023-03-14 17:30:00	AAPL	Stock	152.67	152.7	152.44	152.51	48394.0
2023-03-14 18:00:00	AAPL	Stock	152.55	152.67	152.47	152.67	19015.0
2023-03-14 18:30:00	AAPL	Stock	152.66	152.66	152.51	152.58	15207.0
2023-03-14 19:00:00	AAPL	Stock	152.6	152.7	152.6	152.68	6804.0
2023-03-14 19:30:00	AAPL	Stock	152.74	152.77	152.62	152.77	16841.0
2023-03-14 04:00:00	MSFT	Stock	255.19	255.19	255.19	255.19	159.0
2023-03-14 04:30:00	MSFT	Stock	255.28	255.7	255.0	255.0	1923.0
2023-03-14 05:00:00	MSFT	Stock	255.03	255.17	255.03	255.17	880.0
2023-03-14 06:00:00	MSFT	Stock	255.0	255.1	254.58	255.1	2914.0
2023-03-14 06:30:00	MSFT	Stock	254.95	255.0	254.89	255.0	1306.0
2023-03-14 07:00:00	MSFT	Stock	254.99	255.7	254.99	255.57	6380.0
2023-03-14 07:30:00	MSFT	Stock	255.6	256.37	255.43	255.43	10992.0
2023-03-14 08:00:00	MSFT	Stock	255.22	256.39	253.69	254.85	27084.0
2023-03-14 08:30:00	MSFT	Stock	254.59	256.92	251.65	255.99	90051.0
2023-03-14 09:00:00	MSFT	Stock	256.24	257.1	255.0	256.7	57781.0
2023-03-14 09:30:00	MSFT	Stock	256.91	258.49	255.86	256.735	2788087.0
2023-03-14 10:00:00	MSFT	Stock	256.8	258.15	256.68	258.03	1310223.0
2023-03-14 10:30:00	MSFT	Stock	257.98	258.3467	257.58	257.9	1502141.0
2023-03-14 11:00:00	MSFT	Stock	257.91	259.97	257.9	259.81	1445289.0
2023-03-14 11:30:00	MSFT	Stock	259.82	260.33	259.63	260.025	1239951.0
2023-03-14 12:00:00	MSFT	Stock	260.0	260.11	259.07	259.77	1133310.0
2023-03-14 12:30:00	MSFT	Stock	259.78	260.1754	259.33	259.66	884378.0
2023-03-14 13:00:00	MSFT	Stock	259.7	259.91	258.01	258.96	1250273.0

> showing 50 of 104,436 rows — these rows as CSV

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