PREVIEW / stock_30min / 2022-02-16

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-02-16.parquet
  size:    2.1 MB
  rows:    105,918
  symbols: 2,538

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-02-16 04:00:00	AAPL	Stock	173.05	173.2	171.99	172.84	12833.0
2022-02-16 04:30:00	AAPL	Stock	172.84	172.89	172.64	172.7	3254.0
2022-02-16 05:00:00	AAPL	Stock	172.5	172.5	172.0	172.4	5871.0
2022-02-16 05:30:00	AAPL	Stock	172.27	172.54	172.27	172.54	1704.0
2022-02-16 06:00:00	AAPL	Stock	172.5	172.5	172.35	172.37	1088.0
2022-02-16 06:30:00	AAPL	Stock	172.42	172.7	172.41	172.7	2713.0
2022-02-16 07:00:00	AAPL	Stock	172.71	172.74	172.41	172.53	25016.0
2022-02-16 07:30:00	AAPL	Stock	172.46	172.51	171.95	172.0	44824.0
2022-02-16 08:00:00	AAPL	Stock	172.6899	173.221	171.95	172.3499	188093.0
2022-02-16 08:30:00	AAPL	Stock	172.25	172.56	171.88	172.06	245457.0
2022-02-16 09:00:00	AAPL	Stock	172.05	172.8612	171.55	171.79	249098.0
2022-02-16 09:30:00	AAPL	Stock	171.82	172.32	170.05	170.575	7421435.0
2022-02-16 10:00:00	AAPL	Stock	170.575	170.775	170.265	170.73	3582233.0
2022-02-16 10:30:00	AAPL	Stock	170.73	171.22	170.55	171.04	3033830.0
2022-02-16 11:00:00	AAPL	Stock	171.05	171.19	170.35	170.8699	2447479.0
2022-02-16 11:30:00	AAPL	Stock	170.8681	171.13	170.7399	171.105	1740396.0
2022-02-16 12:00:00	AAPL	Stock	171.1	171.41	170.82	170.8682	1911330.0
2022-02-16 12:30:00	AAPL	Stock	170.86	170.86	170.18	170.675	2261682.0
2022-02-16 13:00:00	AAPL	Stock	170.67	170.895	170.5721	170.87	1247104.0
2022-02-16 13:30:00	AAPL	Stock	170.87	170.89	170.545	170.78	1297475.0
2022-02-16 14:00:00	AAPL	Stock	170.7691	172.475	170.54	172.415	5129044.0
2022-02-16 14:30:00	AAPL	Stock	172.42	172.88	171.98	172.88	3509728.0
2022-02-16 15:00:00	AAPL	Stock	172.8721	173.34	172.78	173.14	3658468.0
2022-02-16 15:30:00	AAPL	Stock	173.14	173.19	172.31	172.55	5783740.0
2022-02-16 16:00:00	AAPL	Stock	172.55	172.63	172.0	172.35	5580892.0
2022-02-16 16:30:00	AAPL	Stock	172.3	172.55	172.04	172.13	41908.0
2022-02-16 17:00:00	AAPL	Stock	172.16	172.4199	172.16	172.4199	11307.0
2022-02-16 17:30:00	AAPL	Stock	172.4	172.45	172.23	172.3	14764.0
2022-02-16 18:00:00	AAPL	Stock	172.35	172.5	172.3	172.5	12171.0
2022-02-16 18:30:00	AAPL	Stock	172.5	172.55	172.09	172.12	16750.0
2022-02-16 19:00:00	AAPL	Stock	172.11	172.12	172.0	172.0	14811.0
2022-02-16 19:30:00	AAPL	Stock	172.05	172.3	172.03	172.17	15679.0
2022-02-16 04:00:00	MSFT	Stock	300.7	300.95	300.7	300.95	500.0
2022-02-16 04:30:00	MSFT	Stock	300.45	300.45	300.4	300.4	1229.0
2022-02-16 05:00:00	MSFT	Stock	299.86	300.84	299.86	300.0	2896.0
2022-02-16 05:30:00	MSFT	Stock	299.92	299.92	299.81	299.81	543.0
2022-02-16 06:00:00	MSFT	Stock	300.29	300.29	299.91	299.91	360.0
2022-02-16 07:00:00	MSFT	Stock	300.3	300.45	300.1	300.45	8033.0
2022-02-16 07:30:00	MSFT	Stock	300.06	300.06	299.0	299.2	10628.0
2022-02-16 08:00:00	MSFT	Stock	300.1014	300.4	299.0361	299.761	22110.0
2022-02-16 08:30:00	MSFT	Stock	299.81	300.5	298.41	298.775	15706.0
2022-02-16 09:00:00	MSFT	Stock	298.51	298.9	298.01	298.48	39915.0
2022-02-16 09:30:00	MSFT	Stock	298.47	298.66	293.73	294.0687	2341475.0
2022-02-16 10:00:00	MSFT	Stock	294.03	294.93	293.68	294.46	1386276.0
2022-02-16 10:30:00	MSFT	Stock	294.45	295.135	294.11	294.77	1123511.0
2022-02-16 11:00:00	MSFT	Stock	294.81	295.6	294.6	295.51	958476.0
2022-02-16 11:30:00	MSFT	Stock	295.5	296.74	294.97	296.7	957874.0
2022-02-16 12:00:00	MSFT	Stock	296.7	297.31	295.9	296.44	868403.0
2022-02-16 12:30:00	MSFT	Stock	296.42	296.4591	295.51	296.31	695564.0
2022-02-16 13:00:00	MSFT	Stock	296.29	296.75	295.845	296.645	512883.0

> showing 50 of 105,918 rows — these rows as CSV

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