PREVIEW / stock_30min / 2020-08-11

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-11.parquet
  size:    2.0 MB
  rows:    101,092
  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-11 04:00:00	AAPL	Stock	113.025	113.2425	113.025	113.18	14116.0
2020-08-11 04:30:00	AAPL	Stock	113.24	113.4375	113.24	113.325	32168.0
2020-08-11 05:00:00	AAPL	Stock	113.3375	113.525	113.2025	113.5125	28204.0
2020-08-11 05:30:00	AAPL	Stock	113.465	113.5525	113.2175	113.25	44224.0
2020-08-11 06:00:00	AAPL	Stock	113.25	113.3125	113.1525	113.1925	45588.0
2020-08-11 06:30:00	AAPL	Stock	113.21	113.225	113.1475	113.1475	14728.0
2020-08-11 07:00:00	AAPL	Stock	113.1875	113.2925	112.6375	112.675	342032.0
2020-08-11 07:30:00	AAPL	Stock	112.675	112.76	112.28	112.4	341908.0
2020-08-11 08:00:00	AAPL	Stock	112.91	113.275	112.2575	112.3625	521436.0
2020-08-11 08:30:00	AAPL	Stock	112.3875	112.4075	111.5	111.9	487536.0
2020-08-11 09:00:00	AAPL	Stock	111.8552	112.095	111.58	111.975	552872.0
2020-08-11 09:30:00	AAPL	Stock	111.925	112.4825	111.2025	111.8712	16905552.0
2020-08-11 10:00:00	AAPL	Stock	111.8725	111.9622	111.07	111.5025	11032224.0
2020-08-11 10:30:00	AAPL	Stock	111.4975	111.7125	111.2175	111.36	7334088.0
2020-08-11 11:00:00	AAPL	Stock	111.3625	112.1825	111.3548	111.88	7898944.0
2020-08-11 11:30:00	AAPL	Stock	111.89	111.9125	111.095	111.3838	7999980.0
2020-08-11 12:00:00	AAPL	Stock	111.3925	111.8	111.2325	111.7025	6444192.0
2020-08-11 12:30:00	AAPL	Stock	111.7075	111.87	111.4375	111.4775	5105928.0
2020-08-11 13:00:00	AAPL	Stock	111.48	111.75	111.3862	111.6725	3812416.0
2020-08-11 13:30:00	AAPL	Stock	111.6845	111.71	111.2975	111.51	3997156.0
2020-08-11 14:00:00	AAPL	Stock	111.515	111.555	110.72	110.835	8524720.0
2020-08-11 14:30:00	AAPL	Stock	110.8425	110.9975	110.5775	110.8422	7764300.0
2020-08-11 15:00:00	AAPL	Stock	110.8525	110.93	109.75	110.32	12603764.0
2020-08-11 15:30:00	AAPL	Stock	110.3255	110.3255	109.1068	109.3775	19264168.0
2020-08-11 16:00:00	AAPL	Stock	109.375	110.733	109.28	109.7875	13847872.0
2020-08-11 16:30:00	AAPL	Stock	109.7725	110.035	109.705	109.9375	286024.0
2020-08-11 17:00:00	AAPL	Stock	109.965	110.25	109.9125	110.1875	148772.0
2020-08-11 17:30:00	AAPL	Stock	110.1925	110.2	109.7725	109.7725	161908.0
2020-08-11 18:00:00	AAPL	Stock	109.85	110.1225	109.83	109.905	73012.0
2020-08-11 18:30:00	AAPL	Stock	109.8975	109.97	109.825	109.86	33708.0
2020-08-11 19:00:00	AAPL	Stock	109.9	110.0	109.7725	109.8775	80144.0
2020-08-11 19:30:00	AAPL	Stock	109.9125	110.125	109.8875	110.035	97540.0
2020-08-11 04:00:00	MSFT	Stock	209.4	209.5	209.4	209.5	1312.0
2020-08-11 04:30:00	MSFT	Stock	209.67	209.7	209.5	209.5	3164.0
2020-08-11 05:00:00	MSFT	Stock	209.54	209.8	208.99	209.68	6178.0
2020-08-11 05:30:00	MSFT	Stock	209.7	209.7	209.45	209.45	1062.0
2020-08-11 06:00:00	MSFT	Stock	209.3	209.48	209.3	209.3	1362.0
2020-08-11 06:30:00	MSFT	Stock	209.1	209.25	209.05	209.05	2602.0
2020-08-11 07:00:00	MSFT	Stock	209.05	209.18	208.29	208.32	36710.0
2020-08-11 07:30:00	MSFT	Stock	208.36	208.53	207.55	207.6	25363.0
2020-08-11 08:00:00	MSFT	Stock	208.9	209.15	207.5	207.971	45914.0
2020-08-11 08:30:00	MSFT	Stock	207.8	207.98	206.28	206.6	75965.0
2020-08-11 09:00:00	MSFT	Stock	206.53	207.36	206.39	207.36	76726.0
2020-08-11 09:30:00	MSFT	Stock	207.155	207.55	203.77	205.29	5205323.0
2020-08-11 10:00:00	MSFT	Stock	205.27	205.55	203.9	205.08	2510759.0
2020-08-11 10:30:00	MSFT	Stock	205.09	205.71	204.545	205.5	1508111.0
2020-08-11 11:00:00	MSFT	Stock	205.53	206.95	205.5	206.77	1360871.0
2020-08-11 11:30:00	MSFT	Stock	206.79	206.97	206.14	206.375	903855.0
2020-08-11 12:00:00	MSFT	Stock	206.4	207.49	206.26	207.15	858024.0
2020-08-11 12:30:00	MSFT	Stock	207.139	207.65	206.95	207.31	772261.0

> showing 50 of 101,092 rows — these rows as CSV

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