PREVIEW / stock_30min / 2020-05-18

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-18.parquet
  size:    1.9 MB
  rows:    98,132
  symbols: 2,382

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
2020-05-18 04:00:00	AAPL	Stock	77.465	77.6825	77.465	77.6625	12624.0
2020-05-18 04:30:00	AAPL	Stock	77.7	77.7	77.5775	77.5775	12592.0
2020-05-18 05:00:00	AAPL	Stock	77.625	77.625	77.2225	77.2225	44952.0
2020-05-18 05:30:00	AAPL	Stock	77.1925	77.32	77.1425	77.32	11120.0
2020-05-18 06:00:00	AAPL	Stock	77.3625	77.3875	77.2525	77.2525	20444.0
2020-05-18 06:30:00	AAPL	Stock	77.2375	77.5	77.235	77.5	11836.0
2020-05-18 07:00:00	AAPL	Stock	77.4925	77.7875	77.3925	77.6875	168492.0
2020-05-18 07:30:00	AAPL	Stock	77.7025	78.325	77.6475	78.3	262240.0
2020-05-18 08:00:00	AAPL	Stock	77.725	78.605	77.1175	78.41	711236.0
2020-05-18 08:30:00	AAPL	Stock	78.41	78.4225	78.0038	78.3	333780.0
2020-05-18 09:00:00	AAPL	Stock	78.2975	78.3125	78.065	78.29	295168.0
2020-05-18 09:30:00	AAPL	Stock	78.29	78.32	77.581	78.0945	17344144.0
2020-05-18 10:00:00	AAPL	Stock	78.095	78.4525	77.8525	78.1475	10382740.0
2020-05-18 10:30:00	AAPL	Stock	78.145	78.435	78.0175	78.41	6624496.0
2020-05-18 11:00:00	AAPL	Stock	78.4075	78.535	78.285	78.4	6739336.0
2020-05-18 11:30:00	AAPL	Stock	78.4088	78.52	78.33	78.495	5150408.0
2020-05-18 12:00:00	AAPL	Stock	78.4925	78.7025	78.4375	78.6938	6363900.0
2020-05-18 12:30:00	AAPL	Stock	78.6975	78.75	78.533	78.7195	5069028.0
2020-05-18 13:00:00	AAPL	Stock	78.7225	79.05	78.6925	79.0475	6604520.0
2020-05-18 13:30:00	AAPL	Stock	79.0425	79.0475	78.75	78.8425	5877468.0
2020-05-18 14:00:00	AAPL	Stock	78.8475	78.935	78.6338	78.7438	4035220.0
2020-05-18 14:30:00	AAPL	Stock	78.74	78.8	78.6175	78.73	4543096.0
2020-05-18 15:00:00	AAPL	Stock	78.7325	78.8125	78.5082	78.7588	5937900.0
2020-05-18 15:30:00	AAPL	Stock	78.7568	79.125	78.645	78.7225	13892616.0
2020-05-18 16:00:00	AAPL	Stock	78.7225	78.8125	78.6275	78.7	11468788.0
2020-05-18 16:30:00	AAPL	Stock	78.6675	78.6875	78.6275	78.6875	41284.0
2020-05-18 17:00:00	AAPL	Stock	78.65	78.6925	78.6125	78.69	6676.0
2020-05-18 17:30:00	AAPL	Stock	78.6925	78.725	78.6625	78.665	20204.0
2020-05-18 18:00:00	AAPL	Stock	78.6625	78.975	78.66	78.8	41140.0
2020-05-18 18:30:00	AAPL	Stock	78.78	78.9	78.755	78.8925	26568.0
2020-05-18 19:00:00	AAPL	Stock	78.8875	78.9875	78.85	78.85	30504.0
2020-05-18 19:30:00	AAPL	Stock	78.825	78.925	78.775	78.925	30404.0
2020-05-18 04:00:00	MSFT	Stock	184.2	185.1	184.2	185.0	4788.0
2020-05-18 04:30:00	MSFT	Stock	184.8	185.2	184.8	185.0	3268.0
2020-05-18 05:00:00	MSFT	Stock	184.96	184.96	184.68	184.68	1698.0
2020-05-18 06:00:00	MSFT	Stock	184.8	184.87	184.61	184.61	912.0
2020-05-18 06:30:00	MSFT	Stock	184.61	185.16	184.61	185.1	6863.0
2020-05-18 07:00:00	MSFT	Stock	185.03	185.14	184.77	184.91	17184.0
2020-05-18 07:30:00	MSFT	Stock	184.98	186.2	184.75	186.2	47334.0
2020-05-18 08:00:00	MSFT	Stock	184.9	186.68	183.61	185.61	127547.0
2020-05-18 08:30:00	MSFT	Stock	185.69	186.0	185.2	186.0	58941.0
2020-05-18 09:00:00	MSFT	Stock	185.85	186.12	185.3	185.56	53924.0
2020-05-18 09:30:00	MSFT	Stock	185.8	185.8	183.96	184.68	4452630.0
2020-05-18 10:00:00	MSFT	Stock	184.68	185.2	184.52	184.8	2388600.0
2020-05-18 10:30:00	MSFT	Stock	184.79	185.57	184.78	185.57	2059219.0
2020-05-18 11:00:00	MSFT	Stock	185.57	185.699	184.98	185.05	1930552.0
2020-05-18 11:30:00	MSFT	Stock	185.07	185.37	184.83	185.131	1552347.0
2020-05-18 12:00:00	MSFT	Stock	185.135	185.3	184.86	185.28	1215626.0
2020-05-18 12:30:00	MSFT	Stock	185.29	185.42	184.79	185.24	1316376.0
2020-05-18 13:00:00	MSFT	Stock	185.25	186.2	185.195	186.19	1804138.0

> showing 50 of 98,132 rows — these rows as CSV

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