PREVIEW / stock_30min / 2022-06-23

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-23.parquet
  size:    2.1 MB
  rows:    105,963
  symbols: 2,320

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
2022-06-23 04:00:00	AAPL	Stock	134.21	135.95	134.21	135.66	31658.0
2022-06-23 04:30:00	AAPL	Stock	135.7	135.78	135.58	135.72	12959.0
2022-06-23 05:00:00	AAPL	Stock	135.76	136.14	135.75	135.81	10761.0
2022-06-23 05:30:00	AAPL	Stock	135.81	136.3	135.78	136.3	4850.0
2022-06-23 06:00:00	AAPL	Stock	136.23	136.71	136.23	136.55	10056.0
2022-06-23 06:30:00	AAPL	Stock	136.55	136.95	136.38	136.76	16084.0
2022-06-23 07:00:00	AAPL	Stock	136.77	136.94	136.35	136.94	102946.0
2022-06-23 07:30:00	AAPL	Stock	136.81	136.85	136.42	136.6	36359.0
2022-06-23 08:00:00	AAPL	Stock	136.5	136.9	134.65	136.2399	276799.0
2022-06-23 08:30:00	AAPL	Stock	136.2	136.3896	136.02	136.32	218900.0
2022-06-23 09:00:00	AAPL	Stock	136.27	136.99	136.27	136.83	231107.0
2022-06-23 09:30:00	AAPL	Stock	136.85	137.45	135.63	136.62	9487894.0
2022-06-23 10:00:00	AAPL	Stock	136.61	137.3	136.42	136.65	5483328.0
2022-06-23 10:30:00	AAPL	Stock	136.66	137.77	136.5	137.68	5230878.0
2022-06-23 11:00:00	AAPL	Stock	137.67	138.26	137.41	137.8	4465515.0
2022-06-23 11:30:00	AAPL	Stock	137.8094	137.97	136.9201	137.0901	3347684.0
2022-06-23 12:00:00	AAPL	Stock	137.095	137.145	136.43	136.79	3320339.0
2022-06-23 12:30:00	AAPL	Stock	136.78	136.9099	136.12	136.415	2499381.0
2022-06-23 13:00:00	AAPL	Stock	136.41	136.7	136.04	136.43	2567228.0
2022-06-23 13:30:00	AAPL	Stock	136.43	137.03	136.27	137.0041	2520757.0
2022-06-23 14:00:00	AAPL	Stock	137.005	137.39	136.89	137.2999	2693942.0
2022-06-23 14:30:00	AAPL	Stock	137.29	137.725	137.26	137.63	2462527.0
2022-06-23 15:00:00	AAPL	Stock	137.63	138.045	137.36	137.9	3257688.0
2022-06-23 15:30:00	AAPL	Stock	137.905	138.59	137.9	138.25	6906595.0
2022-06-23 16:00:00	AAPL	Stock	138.24	138.35	137.99	138.19	5983756.0
2022-06-23 16:30:00	AAPL	Stock	138.19	138.19	137.71	137.89	51063.0
2022-06-23 17:00:00	AAPL	Stock	137.85	138.01	137.81	137.87	27601.0
2022-06-23 17:30:00	AAPL	Stock	137.9	137.98	137.7904	137.9	24109.0
2022-06-23 18:00:00	AAPL	Stock	137.85	138.17	137.85	137.95	31459.0
2022-06-23 18:30:00	AAPL	Stock	137.95	138.13	137.95	138.1	21136.0
2022-06-23 19:00:00	AAPL	Stock	138.06	138.18	138.06	138.15	18809.0
2022-06-23 19:30:00	AAPL	Stock	138.15	138.25	138.02	138.1	29021.0
2022-06-23 04:00:00	MSFT	Stock	251.53	255.0	251.45	254.0	12226.0
2022-06-23 04:30:00	MSFT	Stock	254.0	254.03	253.88	253.91	15352.0
2022-06-23 05:00:00	MSFT	Stock	254.24	254.78	254.24	254.5	2861.0
2022-06-23 05:30:00	MSFT	Stock	254.5	255.3	254.5	255.3	1399.0
2022-06-23 06:00:00	MSFT	Stock	255.2	255.3	254.91	255.3	1833.0
2022-06-23 06:30:00	MSFT	Stock	255.29	256.54	255.29	256.5	1691.0
2022-06-23 07:00:00	MSFT	Stock	256.02	256.5	255.5	256.5	14117.0
2022-06-23 07:30:00	MSFT	Stock	255.94	256.25	255.75	256.25	1541.0
2022-06-23 08:00:00	MSFT	Stock	255.938	256.19	251.82	254.75	18438.0
2022-06-23 08:30:00	MSFT	Stock	254.56	254.95	253.98	254.9245	13888.0
2022-06-23 09:00:00	MSFT	Stock	254.83	255.85	254.52	255.84	14767.0
2022-06-23 09:30:00	MSFT	Stock	255.57	256.35	253.63	256.2553	2079503.0
2022-06-23 10:00:00	MSFT	Stock	256.23	256.82	254.74	256.0939	1014907.0
2022-06-23 10:30:00	MSFT	Stock	256.11	258.49	256.1	258.3876	1209286.0
2022-06-23 11:00:00	MSFT	Stock	258.38	258.42	257.101	257.49	923204.0
2022-06-23 11:30:00	MSFT	Stock	257.51	257.73	256.37	256.44	748409.0
2022-06-23 12:00:00	MSFT	Stock	256.46	256.6578	255.3302	256.31	952134.0
2022-06-23 12:30:00	MSFT	Stock	256.31	256.54	254.89	255.37	795762.0

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

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