PREVIEW / stock_30min / 2022-04-07

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-07.parquet
  size:    2.2 MB
  rows:    106,397
  symbols: 2,457

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-04-07 04:00:00	AAPL	Stock	172.02	172.2	171.55	172.15	10763.0
2022-04-07 04:30:00	AAPL	Stock	172.1	172.36	171.79	172.36	6849.0
2022-04-07 05:00:00	AAPL	Stock	172.33	172.55	172.0	172.25	7074.0
2022-04-07 05:30:00	AAPL	Stock	172.4	172.48	172.3	172.43	4584.0
2022-04-07 06:00:00	AAPL	Stock	172.43	172.54	172.41	172.49	11389.0
2022-04-07 06:30:00	AAPL	Stock	172.44	172.44	172.22	172.22	6888.0
2022-04-07 07:00:00	AAPL	Stock	172.22	172.62	172.03	172.11	60832.0
2022-04-07 07:30:00	AAPL	Stock	172.18	172.23	171.95	172.17	66313.0
2022-04-07 08:00:00	AAPL	Stock	172.12	172.7154	170.98	171.49	182077.0
2022-04-07 08:30:00	AAPL	Stock	171.49	171.8499	171.18	171.22	213412.0
2022-04-07 09:00:00	AAPL	Stock	171.23	171.45	170.89	171.17	251356.0
2022-04-07 09:30:00	AAPL	Stock	171.2	172.69	171.03	172.46	8206683.0
2022-04-07 10:00:00	AAPL	Stock	172.45	173.14	171.9	172.08	5681749.0
2022-04-07 10:30:00	AAPL	Stock	172.085	172.39	171.1401	171.42	4441638.0
2022-04-07 11:00:00	AAPL	Stock	171.38	171.7963	170.62	170.86	3369670.0
2022-04-07 11:30:00	AAPL	Stock	170.86	171.0799	170.405	170.685	3297535.0
2022-04-07 12:00:00	AAPL	Stock	170.6901	171.535	170.63	170.9	3039294.0
2022-04-07 12:30:00	AAPL	Stock	170.89	170.94	169.85	170.285	3874131.0
2022-04-07 13:00:00	AAPL	Stock	170.28	171.3653	170.22	171.19	3214493.0
2022-04-07 13:30:00	AAPL	Stock	171.195	171.74	170.8	171.67	2854456.0
2022-04-07 14:00:00	AAPL	Stock	171.66	172.255	171.41	171.68	3072220.0
2022-04-07 14:30:00	AAPL	Stock	171.66	172.77	171.49	172.66	3288119.0
2022-04-07 15:00:00	AAPL	Stock	172.65	173.18	172.56	172.6522	4088085.0
2022-04-07 15:30:00	AAPL	Stock	172.66	173.36	171.88	172.2675	8087199.0
2022-04-07 16:00:00	AAPL	Stock	172.2475	172.38	171.6992	171.72	6753894.0
2022-04-07 16:30:00	AAPL	Stock	171.75	172.14	171.71	171.96	40946.0
2022-04-07 17:00:00	AAPL	Stock	171.92	171.99	171.85	171.9505	6742.0
2022-04-07 17:30:00	AAPL	Stock	171.95	172.1	171.91	172.05	8259.0
2022-04-07 18:00:00	AAPL	Stock	172.03	172.05	171.9	171.9	18350.0
2022-04-07 18:30:00	AAPL	Stock	171.9	171.95	171.81	171.9	5121.0
2022-04-07 19:00:00	AAPL	Stock	171.89	172.12	171.85	172.12	21105.0
2022-04-07 19:30:00	AAPL	Stock	172.12	172.28	172.05	172.25	28253.0
2022-04-07 04:00:00	MSFT	Stock	299.42	300.27	299.42	300.1	3025.0
2022-04-07 04:30:00	MSFT	Stock	299.8	300.5	299.69	300.5	2265.0
2022-04-07 05:00:00	MSFT	Stock	300.7	300.7	300.7	300.7	1630.0
2022-04-07 05:30:00	MSFT	Stock	300.34	300.75	300.32	300.65	1349.0
2022-04-07 06:00:00	MSFT	Stock	300.65	300.76	300.51	300.6	8169.0
2022-04-07 06:30:00	MSFT	Stock	300.5	300.5	299.91	299.91	1909.0
2022-04-07 07:00:00	MSFT	Stock	300.0	300.75	299.48	299.89	12931.0
2022-04-07 07:30:00	MSFT	Stock	299.45	299.99	299.45	299.98	3373.0
2022-04-07 08:00:00	MSFT	Stock	300.0	300.8876	298.5	299.0	28041.0
2022-04-07 08:30:00	MSFT	Stock	299.18	299.18	297.75	298.06	9112.0
2022-04-07 09:00:00	MSFT	Stock	298.01	298.22	296.1	296.67	47320.0
2022-04-07 09:30:00	MSFT	Stock	296.66	301.71	296.35	301.39	3078950.0
2022-04-07 10:00:00	MSFT	Stock	301.36	302.64	300.61	301.8901	1960517.0
2022-04-07 10:30:00	MSFT	Stock	301.89	302.52	299.9359	301.57	1759518.0
2022-04-07 11:00:00	MSFT	Stock	301.5666	302.33	300.05	300.6	1237944.0
2022-04-07 11:30:00	MSFT	Stock	300.605	300.655	298.83	299.19	1267636.0
2022-04-07 12:00:00	MSFT	Stock	299.17	300.31	299.06	299.79	1064128.0
2022-04-07 12:30:00	MSFT	Stock	299.78	300.26	298.65	299.29	971334.0

> showing 50 of 106,397 rows — these rows as CSV

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