PREVIEW / stock_30min / 2021-09-10

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-10.parquet
  size:    2.2 MB
  rows:    108,607
  symbols: 2,701

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-10 04:00:00	AAPL	Stock	154.94	155.03	154.8	154.86	10033.0
2021-09-10 04:30:00	AAPL	Stock	154.95	154.99	154.9	154.91	2440.0
2021-09-10 05:00:00	AAPL	Stock	154.91	154.91	154.77	154.78	5484.0
2021-09-10 05:30:00	AAPL	Stock	154.78	154.9	154.78	154.83	4386.0
2021-09-10 06:00:00	AAPL	Stock	154.93	154.93	154.84	154.92	2704.0
2021-09-10 06:30:00	AAPL	Stock	154.8	154.9	154.75	154.9	5424.0
2021-09-10 07:00:00	AAPL	Stock	154.9	154.95	154.65	154.86	64649.0
2021-09-10 07:30:00	AAPL	Stock	154.88	154.98	154.82	154.97	48199.0
2021-09-10 08:00:00	AAPL	Stock	154.76	155.08	154.455	154.95	147737.0
2021-09-10 08:30:00	AAPL	Stock	154.95	155.0	154.845	154.88	93950.0
2021-09-10 09:00:00	AAPL	Stock	154.88	155.09	154.76	155.01	122268.0
2021-09-10 09:30:00	AAPL	Stock	155.02	155.48	154.88	155.3499	9117273.0
2021-09-10 10:00:00	AAPL	Stock	155.355	155.43	154.68	154.78	4524195.0
2021-09-10 10:30:00	AAPL	Stock	154.78	154.78	153.91	154.345	5086478.0
2021-09-10 11:00:00	AAPL	Stock	154.345	154.39	150.48	150.5	16715905.0
2021-09-10 11:30:00	AAPL	Stock	150.51	151.7	148.7	149.21	24143442.0
2021-09-10 12:00:00	AAPL	Stock	149.2009	150.48	148.92	150.04	12444771.0
2021-09-10 12:30:00	AAPL	Stock	150.0401	150.8038	149.84	150.26	9159303.0
2021-09-10 13:00:00	AAPL	Stock	150.28	150.77	150.155	150.3199	6001699.0
2021-09-10 13:30:00	AAPL	Stock	150.3259	150.64	149.875	149.985	4704240.0
2021-09-10 14:00:00	AAPL	Stock	149.9801	150.258	149.81	149.8199	4185836.0
2021-09-10 14:30:00	AAPL	Stock	149.81	150.07	149.51	149.8784	4392669.0
2021-09-10 15:00:00	AAPL	Stock	149.88	149.94	149.05	149.1101	5512021.0
2021-09-10 15:30:00	AAPL	Stock	149.11	149.24	148.74	149.0	11747953.0
2021-09-10 16:00:00	AAPL	Stock	148.97	149.04	148.95	148.99	5912229.0
2021-09-10 16:30:00	AAPL	Stock	148.98	149.0	148.83	148.98	92770.0
2021-09-10 17:00:00	AAPL	Stock	148.99	149.05	148.97	149.02	148118.0
2021-09-10 17:30:00	AAPL	Stock	149.05	149.15	149.05	149.15	62248.0
2021-09-10 18:00:00	AAPL	Stock	149.15	149.15	148.95	148.96	52123.0
2021-09-10 18:30:00	AAPL	Stock	148.97	148.98	148.88	148.88	55462.0
2021-09-10 19:00:00	AAPL	Stock	148.89	148.91	148.7	148.7501	41421.0
2021-09-10 19:30:00	AAPL	Stock	148.75	148.77	148.65	148.67	56888.0
2021-09-10 04:00:00	MSFT	Stock	298.06	298.38	298.06	298.38	701.0
2021-09-10 04:30:00	MSFT	Stock	298.55	298.55	298.55	298.55	100.0
2021-09-10 05:00:00	MSFT	Stock	298.34	298.4	298.34	298.4	440.0
2021-09-10 05:30:00	MSFT	Stock	298.34	298.34	298.33	298.33	571.0
2021-09-10 06:00:00	MSFT	Stock	298.04	298.15	298.04	298.15	513.0
2021-09-10 06:30:00	MSFT	Stock	298.21	298.48	298.01	298.48	994.0
2021-09-10 07:00:00	MSFT	Stock	298.39	298.5	298.2	298.4	6777.0
2021-09-10 07:30:00	MSFT	Stock	298.35	298.46	298.26	298.31	2648.0
2021-09-10 08:00:00	MSFT	Stock	298.2	298.6699	297.993	298.35	32715.0
2021-09-10 08:30:00	MSFT	Stock	298.4	298.55	298.17	298.5	7956.0
2021-09-10 09:00:00	MSFT	Stock	298.32	299.0	298.2	298.32	22841.0
2021-09-10 09:30:00	MSFT	Stock	298.52	299.0894	297.57	297.785	1409491.0
2021-09-10 10:00:00	MSFT	Stock	297.77	297.8	296.4	297.2	1133663.0
2021-09-10 10:30:00	MSFT	Stock	297.2	297.5999	296.6	297.3594	919397.0
2021-09-10 11:00:00	MSFT	Stock	297.36	297.54	296.64	297.0656	596204.0
2021-09-10 11:30:00	MSFT	Stock	297.045	298.1199	297.04	297.94	574283.0
2021-09-10 12:00:00	MSFT	Stock	297.98	298.96	297.78	298.93	635110.0
2021-09-10 12:30:00	MSFT	Stock	298.94	299.92	298.94	299.56	954473.0

> showing 50 of 108,607 rows — these rows as CSV

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