PREVIEW / stock_30min / 2020-08-07

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-07.parquet
  size:    1.9 MB
  rows:    97,901
  symbols: 2,442

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-08-07 04:00:00	AAPL	Stock	113.5	113.5	112.5125	113.1875	38204.0
2020-08-07 04:30:00	AAPL	Stock	113.025	113.075	112.95	113.0125	10280.0
2020-08-07 05:00:00	AAPL	Stock	113.0425	113.1975	112.875	113.1975	11028.0
2020-08-07 05:30:00	AAPL	Stock	113.1975	113.25	113.12	113.175	3668.0
2020-08-07 06:00:00	AAPL	Stock	113.2425	113.2575	113.2	113.2	7380.0
2020-08-07 06:30:00	AAPL	Stock	113.215	113.325	113.16	113.25	75936.0
2020-08-07 07:00:00	AAPL	Stock	113.25	113.6775	113.225	113.6625	216012.0
2020-08-07 07:30:00	AAPL	Stock	113.6625	113.6625	113.155	113.25	378376.0
2020-08-07 08:00:00	AAPL	Stock	113.7125	113.725	113.135	113.29	639760.0
2020-08-07 08:30:00	AAPL	Stock	113.2875	113.7775	113.125	113.3775	1446892.0
2020-08-07 09:00:00	AAPL	Stock	113.38	113.4125	113.185	113.1925	691432.0
2020-08-07 09:30:00	AAPL	Stock	113.1925	113.485	112.26	113.1262	24485516.0
2020-08-07 10:00:00	AAPL	Stock	113.1325	113.1708	112.0325	112.369	13313572.0
2020-08-07 10:30:00	AAPL	Stock	112.375	113.675	112.3675	113.2362	10894484.0
2020-08-07 11:00:00	AAPL	Stock	113.2425	113.3375	112.4825	112.591	7439404.0
2020-08-07 11:30:00	AAPL	Stock	112.585	112.8625	112.175	112.2228	6869120.0
2020-08-07 12:00:00	AAPL	Stock	112.2075	112.622	112.11	112.3855	6261044.0
2020-08-07 12:30:00	AAPL	Stock	112.3848	112.5825	111.425	111.5825	8897700.0
2020-08-07 13:00:00	AAPL	Stock	111.57	111.765	110.7275	111.32	11021160.0
2020-08-07 13:30:00	AAPL	Stock	111.3235	111.7225	110.94	111.0405	8039844.0
2020-08-07 14:00:00	AAPL	Stock	111.0575	111.4458	110.2925	110.5588	9224912.0
2020-08-07 14:30:00	AAPL	Stock	110.5675	111.1875	110.375	111.1425	8713752.0
2020-08-07 15:00:00	AAPL	Stock	111.135	111.6875	111.0275	111.061	10330964.0
2020-08-07 15:30:00	AAPL	Stock	111.0575	111.5875	110.97	111.1025	13999984.0
2020-08-07 16:00:00	AAPL	Stock	111.1125	111.1625	110.9025	110.94	7195300.0
2020-08-07 16:30:00	AAPL	Stock	110.9375	111.32	110.9225	111.255	390260.0
2020-08-07 17:00:00	AAPL	Stock	111.2825	111.75	111.275	111.45	340288.0
2020-08-07 17:30:00	AAPL	Stock	111.415	111.4775	111.4025	111.4375	59024.0
2020-08-07 18:00:00	AAPL	Stock	111.46	111.47	111.4075	111.445	36840.0
2020-08-07 18:30:00	AAPL	Stock	111.45	111.4725	111.43	111.4725	24080.0
2020-08-07 19:00:00	AAPL	Stock	111.45	111.4625	111.4	111.4	38480.0
2020-08-07 19:30:00	AAPL	Stock	111.425	111.425	111.3125	111.3725	49160.0
2020-08-07 04:00:00	MSFT	Stock	216.0	216.0	215.13	215.13	2205.0
2020-08-07 04:30:00	MSFT	Stock	214.7	215.0	214.5	214.9	1396.0
2020-08-07 05:00:00	MSFT	Stock	214.85	214.85	214.55	214.55	1156.0
2020-08-07 05:30:00	MSFT	Stock	214.6	214.98	214.6	214.98	2089.0
2020-08-07 06:00:00	MSFT	Stock	214.85	214.87	214.8	214.87	1070.0
2020-08-07 06:30:00	MSFT	Stock	214.87	215.09	214.87	215.09	3304.0
2020-08-07 07:00:00	MSFT	Stock	215.11	215.3	214.59	215.25	17762.0
2020-08-07 07:30:00	MSFT	Stock	215.24	215.4	215.15	215.37	12578.0
2020-08-07 08:00:00	MSFT	Stock	215.15	216.89	214.87	215.3	32465.0
2020-08-07 08:30:00	MSFT	Stock	215.4	216.0	214.81	215.06	75641.0
2020-08-07 09:00:00	MSFT	Stock	215.02	216.35	214.78	214.89	101940.0
2020-08-07 09:30:00	MSFT	Stock	214.82	215.7	213.95	214.921	2630056.0
2020-08-07 10:00:00	MSFT	Stock	214.93	215.045	214.22	214.468	1295627.0
2020-08-07 10:30:00	MSFT	Stock	214.46	215.208	214.45	215.163	1139215.0
2020-08-07 11:00:00	MSFT	Stock	215.15	215.2	214.09	214.18	1078212.0
2020-08-07 11:30:00	MSFT	Stock	214.176	214.49	213.47	213.5	921615.0
2020-08-07 12:00:00	MSFT	Stock	213.48	213.705	212.91	213.649	1079883.0
2020-08-07 12:30:00	MSFT	Stock	213.66	213.69	212.46	212.46	1212788.0

> showing 50 of 97,901 rows — these rows as CSV

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