PREVIEW / stock_30min / 2020-01-21

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-21.parquet
  size:    1.8 MB
  rows:    89,411
  symbols: 2,488

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-01-21 04:00:00	AAPL	Stock	79.2425	79.25	79.085	79.2025	11140.0
2020-01-21 04:30:00	AAPL	Stock	79.2325	79.31	79.1275	79.225	14728.0
2020-01-21 05:00:00	AAPL	Stock	79.2	79.25	79.175	79.175	13140.0
2020-01-21 05:30:00	AAPL	Stock	79.175	79.175	79.125	79.1575	11184.0
2020-01-21 06:00:00	AAPL	Stock	79.25	79.25	79.1025	79.1025	10432.0
2020-01-21 06:30:00	AAPL	Stock	79.1025	79.285	79.1025	79.25	10612.0
2020-01-21 07:00:00	AAPL	Stock	79.25	79.3725	79.225	79.25	196176.0
2020-01-21 07:30:00	AAPL	Stock	79.26	79.29	79.2025	79.25	84496.0
2020-01-21 08:00:00	AAPL	Stock	79.3125	79.34	79.2025	79.295	284176.0
2020-01-21 08:30:00	AAPL	Stock	79.2775	79.2775	79.195	79.2	167504.0
2020-01-21 09:00:00	AAPL	Stock	79.205	79.365	79.205	79.2525	178768.0
2020-01-21 09:30:00	AAPL	Stock	79.2975	79.715	79.1625	79.5475	15022612.0
2020-01-21 10:00:00	AAPL	Stock	79.5575	79.755	79.2725	79.44	8019700.0
2020-01-21 10:30:00	AAPL	Stock	79.4375	79.545	79.33	79.345	5479572.0
2020-01-21 11:00:00	AAPL	Stock	79.3425	79.66	79.32	79.635	4381928.0
2020-01-21 11:30:00	AAPL	Stock	79.6375	79.75	79.5775	79.615	4116112.0
2020-01-21 12:00:00	AAPL	Stock	79.617	79.6258	79.47	79.5525	3962712.0
2020-01-21 12:30:00	AAPL	Stock	79.555	79.615	79.45	79.49	2765424.0
2020-01-21 13:00:00	AAPL	Stock	79.4975	79.55	79.3	79.4075	4232348.0
2020-01-21 13:30:00	AAPL	Stock	79.4075	79.44	79.085	79.14	5906068.0
2020-01-21 14:00:00	AAPL	Stock	79.1415	79.3175	79.085	79.1475	4347540.0
2020-01-21 14:30:00	AAPL	Stock	79.1525	79.25	79.0642	79.2228	3872916.0
2020-01-21 15:00:00	AAPL	Stock	79.2225	79.3075	79.155	79.2085	3543508.0
2020-01-21 15:30:00	AAPL	Stock	79.21	79.26	79.0	79.1375	8235332.0
2020-01-21 16:00:00	AAPL	Stock	79.1425	79.363	79.06	79.13	19225976.0
2020-01-21 16:30:00	AAPL	Stock	79.15	79.185	79.1375	79.15	68728.0
2020-01-21 17:00:00	AAPL	Stock	79.1425	79.17	79.1375	79.1375	56424.0
2020-01-21 17:30:00	AAPL	Stock	79.16	79.175	79.125	79.125	31240.0
2020-01-21 18:00:00	AAPL	Stock	79.1625	79.1625	79.1325	79.1625	4748.0
2020-01-21 18:30:00	AAPL	Stock	79.16	79.3075	79.15	79.2875	52952.0
2020-01-21 19:00:00	AAPL	Stock	79.2875	79.325	79.25	79.3175	23476.0
2020-01-21 19:30:00	AAPL	Stock	79.3125	79.35	79.255	79.3075	78996.0
2020-01-21 04:00:00	MSFT	Stock	166.43	166.81	166.4	166.69	3301.0
2020-01-21 04:30:00	MSFT	Stock	166.57	166.57	166.0	166.04	3971.0
2020-01-21 05:00:00	MSFT	Stock	166.55	166.94	166.5	166.5	3509.0
2020-01-21 05:30:00	MSFT	Stock	166.51	166.51	166.51	166.51	371.0
2020-01-21 06:00:00	MSFT	Stock	166.51	166.57	166.5	166.5	4699.0
2020-01-21 06:30:00	MSFT	Stock	166.5	166.69	166.5	166.63	932.0
2020-01-21 07:00:00	MSFT	Stock	166.6	166.76	166.55	166.68	26891.0
2020-01-21 07:30:00	MSFT	Stock	166.74	166.89	166.64	166.65	17775.0
2020-01-21 08:00:00	MSFT	Stock	166.73	166.8	166.61	166.65	25214.0
2020-01-21 08:30:00	MSFT	Stock	166.75	166.75	166.61	166.615	12610.0
2020-01-21 09:00:00	MSFT	Stock	166.7	166.88	166.5	166.72	19740.0
2020-01-21 09:30:00	MSFT	Stock	166.74	167.485	166.5	167.4	2827854.0
2020-01-21 10:00:00	MSFT	Stock	167.37	167.96	166.85	167.36	1603603.0
2020-01-21 10:30:00	MSFT	Stock	167.365	167.63	167.275	167.3	1058999.0
2020-01-21 11:00:00	MSFT	Stock	167.29	167.983	167.26	167.885	912160.0
2020-01-21 11:30:00	MSFT	Stock	167.89	168.19	167.52	167.605	1140643.0
2020-01-21 12:00:00	MSFT	Stock	167.6	167.79	167.51	167.745	610767.0
2020-01-21 12:30:00	MSFT	Stock	167.74	167.77	167.47	167.493	737261.0

> showing 50 of 89,411 rows — these rows as CSV

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