PREVIEW / stock_30min / 2020-09-08

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-08.parquet
  size:    2.0 MB
  rows:    99,832
  symbols: 2,481

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-09-08 04:00:00	AAPL	Stock	120.36	120.4	116.55	117.45	131627.0
2020-09-08 04:30:00	AAPL	Stock	117.49	117.99	116.53	117.3	63629.0
2020-09-08 05:00:00	AAPL	Stock	117.3	117.93	116.91	117.43	46801.0
2020-09-08 05:30:00	AAPL	Stock	117.35	117.42	116.49	116.74	105640.0
2020-09-08 06:00:00	AAPL	Stock	116.61	116.89	115.87	115.9	68605.0
2020-09-08 06:30:00	AAPL	Stock	116.0	117.5	116.0	117.45	95363.0
2020-09-08 07:00:00	AAPL	Stock	117.34	117.7	115.63	115.81	491071.0
2020-09-08 07:30:00	AAPL	Stock	115.81	115.95	115.0	115.25	427757.0
2020-09-08 08:00:00	AAPL	Stock	115.3	117.68	113.5	114.01	1948833.0
2020-09-08 08:30:00	AAPL	Stock	114.0	116.57	113.8	116.09	1278268.0
2020-09-08 09:00:00	AAPL	Stock	116.06	116.35	113.92	114.2	1330579.0
2020-09-08 09:30:00	AAPL	Stock	114.25	117.3	113.25	117.26	32460556.0
2020-09-08 10:00:00	AAPL	Stock	117.3	118.99	116.19	118.06	18400143.0
2020-09-08 10:30:00	AAPL	Stock	118.1	118.47	116.12	116.742	13234852.0
2020-09-08 11:00:00	AAPL	Stock	116.77	118.05	115.64	117.275	15552301.0
2020-09-08 11:30:00	AAPL	Stock	117.282	117.556	115.5	116.28	12431458.0
2020-09-08 12:00:00	AAPL	Stock	116.28	116.69	115.7	115.98	9144839.0
2020-09-08 12:30:00	AAPL	Stock	115.995	117.21	115.91	116.92	8234794.0
2020-09-08 13:00:00	AAPL	Stock	116.92	117.06	115.88	116.101	6768893.0
2020-09-08 13:30:00	AAPL	Stock	116.1	116.5	115.64	115.79	6787302.0
2020-09-08 14:00:00	AAPL	Stock	115.77	116.03	115.0	115.08	8459490.0
2020-09-08 14:30:00	AAPL	Stock	115.09	115.25	113.47	114.491	14467093.0
2020-09-08 15:00:00	AAPL	Stock	114.51	114.51	113.5	114.26	12128074.0
2020-09-08 15:30:00	AAPL	Stock	114.26	114.475	112.68	112.83	21371653.0
2020-09-08 16:00:00	AAPL	Stock	112.82	113.17	112.25	112.75	12029982.0
2020-09-08 16:30:00	AAPL	Stock	112.75	113.25	112.68	113.01	335699.0
2020-09-08 17:00:00	AAPL	Stock	113.04	113.3	112.15	112.27	279048.0
2020-09-08 17:30:00	AAPL	Stock	112.27	112.34	110.59	111.2	678026.0
2020-09-08 18:00:00	AAPL	Stock	111.27	111.99	110.88	111.43	416345.0
2020-09-08 18:30:00	AAPL	Stock	111.43	112.82	111.34	112.15	286349.0
2020-09-08 19:00:00	AAPL	Stock	112.11	112.7	111.89	112.31	201374.0
2020-09-08 19:30:00	AAPL	Stock	112.33	112.66	112.05	112.48	255547.0
2020-09-08 04:00:00	MSFT	Stock	214.0	214.0	210.59	210.59	10352.0
2020-09-08 04:30:00	MSFT	Stock	211.16	211.16	209.75	209.75	8907.0
2020-09-08 05:00:00	MSFT	Stock	210.45	210.45	208.28	209.32	4216.0
2020-09-08 05:30:00	MSFT	Stock	209.83	209.83	207.15	207.98	8290.0
2020-09-08 06:00:00	MSFT	Stock	207.85	208.33	207.13	207.6	8172.0
2020-09-08 06:30:00	MSFT	Stock	207.53	208.57	207.38	208.57	10444.0
2020-09-08 07:00:00	MSFT	Stock	208.35	209.9	207.12	207.77	51801.0
2020-09-08 07:30:00	MSFT	Stock	207.61	208.0	206.8	207.0	89188.0
2020-09-08 08:00:00	MSFT	Stock	207.632	209.77	205.9	206.7	170559.0
2020-09-08 08:30:00	MSFT	Stock	206.45	207.65	206.31	206.87	96354.0
2020-09-08 09:00:00	MSFT	Stock	206.657	207.29	206.17	206.47	192632.0
2020-09-08 09:30:00	MSFT	Stock	206.5	208.8	205.03	207.95	6750920.0
2020-09-08 10:00:00	MSFT	Stock	208.0	209.44	207.04	209.04	2930176.0
2020-09-08 10:30:00	MSFT	Stock	209.04	210.03	207.61	207.61	2469006.0
2020-09-08 11:00:00	MSFT	Stock	207.69	208.42	206.27	206.81	2105988.0
2020-09-08 11:30:00	MSFT	Stock	206.79	207.06	205.32	206.34	2281631.0
2020-09-08 12:00:00	MSFT	Stock	206.36	206.94	205.55	205.778	1694318.0
2020-09-08 12:30:00	MSFT	Stock	205.74	207.17	205.45	206.61	1302705.0

> showing 50 of 99,832 rows — these rows as CSV

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