PREVIEW / stock_30min / 2021-11-08

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-11-08.parquet
  size:    2.3 MB
  rows:    117,160
  symbols: 2,708

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
2021-11-08 04:00:00	AAPL	Stock	151.08	151.35	151.08	151.25	14634.0
2021-11-08 04:30:00	AAPL	Stock	151.2	151.25	151.1	151.12	3894.0
2021-11-08 05:00:00	AAPL	Stock	151.14	151.35	151.14	151.35	4727.0
2021-11-08 05:30:00	AAPL	Stock	151.38	151.38	151.28	151.28	2021.0
2021-11-08 06:00:00	AAPL	Stock	151.32	151.36	151.32	151.35	1458.0
2021-11-08 06:30:00	AAPL	Stock	151.35	151.58	151.3	151.57	14404.0
2021-11-08 07:00:00	AAPL	Stock	151.47	151.63	151.28	151.55	48064.0
2021-11-08 07:30:00	AAPL	Stock	151.55	151.59	151.3	151.31	37144.0
2021-11-08 08:00:00	AAPL	Stock	151.44	151.61	150.902	151.35	104799.0
2021-11-08 08:30:00	AAPL	Stock	151.35	151.35	151.12	151.23	67408.0
2021-11-08 09:00:00	AAPL	Stock	151.21	151.65	151.15	151.4	172967.0
2021-11-08 09:30:00	AAPL	Stock	151.4	151.57	150.7	150.9542	6649577.0
2021-11-08 10:00:00	AAPL	Stock	150.96	151.45	150.875	151.02	3547737.0
2021-11-08 10:30:00	AAPL	Stock	151.02	151.09	150.72	150.7602	2573018.0
2021-11-08 11:00:00	AAPL	Stock	150.76	150.889	150.515	150.6685	2482399.0
2021-11-08 11:30:00	AAPL	Stock	150.66	150.7	150.345	150.4102	1876538.0
2021-11-08 12:00:00	AAPL	Stock	150.41	150.45	150.16	150.45	2007843.0
2021-11-08 12:30:00	AAPL	Stock	150.445	150.61	150.34	150.59	1169929.0
2021-11-08 13:00:00	AAPL	Stock	150.585	151.01	150.53	150.88	1767420.0
2021-11-08 13:30:00	AAPL	Stock	150.88	150.95	150.585	150.5895	1238870.0
2021-11-08 14:00:00	AAPL	Stock	150.5819	150.8	150.52	150.525	1425714.0
2021-11-08 14:30:00	AAPL	Stock	150.525	150.675	150.51	150.665	1296532.0
2021-11-08 15:00:00	AAPL	Stock	150.665	150.665	150.42	150.475	1348801.0
2021-11-08 15:30:00	AAPL	Stock	150.48	150.63	150.31	150.45	3774062.0
2021-11-08 16:00:00	AAPL	Stock	150.45	150.46	150.33	150.36	5043800.0
2021-11-08 16:30:00	AAPL	Stock	150.38	150.44	150.36	150.4	31133.0
2021-11-08 17:00:00	AAPL	Stock	150.38	150.44	150.38	150.4	31371.0
2021-11-08 17:30:00	AAPL	Stock	150.38	150.41	150.32	150.33	16448.0
2021-11-08 18:00:00	AAPL	Stock	150.33	150.37	150.33	150.35	14367.0
2021-11-08 18:30:00	AAPL	Stock	150.36	150.38	150.28	150.28	12774.0
2021-11-08 19:00:00	AAPL	Stock	150.27	150.3	150.16	150.18	24229.0
2021-11-08 19:30:00	AAPL	Stock	150.16	150.18	149.75	149.85	97160.0
2021-11-08 04:00:00	MSFT	Stock	336.47	337.22	336.44	337.22	4404.0
2021-11-08 04:30:00	MSFT	Stock	336.78	336.8	336.7	336.79	1011.0
2021-11-08 05:00:00	MSFT	Stock	336.95	337.0	336.95	337.0	3547.0
2021-11-08 05:30:00	MSFT	Stock	337.23	337.29	337.17	337.29	1251.0
2021-11-08 06:30:00	MSFT	Stock	337.3	337.5	337.3	337.5	5068.0
2021-11-08 07:00:00	MSFT	Stock	337.33	337.33	336.9	336.9	8818.0
2021-11-08 07:30:00	MSFT	Stock	336.81	337.1	336.62	337.1	9413.0
2021-11-08 08:00:00	MSFT	Stock	336.8	337.44	336.55	337.23	8184.0
2021-11-08 08:30:00	MSFT	Stock	337.1	337.32	337.05	337.32	2962.0
2021-11-08 09:00:00	MSFT	Stock	337.16	337.37	337.08	337.3	13424.0
2021-11-08 09:30:00	MSFT	Stock	337.29	337.65	335.3	335.85	1620236.0
2021-11-08 10:00:00	MSFT	Stock	335.84	335.99	335.06	335.21	1064071.0
2021-11-08 10:30:00	MSFT	Stock	335.23	335.6921	334.68	335.34	1005132.0
2021-11-08 11:00:00	MSFT	Stock	335.34	335.52	334.71	335.0	850149.0
2021-11-08 11:30:00	MSFT	Stock	335.0199	335.185	334.69	334.91	567346.0
2021-11-08 12:00:00	MSFT	Stock	334.91	335.26	334.44	335.175	595926.0
2021-11-08 12:30:00	MSFT	Stock	335.18	335.35	334.67	335.23	500851.0
2021-11-08 13:00:00	MSFT	Stock	335.25	336.25	335.1043	335.83	635534.0

> showing 50 of 117,160 rows — these rows as CSV

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