PREVIEW / stock_30min / 2020-10-07

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-07.parquet
  size:    1.9 MB
  rows:    97,868
  symbols: 2,521

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-10-07 04:00:00	AAPL	Stock	114.1	114.35	113.93	113.99	32964.0
2020-10-07 04:30:00	AAPL	Stock	114.0	114.2	113.9	114.0	42601.0
2020-10-07 05:00:00	AAPL	Stock	114.01	114.1	113.81	113.95	16856.0
2020-10-07 05:30:00	AAPL	Stock	114.06	114.13	113.79	113.79	9397.0
2020-10-07 06:00:00	AAPL	Stock	113.66	113.95	113.63	113.76	23855.0
2020-10-07 06:30:00	AAPL	Stock	113.76	114.2	113.6	113.97	52319.0
2020-10-07 07:00:00	AAPL	Stock	114.0	114.45	113.98	114.32	395462.0
2020-10-07 07:30:00	AAPL	Stock	114.31	114.39	114.16	114.34	158224.0
2020-10-07 08:00:00	AAPL	Stock	114.35	114.609	113.44	114.46	596778.0
2020-10-07 08:30:00	AAPL	Stock	114.49	114.74	114.39	114.57	325741.0
2020-10-07 09:00:00	AAPL	Stock	114.57	114.75	113.134	114.65	416900.0
2020-10-07 09:30:00	AAPL	Stock	114.64	115.246	114.38	114.65	13482870.0
2020-10-07 10:00:00	AAPL	Stock	114.654	114.75	114.13	114.28	8324818.0
2020-10-07 10:30:00	AAPL	Stock	114.275	114.93	114.18	114.915	5819866.0
2020-10-07 11:00:00	AAPL	Stock	114.92	115.11	114.78	115.06	5623972.0
2020-10-07 11:30:00	AAPL	Stock	115.065	115.16	114.67	114.681	4757079.0
2020-10-07 12:00:00	AAPL	Stock	114.69	114.97	114.13	114.48	5122001.0
2020-10-07 12:30:00	AAPL	Stock	114.47	115.0	114.465	114.967	3865227.0
2020-10-07 13:00:00	AAPL	Stock	114.966	115.115	114.87	115.1	4032752.0
2020-10-07 13:30:00	AAPL	Stock	115.092	115.55	115.08	115.21	5668110.0
2020-10-07 14:00:00	AAPL	Stock	115.21	115.5	114.99	115.346	4501923.0
2020-10-07 14:30:00	AAPL	Stock	115.35	115.41	115.06	115.29	3607698.0
2020-10-07 15:00:00	AAPL	Stock	115.295	115.45	115.07	115.136	4747854.0
2020-10-07 15:30:00	AAPL	Stock	115.14	115.26	114.84	115.05	8749468.0
2020-10-07 16:00:00	AAPL	Stock	115.08	115.1	114.8	115.0	7198383.0
2020-10-07 16:30:00	AAPL	Stock	115.0	115.08	114.95	114.95	76667.0
2020-10-07 17:00:00	AAPL	Stock	114.95	115.2	114.95	115.17	70793.0
2020-10-07 17:30:00	AAPL	Stock	115.19	115.2	115.06	115.18	142789.0
2020-10-07 18:00:00	AAPL	Stock	115.18	115.25	115.1	115.23	51305.0
2020-10-07 18:30:00	AAPL	Stock	115.22	115.3	115.22	115.26	40798.0
2020-10-07 19:00:00	AAPL	Stock	115.29	115.31	115.25	115.25	60548.0
2020-10-07 19:30:00	AAPL	Stock	115.25	115.37	115.23	115.37	123042.0
2020-10-07 04:00:00	MSFT	Stock	207.06	207.06	206.8	206.8	645.0
2020-10-07 05:00:00	MSFT	Stock	207.0	207.0	207.0	207.0	141.0
2020-10-07 05:30:00	MSFT	Stock	207.01	207.01	207.0	207.0	483.0
2020-10-07 06:00:00	MSFT	Stock	206.68	207.25	206.68	206.86	912.0
2020-10-07 06:30:00	MSFT	Stock	206.84	207.14	206.72	206.99	1567.0
2020-10-07 07:00:00	MSFT	Stock	207.1	207.17	206.72	207.0	45423.0
2020-10-07 07:30:00	MSFT	Stock	207.01	207.29	206.72	207.29	19940.0
2020-10-07 08:00:00	MSFT	Stock	207.0	207.7	206.81	207.45	53505.0
2020-10-07 08:30:00	MSFT	Stock	207.45	207.94	207.3	207.64	24971.0
2020-10-07 09:00:00	MSFT	Stock	207.54	208.1	207.05	207.05	79938.0
2020-10-07 09:30:00	MSFT	Stock	207.06	208.18	207.01	207.89	2157977.0
2020-10-07 10:00:00	MSFT	Stock	207.895	207.98	206.72	206.88	1608981.0
2020-10-07 10:30:00	MSFT	Stock	206.89	207.88	206.74	207.653	1067178.0
2020-10-07 11:00:00	MSFT	Stock	207.66	208.26	207.55	208.18	1060294.0
2020-10-07 11:30:00	MSFT	Stock	208.2	208.51	208.02	208.14	908546.0
2020-10-07 12:00:00	MSFT	Stock	208.145	208.52	207.31	207.855	906773.0
2020-10-07 12:30:00	MSFT	Stock	207.85	208.83	207.85	208.79	854633.0
2020-10-07 13:00:00	MSFT	Stock	208.8	209.71	208.783	209.42	966195.0

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

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