PREVIEW / stock_30min / 2022-10-21

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-10-21.parquet
  size:    2.1 MB
  rows:    101,812
  symbols: 2,157

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-10-21 04:00:00	AAPL	Stock	142.79	142.79	142.16	142.28	21714.0
2022-10-21 04:30:00	AAPL	Stock	142.28	142.32	142.03	142.15	14493.0
2022-10-21 05:00:00	AAPL	Stock	142.2	142.29	141.85	142.09	24729.0
2022-10-21 05:30:00	AAPL	Stock	142.12	142.26	142.0	142.17	6560.0
2022-10-21 06:00:00	AAPL	Stock	142.03	142.18	142.0	142.0	10897.0
2022-10-21 06:30:00	AAPL	Stock	142.04	142.07	142.03	142.03	835.0
2022-10-21 07:00:00	AAPL	Stock	142.24	142.48	142.04	142.33	19482.0
2022-10-21 07:30:00	AAPL	Stock	142.46	142.5	141.86	141.88	53029.0
2022-10-21 08:00:00	AAPL	Stock	142.7	143.39	141.57	141.8	151565.0
2022-10-21 08:30:00	AAPL	Stock	141.75	142.35	141.63	142.29	95839.0
2022-10-21 09:00:00	AAPL	Stock	142.27	143.7	142.27	143.02	442245.0
2022-10-21 09:30:00	AAPL	Stock	142.87	144.9	142.649	144.8898	13222517.0
2022-10-21 10:00:00	AAPL	Stock	144.8892	145.34	144.38	144.5608	5395722.0
2022-10-21 10:30:00	AAPL	Stock	144.575	145.13	144.0101	144.1	4971479.0
2022-10-21 11:00:00	AAPL	Stock	144.1	144.41	143.55	144.25	4201586.0
2022-10-21 11:30:00	AAPL	Stock	144.2501	145.6	144.23	145.59	4453955.0
2022-10-21 12:00:00	AAPL	Stock	145.6	146.1	145.02	145.07	4461543.0
2022-10-21 12:30:00	AAPL	Stock	145.075	146.04	145.06	145.775	3044506.0
2022-10-21 13:00:00	AAPL	Stock	145.78	146.21	145.63	145.8655	2954428.0
2022-10-21 13:30:00	AAPL	Stock	145.87	146.285	145.77	146.24	2651532.0
2022-10-21 14:00:00	AAPL	Stock	146.25	146.52	145.94	146.155	3084388.0
2022-10-21 14:30:00	AAPL	Stock	146.15	146.65	146.06	146.65	2953433.0
2022-10-21 15:00:00	AAPL	Stock	146.65	147.8479	146.6	147.82	6653745.0
2022-10-21 15:30:00	AAPL	Stock	147.8201	147.83	147.24	147.27	8505420.0
2022-10-21 16:00:00	AAPL	Stock	147.335	147.62	147.265	147.42	7398210.0
2022-10-21 16:30:00	AAPL	Stock	147.44	147.6399	147.27	147.54	142779.0
2022-10-21 17:00:00	AAPL	Stock	147.52	147.64	147.27	147.64	445193.0
2022-10-21 17:30:00	AAPL	Stock	147.58	147.67	147.58	147.59	9710.0
2022-10-21 18:00:00	AAPL	Stock	147.63	147.65	147.58	147.64	12850.0
2022-10-21 18:30:00	AAPL	Stock	147.6	147.64	147.56	147.57	23395.0
2022-10-21 19:00:00	AAPL	Stock	147.63	147.74	147.61	147.73	9776.0
2022-10-21 19:30:00	AAPL	Stock	147.7399	147.75	147.58	147.58	26793.0
2022-10-21 04:00:00	MSFT	Stock	234.67	234.67	234.31	234.6	1421.0
2022-10-21 04:30:00	MSFT	Stock	234.2	234.2	234.04	234.04	400.0
2022-10-21 05:00:00	MSFT	Stock	234.0	234.23	233.83	233.83	519.0
2022-10-21 05:30:00	MSFT	Stock	234.0	234.0	234.0	234.0	190.0
2022-10-21 06:00:00	MSFT	Stock	234.18	234.18	234.18	234.18	300.0
2022-10-21 06:30:00	MSFT	Stock	233.99	233.99	233.99	233.99	390.0
2022-10-21 07:00:00	MSFT	Stock	234.26	234.91	234.18	234.91	4649.0
2022-10-21 07:30:00	MSFT	Stock	234.8	234.8	234.13	234.46	1204.0
2022-10-21 08:00:00	MSFT	Stock	234.37	236.15	233.36	233.5	37499.0
2022-10-21 08:30:00	MSFT	Stock	233.36	234.54	233.18	234.54	7537.0
2022-10-21 09:00:00	MSFT	Stock	234.68	237.0	234.05	234.81	126797.0
2022-10-21 09:30:00	MSFT	Stock	234.75	238.0	234.5	237.99	4059447.0
2022-10-21 10:00:00	MSFT	Stock	238.01	238.75	236.8	236.935	1086298.0
2022-10-21 10:30:00	MSFT	Stock	236.9499	237.7	235.9	235.965	933424.0
2022-10-21 11:00:00	MSFT	Stock	235.9699	236.8	235.11	236.48	764955.0
2022-10-21 11:30:00	MSFT	Stock	236.5205	238.99	236.28	238.99	822535.0
2022-10-21 12:00:00	MSFT	Stock	238.98	239.76	237.91	238.0581	802088.0
2022-10-21 12:30:00	MSFT	Stock	238.05	239.82	237.915	239.18	585589.0

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

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