PREVIEW / stock_30min / 2021-06-30

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-30.parquet
  size:    2.3 MB
  rows:    114,424
  symbols: 2,961

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-06-30 04:00:00	AAPL	Stock	136.49	136.5	136.11	136.18	8262.0
2021-06-30 04:30:00	AAPL	Stock	136.2	136.28	136.13	136.13	7169.0
2021-06-30 05:00:00	AAPL	Stock	136.11	136.11	135.5	135.78	34460.0
2021-06-30 05:30:00	AAPL	Stock	135.6	135.84	135.5	135.84	4121.0
2021-06-30 06:00:00	AAPL	Stock	135.88	135.97	135.88	135.88	2587.0
2021-06-30 06:30:00	AAPL	Stock	135.87	135.93	135.8	135.8	3452.0
2021-06-30 07:00:00	AAPL	Stock	135.85	136.25	135.75	136.1	67199.0
2021-06-30 07:30:00	AAPL	Stock	136.101	136.19	136.03	136.11	22681.0
2021-06-30 08:00:00	AAPL	Stock	136.1201	136.33	135.9696	136.03	122836.0
2021-06-30 08:30:00	AAPL	Stock	136.04	136.17	136.03	136.12	70844.0
2021-06-30 09:00:00	AAPL	Stock	136.12	136.2846	135.81	136.135	99549.0
2021-06-30 09:30:00	AAPL	Stock	136.17	137.02	135.87	136.2	8644450.0
2021-06-30 10:00:00	AAPL	Stock	136.19	136.8	136.17	136.765	4024050.0
2021-06-30 10:30:00	AAPL	Stock	136.762	137.14	136.57	136.99	3690956.0
2021-06-30 11:00:00	AAPL	Stock	137.0	137.19	136.8	136.845	2526822.0
2021-06-30 11:30:00	AAPL	Stock	136.85	136.9588	136.635	136.7	2740083.0
2021-06-30 12:00:00	AAPL	Stock	136.7	136.93	136.47	136.5699	2487772.0
2021-06-30 12:30:00	AAPL	Stock	136.5659	136.8177	136.51	136.7093	1893869.0
2021-06-30 13:00:00	AAPL	Stock	136.705	136.86	136.6775	136.8374	1546815.0
2021-06-30 13:30:00	AAPL	Stock	136.835	137.05	136.81	136.985	1900020.0
2021-06-30 14:00:00	AAPL	Stock	136.99	137.0	136.725	136.95	1794316.0
2021-06-30 14:30:00	AAPL	Stock	136.94	137.04	136.87	136.92	1836637.0
2021-06-30 15:00:00	AAPL	Stock	136.915	137.27	136.91	137.23	2752551.0
2021-06-30 15:30:00	AAPL	Stock	137.235	137.41	136.85	136.92	9000286.0
2021-06-30 16:00:00	AAPL	Stock	136.92	137.2	136.9	136.95	9686318.0
2021-06-30 16:30:00	AAPL	Stock	136.95	137.01	136.92	136.93	43940.0
2021-06-30 17:00:00	AAPL	Stock	136.93	137.05	136.92	136.92	20857.0
2021-06-30 17:30:00	AAPL	Stock	136.93	137.03	136.92	137.02	7044.0
2021-06-30 18:00:00	AAPL	Stock	137.02	137.04	137.0	137.0	4907.0
2021-06-30 18:30:00	AAPL	Stock	137.04	137.08	137.0	137.08	8893.0
2021-06-30 19:00:00	AAPL	Stock	137.08	137.2	137.08	137.1	15316.0
2021-06-30 19:30:00	AAPL	Stock	137.1	137.18	137.01	137.1	30076.0
2021-06-30 04:00:00	MSFT	Stock	271.4	271.4	270.93	271.1	7758.0
2021-06-30 04:30:00	MSFT	Stock	271.19	271.19	270.8	270.8	2389.0
2021-06-30 05:00:00	MSFT	Stock	270.51	270.59	270.2	270.59	4381.0
2021-06-30 05:30:00	MSFT	Stock	270.62	270.7	270.6	270.7	534.0
2021-06-30 06:00:00	MSFT	Stock	270.74	270.95	270.74	270.85	1506.0
2021-06-30 06:30:00	MSFT	Stock	270.9	270.95	270.85	270.85	2542.0
2021-06-30 07:00:00	MSFT	Stock	270.79	271.1	270.75	271.0	5030.0
2021-06-30 07:30:00	MSFT	Stock	270.98	271.16	270.85	270.9	2492.0
2021-06-30 08:00:00	MSFT	Stock	270.8792	272.078	270.6	270.62	19376.0
2021-06-30 08:30:00	MSFT	Stock	270.7501	270.9699	270.7501	270.9	5430.0
2021-06-30 09:00:00	MSFT	Stock	270.92	271.0	270.18	270.3	23931.0
2021-06-30 09:30:00	MSFT	Stock	270.53	271.04	269.92	270.22	2109999.0
2021-06-30 10:00:00	MSFT	Stock	270.21	270.66	270.07	270.45	900981.0
2021-06-30 10:30:00	MSFT	Stock	270.47	271.2885	270.44	271.09	783756.0
2021-06-30 11:00:00	MSFT	Stock	271.09	271.3598	270.56	270.73	748421.0
2021-06-30 11:30:00	MSFT	Stock	270.74	270.81	270.23	270.27	539107.0
2021-06-30 12:00:00	MSFT	Stock	270.28	270.6	269.7	269.74	715468.0
2021-06-30 12:30:00	MSFT	Stock	269.74	270.42	269.6043	270.26	480056.0

> showing 50 of 114,424 rows — these rows as CSV

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