PREVIEW / stock_30min / 2021-01-27

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-27.parquet
  size:    2.4 MB
  rows:    124,637
  symbols: 2,731

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-01-27 04:00:00	AAPL	Stock	144.72	145.02	144.4	144.58	25929.0
2021-01-27 04:30:00	AAPL	Stock	144.6	145.08	144.6	145.04	20004.0
2021-01-27 05:00:00	AAPL	Stock	145.04	145.07	144.73	144.8	29457.0
2021-01-27 05:30:00	AAPL	Stock	144.8	144.8	144.38	144.59	109261.0
2021-01-27 06:00:00	AAPL	Stock	144.58	144.58	144.0	144.2	41617.0
2021-01-27 06:30:00	AAPL	Stock	144.2	144.28	143.21	143.32	93153.0
2021-01-27 07:00:00	AAPL	Stock	143.37	144.52	142.84	143.5	607455.0
2021-01-27 07:30:00	AAPL	Stock	143.54	143.69	142.88	142.88	389349.0
2021-01-27 08:00:00	AAPL	Stock	142.88	144.5	142.6	143.43	928525.0
2021-01-27 08:30:00	AAPL	Stock	143.43	143.56	142.86	143.39	363690.0
2021-01-27 09:00:00	AAPL	Stock	143.35	143.6	142.83	143.43	523386.0
2021-01-27 09:30:00	AAPL	Stock	143.43	143.82	141.43	142.78	12831790.0
2021-01-27 10:00:00	AAPL	Stock	142.78	144.3	142.77	143.46	8864644.0
2021-01-27 10:30:00	AAPL	Stock	143.443	143.95	142.8	143.33	6125137.0
2021-01-27 11:00:00	AAPL	Stock	143.33	143.37	142.445	142.57	4541729.0
2021-01-27 11:30:00	AAPL	Stock	142.57	142.88	141.84	141.927	6496135.0
2021-01-27 12:00:00	AAPL	Stock	141.92	143.54	141.775	143.32	5507966.0
2021-01-27 12:30:00	AAPL	Stock	143.301	143.4	142.72	143.33	4281865.0
2021-01-27 13:00:00	AAPL	Stock	143.33	143.43	142.92	143.27	4453591.0
2021-01-27 13:30:00	AAPL	Stock	143.27	143.65	143.04	143.395	4336508.0
2021-01-27 14:00:00	AAPL	Stock	143.4	143.99	142.7	142.92	6603246.0
2021-01-27 14:30:00	AAPL	Stock	142.91	142.99	141.26	141.76	9556877.0
2021-01-27 15:00:00	AAPL	Stock	141.766	142.4	141.4	141.66	6958710.0
2021-01-27 15:30:00	AAPL	Stock	141.64	142.89	140.41	142.53	14609316.0
2021-01-27 16:00:00	AAPL	Stock	142.42	142.65	137.0	141.65	13939493.0
2021-01-27 16:30:00	AAPL	Stock	141.7	145.0	137.62	141.71	4611157.0
2021-01-27 17:00:00	AAPL	Stock	141.71	143.15	138.38	138.57	2062936.0
2021-01-27 17:30:00	AAPL	Stock	138.6	139.8	137.0	138.0	1251608.0
2021-01-27 18:00:00	AAPL	Stock	138.0	138.85	137.39	137.79	542016.0
2021-01-27 18:30:00	AAPL	Stock	137.79	138.17	137.03	137.3	491768.0
2021-01-27 19:00:00	AAPL	Stock	137.32	142.06	136.75	137.54	411506.0
2021-01-27 19:30:00	AAPL	Stock	137.59	137.9	137.4	137.43	266863.0
2021-01-27 04:00:00	MSFT	Stock	240.0	240.4	238.88	240.4	45468.0
2021-01-27 04:30:00	MSFT	Stock	240.5	240.65	240.07	240.25	15197.0
2021-01-27 05:00:00	MSFT	Stock	240.25	240.9	240.23	240.8	12471.0
2021-01-27 05:30:00	MSFT	Stock	240.79	240.8	239.2	239.6	27191.0
2021-01-27 06:00:00	MSFT	Stock	239.39	239.69	237.85	239.32	40165.0
2021-01-27 06:30:00	MSFT	Stock	239.43	239.43	236.4	237.98	74161.0
2021-01-27 07:00:00	MSFT	Stock	237.98	238.14	234.9	236.23	255440.0
2021-01-27 07:30:00	MSFT	Stock	236.24	237.2	235.69	236.29	330651.0
2021-01-27 08:00:00	MSFT	Stock	236.28	241.68	235.55	236.12	577761.0
2021-01-27 08:30:00	MSFT	Stock	236.12	238.1	236.07	237.85	287361.0
2021-01-27 09:00:00	MSFT	Stock	237.82	238.25	236.15	238.11	296885.0
2021-01-27 09:30:00	MSFT	Stock	238.12	239.24	230.74	235.78	10293447.0
2021-01-27 10:00:00	MSFT	Stock	235.74	240.18	235.31	239.09	7380682.0
2021-01-27 10:30:00	MSFT	Stock	239.06	240.44	238.23	238.648	3277250.0
2021-01-27 11:00:00	MSFT	Stock	238.642	239.48	236.11	236.11	3159977.0
2021-01-27 11:30:00	MSFT	Stock	236.13	236.26	234.622	234.93	2934364.0
2021-01-27 12:00:00	MSFT	Stock	234.92	237.2	234.3	236.89	2074905.0
2021-01-27 12:30:00	MSFT	Stock	236.91	237.89	235.88	237.55	1502108.0

> showing 50 of 124,637 rows — these rows as CSV

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