PREVIEW / stock_30min / 2021-09-13

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-13.parquet
  size:    2.2 MB
  rows:    110,182
  symbols: 2,722

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-09-13 04:00:00	AAPL	Stock	149.7	150.23	149.67	150.05	56772.0
2021-09-13 04:30:00	AAPL	Stock	150.07	150.1	149.85	149.92	21595.0
2021-09-13 05:00:00	AAPL	Stock	149.92	150.0	149.91	150.0	10218.0
2021-09-13 05:30:00	AAPL	Stock	150.0	150.25	150.0	150.22	20938.0
2021-09-13 06:00:00	AAPL	Stock	150.25	150.3	150.2	150.26	8444.0
2021-09-13 06:30:00	AAPL	Stock	150.32	150.55	150.32	150.4	25223.0
2021-09-13 07:00:00	AAPL	Stock	150.4	150.5	149.92	150.0	219301.0
2021-09-13 07:30:00	AAPL	Stock	150.0	150.36	149.95	150.29	111935.0
2021-09-13 08:00:00	AAPL	Stock	150.4	150.88	149.9101	150.59	410735.0
2021-09-13 08:30:00	AAPL	Stock	150.58	150.79	150.4	150.5	279718.0
2021-09-13 09:00:00	AAPL	Stock	150.5	150.67	150.26	150.65	490175.0
2021-09-13 09:30:00	AAPL	Stock	150.64	151.42	149.7	149.87	16329952.0
2021-09-13 10:00:00	AAPL	Stock	149.86	149.95	149.05	149.63	8396711.0
2021-09-13 10:30:00	AAPL	Stock	149.6399	150.245	149.305	150.059	6498756.0
2021-09-13 11:00:00	AAPL	Stock	150.06	150.405	149.66	150.06	4980458.0
2021-09-13 11:30:00	AAPL	Stock	150.05	150.2	149.45	149.49	3930391.0
2021-09-13 12:00:00	AAPL	Stock	149.49	150.0	149.39	149.77	3596894.0
2021-09-13 12:30:00	AAPL	Stock	149.77	150.1099	149.55	150.03	3047517.0
2021-09-13 13:00:00	AAPL	Stock	150.025	150.12	149.24	149.3	3495368.0
2021-09-13 13:30:00	AAPL	Stock	149.305	149.33	148.82	148.96	4308651.0
2021-09-13 14:00:00	AAPL	Stock	148.97	149.23	148.81	148.91	3655002.0
2021-09-13 14:30:00	AAPL	Stock	148.91	149.29	148.75	149.2715	3391279.0
2021-09-13 15:00:00	AAPL	Stock	149.275	149.59	148.8945	149.5799	5343499.0
2021-09-13 15:30:00	AAPL	Stock	149.575	149.62	149.065	149.62	6409601.0
2021-09-13 16:00:00	AAPL	Stock	149.6	149.75	148.9	149.67	9869844.0
2021-09-13 16:30:00	AAPL	Stock	149.65	149.76	149.65	149.75	55234.0
2021-09-13 17:00:00	AAPL	Stock	149.75	149.76	149.71	149.74	31309.0
2021-09-13 17:30:00	AAPL	Stock	149.75	149.76	149.71	149.74	28190.0
2021-09-13 18:00:00	AAPL	Stock	149.72	149.72	149.55	149.64	28196.0
2021-09-13 18:30:00	AAPL	Stock	149.7	149.74	149.54	149.56	34034.0
2021-09-13 19:00:00	AAPL	Stock	149.62	149.68	149.47	149.62	15510.0
2021-09-13 19:30:00	AAPL	Stock	149.6	149.67	149.51	149.53	50669.0
2021-09-13 04:00:00	MSFT	Stock	293.0	296.52	293.0	296.33	3431.0
2021-09-13 05:00:00	MSFT	Stock	297.17	297.17	297.17	297.17	100.0
2021-09-13 05:30:00	MSFT	Stock	296.71	296.8	296.7	296.8	350.0
2021-09-13 06:00:00	MSFT	Stock	296.66	296.66	296.66	296.66	242.0
2021-09-13 06:30:00	MSFT	Stock	296.95	297.1	296.95	297.0	1763.0
2021-09-13 07:00:00	MSFT	Stock	296.82	296.96	296.7	296.96	2058.0
2021-09-13 07:30:00	MSFT	Stock	296.9	297.04	296.81	297.04	4246.0
2021-09-13 08:00:00	MSFT	Stock	296.9907	297.24	296.449	297.23	19242.0
2021-09-13 08:30:00	MSFT	Stock	297.23	297.47	297.23	297.39	15379.0
2021-09-13 09:00:00	MSFT	Stock	297.43	297.6	297.15	297.58	18784.0
2021-09-13 09:30:00	MSFT	Stock	297.55	298.54	296.25	297.0401	1950372.0
2021-09-13 10:00:00	MSFT	Stock	297.04	297.1173	294.7	294.98	1453474.0
2021-09-13 10:30:00	MSFT	Stock	294.95	295.86	294.27	295.61	980789.0
2021-09-13 11:00:00	MSFT	Stock	295.61	296.0	294.1109	294.6123	885508.0
2021-09-13 11:30:00	MSFT	Stock	294.62	295.03	294.27	294.48	680994.0
2021-09-13 12:00:00	MSFT	Stock	294.48	295.44	294.08	295.2	518890.0
2021-09-13 12:30:00	MSFT	Stock	295.2	296.18	295.07	296.03	560473.0
2021-09-13 13:00:00	MSFT	Stock	296.03	296.38	295.875	296.0099	659573.0

> showing 50 of 110,182 rows — these rows as CSV

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