PREVIEW / stock_30min / 2019-12-26

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-26.parquet
  size:    1.7 MB
  rows:    82,875
  symbols: 2,450

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
2019-12-26 04:00:00	AAPL	Stock	71.2225	71.2225	71.2225	71.2225	1860.0
2019-12-26 04:30:00	AAPL	Stock	71.2225	71.2225	71.2225	71.2225	400.0
2019-12-26 05:00:00	AAPL	Stock	71.2225	71.2225	71.2225	71.2225	400.0
2019-12-26 06:30:00	AAPL	Stock	71.2125	71.2125	71.18	71.18	4292.0
2019-12-26 07:00:00	AAPL	Stock	71.21	71.21	71.1525	71.175	12680.0
2019-12-26 07:30:00	AAPL	Stock	71.1875	71.2	71.18	71.1825	6928.0
2019-12-26 08:00:00	AAPL	Stock	71.188	71.22	71.1625	71.22	179044.0
2019-12-26 08:30:00	AAPL	Stock	71.21	71.21	71.1625	71.1625	56480.0
2019-12-26 09:00:00	AAPL	Stock	71.1625	71.2075	71.14	71.2075	130376.0
2019-12-26 09:30:00	AAPL	Stock	71.205	71.4975	71.175	71.4825	8102316.0
2019-12-26 10:00:00	AAPL	Stock	71.4775	71.69	71.475	71.6325	6047540.0
2019-12-26 10:30:00	AAPL	Stock	71.6325	71.8578	71.6225	71.854	5920632.0
2019-12-26 11:00:00	AAPL	Stock	71.8538	72.1188	71.8538	72.0225	8277352.0
2019-12-26 11:30:00	AAPL	Stock	72.025	72.1825	71.98	72.154	6720408.0
2019-12-26 12:00:00	AAPL	Stock	72.155	72.17	72.0125	72.0348	4374604.0
2019-12-26 12:30:00	AAPL	Stock	72.0325	72.0825	71.9875	72.045	4070932.0
2019-12-26 13:00:00	AAPL	Stock	72.0425	72.115	72.0175	72.1008	2242124.0
2019-12-26 13:30:00	AAPL	Stock	72.1025	72.1538	72.0575	72.1075	3214156.0
2019-12-26 14:00:00	AAPL	Stock	72.115	72.2775	72.1025	72.2275	4180728.0
2019-12-26 14:30:00	AAPL	Stock	72.2275	72.3213	72.18	72.3	3050260.0
2019-12-26 15:00:00	AAPL	Stock	72.2988	72.305	72.1075	72.1332	4076540.0
2019-12-26 15:30:00	AAPL	Stock	72.1308	72.495	72.11	72.4775	10422452.0
2019-12-26 16:00:00	AAPL	Stock	72.4775	72.5875	72.46	72.585	7238752.0
2019-12-26 16:30:00	AAPL	Stock	72.5825	72.595	72.5275	72.55	90608.0
2019-12-26 17:00:00	AAPL	Stock	72.5625	72.625	72.4775	72.61	306960.0
2019-12-26 17:30:00	AAPL	Stock	72.595	72.605	72.575	72.5975	46084.0
2019-12-26 18:00:00	AAPL	Stock	72.6	72.62	72.6	72.61	18180.0
2019-12-26 18:30:00	AAPL	Stock	72.6025	72.6725	72.6025	72.6325	83384.0
2019-12-26 19:00:00	AAPL	Stock	72.6475	72.6475	72.63	72.645	17052.0
2019-12-26 19:30:00	AAPL	Stock	72.645	72.72	72.645	72.705	69172.0
2019-12-26 04:30:00	MSFT	Stock	157.56	157.56	157.56	157.56	100.0
2019-12-26 06:30:00	MSFT	Stock	157.73	157.75	157.73	157.75	2736.0
2019-12-26 07:00:00	MSFT	Stock	157.64	157.68	157.64	157.68	901.0
2019-12-26 07:30:00	MSFT	Stock	157.63	157.63	157.57	157.57	1007.0
2019-12-26 08:00:00	MSFT	Stock	157.6	157.7	157.51	157.68	6760.0
2019-12-26 08:30:00	MSFT	Stock	157.65	157.65	157.58	157.64	7804.0
2019-12-26 09:00:00	MSFT	Stock	157.62	157.65	157.55	157.55	7197.0
2019-12-26 09:30:00	MSFT	Stock	157.55	157.87	157.4	157.766	1078512.0
2019-12-26 10:00:00	MSFT	Stock	157.77	157.97	157.77	157.88	531837.0
2019-12-26 10:30:00	MSFT	Stock	157.88	158.14	157.85	158.093	526080.0
2019-12-26 11:00:00	MSFT	Stock	158.093	158.26	158.09	158.12	501464.0
2019-12-26 11:30:00	MSFT	Stock	158.12	158.28	158.025	158.26	412919.0
2019-12-26 12:00:00	MSFT	Stock	158.265	158.41	158.06	158.195	576873.0
2019-12-26 12:30:00	MSFT	Stock	158.19	158.21	158.085	158.15	278078.0
2019-12-26 13:00:00	MSFT	Stock	158.15	158.33	158.15	158.25	331067.0
2019-12-26 13:30:00	MSFT	Stock	158.25	158.38	158.22	158.365	295121.0
2019-12-26 14:00:00	MSFT	Stock	158.365	158.41	158.25	158.279	384884.0
2019-12-26 14:30:00	MSFT	Stock	158.27	158.4	158.26	158.37	352932.0
2019-12-26 15:00:00	MSFT	Stock	158.376	158.435	158.26	158.26	473447.0
2019-12-26 15:30:00	MSFT	Stock	158.265	158.73	158.23	158.67	1518645.0

> showing 50 of 82,875 rows — these rows as CSV

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