PREVIEW / stock_30min / 2021-04-07

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-07.parquet
  size:    2.2 MB
  rows:    111,779
  symbols: 2,955

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-04-07 04:00:00	AAPL	Stock	126.51	126.52	126.22	126.22	3152.0
2021-04-07 04:30:00	AAPL	Stock	126.28	126.35	126.28	126.3	2816.0
2021-04-07 05:00:00	AAPL	Stock	126.35	126.48	126.29	126.38	7333.0
2021-04-07 05:30:00	AAPL	Stock	126.31	126.31	126.19	126.27	4521.0
2021-04-07 06:00:00	AAPL	Stock	126.22	126.5	126.21	126.36	3157.0
2021-04-07 06:30:00	AAPL	Stock	126.36	126.45	126.35	126.4	10185.0
2021-04-07 07:00:00	AAPL	Stock	126.36	126.5	126.2	126.2	55937.0
2021-04-07 07:30:00	AAPL	Stock	126.26	126.5	126.25	126.3	52749.0
2021-04-07 08:00:00	AAPL	Stock	126.4694	126.525	126.21	126.3	165344.0
2021-04-07 08:30:00	AAPL	Stock	126.28	126.35	125.86	125.9	145843.0
2021-04-07 09:00:00	AAPL	Stock	125.9	126.04	125.81	125.82	170486.0
2021-04-07 09:30:00	AAPL	Stock	125.82	126.21	125.14	126.12	9799683.0
2021-04-07 10:00:00	AAPL	Stock	126.12	127.24	126.04	127.1378	7484509.0
2021-04-07 10:30:00	AAPL	Stock	127.14	127.24	126.77	126.89	4498363.0
2021-04-07 11:00:00	AAPL	Stock	126.9	127.47	126.9	127.2215	5862804.0
2021-04-07 11:30:00	AAPL	Stock	127.23	127.3202	126.75	127.3199	4354028.0
2021-04-07 12:00:00	AAPL	Stock	127.31	127.48	127.12	127.1513	4629448.0
2021-04-07 12:30:00	AAPL	Stock	127.155	127.35	127.03	127.09	2851212.0
2021-04-07 13:00:00	AAPL	Stock	127.0864	127.25	126.8528	127.0501	3601105.0
2021-04-07 13:30:00	AAPL	Stock	127.05	127.3	126.95	127.2401	2767087.0
2021-04-07 14:00:00	AAPL	Stock	127.2499	127.78	127.24	127.7399	5286028.0
2021-04-07 14:30:00	AAPL	Stock	127.73	127.75	127.5	127.58	3130838.0
2021-04-07 15:00:00	AAPL	Stock	127.58	127.8	127.21	127.3399	4933444.0
2021-04-07 15:30:00	AAPL	Stock	127.33	127.92	127.2693	127.91	7887799.0
2021-04-07 16:00:00	AAPL	Stock	127.9	128.0	127.474	127.96	5214801.0
2021-04-07 16:30:00	AAPL	Stock	127.96	128.12	127.91	128.1	116580.0
2021-04-07 17:00:00	AAPL	Stock	128.11	128.2	128.09	128.14	75932.0
2021-04-07 17:30:00	AAPL	Stock	128.12	128.14	128.03	128.12	46624.0
2021-04-07 18:00:00	AAPL	Stock	128.12	128.25	128.08	128.22	65390.0
2021-04-07 18:30:00	AAPL	Stock	128.22	128.29	128.21	128.22	55018.0
2021-04-07 19:00:00	AAPL	Stock	128.22	128.24	128.09	128.09	22514.0
2021-04-07 19:30:00	AAPL	Stock	128.11	128.4	128.0	128.4	108639.0
2021-04-07 04:30:00	MSFT	Stock	248.48	248.48	248.45	248.45	841.0
2021-04-07 05:00:00	MSFT	Stock	248.45	248.45	248.45	248.45	200.0
2021-04-07 05:30:00	MSFT	Stock	248.31	248.31	248.3	248.3	532.0
2021-04-07 06:00:00	MSFT	Stock	248.41	248.41	248.41	248.41	250.0
2021-04-07 06:30:00	MSFT	Stock	248.5	248.5	248.11	248.11	1030.0
2021-04-07 07:00:00	MSFT	Stock	248.12	248.41	248.0	248.01	8246.0
2021-04-07 07:30:00	MSFT	Stock	248.12	248.22	247.84	247.98	4092.0
2021-04-07 08:00:00	MSFT	Stock	248.3	248.4	247.78	248.07	5661.0
2021-04-07 08:30:00	MSFT	Stock	247.83	247.83	247.35	247.35	7331.0
2021-04-07 09:00:00	MSFT	Stock	247.39	248.2	247.39	247.88	18416.0
2021-04-07 09:30:00	MSFT	Stock	247.81	249.09	247.19	248.71	1796952.0
2021-04-07 10:00:00	MSFT	Stock	248.695	249.89	248.51	249.79	1353755.0
2021-04-07 10:30:00	MSFT	Stock	249.79	250.83	249.384	250.51	2098343.0
2021-04-07 11:00:00	MSFT	Stock	250.53	250.93	249.914	250.04	1262468.0
2021-04-07 11:30:00	MSFT	Stock	250.03	250.39	249.6	250.07	1213183.0
2021-04-07 12:00:00	MSFT	Stock	250.07	250.42	249.75	249.83	835331.0
2021-04-07 12:30:00	MSFT	Stock	249.83	250.05	249.69	249.8371	574728.0
2021-04-07 13:00:00	MSFT	Stock	249.82	249.96	249.4	249.62	600960.0

> showing 50 of 111,779 rows — these rows as CSV

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