PREVIEW / stock_30min / 2020-10-06

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-06.parquet
  size:    2.0 MB
  rows:    99,481
  symbols: 2,524

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-06 04:00:00	AAPL	Stock	115.76	115.8	115.23	115.61	16693.0
2020-10-06 04:30:00	AAPL	Stock	115.69	115.75	115.4	115.67	6611.0
2020-10-06 05:00:00	AAPL	Stock	115.65	115.66	115.51	115.65	4108.0
2020-10-06 05:30:00	AAPL	Stock	115.55	115.65	115.42	115.5	5779.0
2020-10-06 06:00:00	AAPL	Stock	115.55	115.79	115.29	115.6	20013.0
2020-10-06 06:30:00	AAPL	Stock	115.65	115.71	115.38	115.55	14247.0
2020-10-06 07:00:00	AAPL	Stock	115.63	116.1	115.6	116.09	120671.0
2020-10-06 07:30:00	AAPL	Stock	116.09	116.13	115.75	115.84	145439.0
2020-10-06 08:00:00	AAPL	Stock	115.84	116.79	115.56	115.94	318100.0
2020-10-06 08:30:00	AAPL	Stock	115.92	116.1	115.72	115.91	357516.0
2020-10-06 09:00:00	AAPL	Stock	115.91	116.06	115.68	115.68	349489.0
2020-10-06 09:30:00	AAPL	Stock	115.68	116.12	114.532	114.908	15380463.0
2020-10-06 10:00:00	AAPL	Stock	114.9	115.6	114.86	115.192	10418861.0
2020-10-06 10:30:00	AAPL	Stock	115.21	115.355	114.56	114.978	7207225.0
2020-10-06 11:00:00	AAPL	Stock	114.975	115.12	113.665	114.04	9872656.0
2020-10-06 11:30:00	AAPL	Stock	114.031	114.31	113.48	113.84	8361609.0
2020-10-06 12:00:00	AAPL	Stock	113.831	115.22	113.8	114.915	13685295.0
2020-10-06 12:30:00	AAPL	Stock	114.92	115.44	114.69	115.277	5792860.0
2020-10-06 13:00:00	AAPL	Stock	115.28	115.63	115.12	115.21	5376366.0
2020-10-06 13:30:00	AAPL	Stock	115.21	115.28	114.78	114.974	5171609.0
2020-10-06 14:00:00	AAPL	Stock	114.971	115.6	114.9	115.46	4830876.0
2020-10-06 14:30:00	AAPL	Stock	115.45	116.02	113.13	114.05	15149476.0
2020-10-06 15:00:00	AAPL	Stock	114.04	114.05	112.25	113.79	16573910.0
2020-10-06 15:30:00	AAPL	Stock	113.79	114.03	112.8	113.16	14984260.0
2020-10-06 16:00:00	AAPL	Stock	113.16	114.755	112.8	112.88	8463777.0
2020-10-06 16:30:00	AAPL	Stock	112.89	112.95	112.33	112.44	420758.0
2020-10-06 17:00:00	AAPL	Stock	112.45	112.85	112.42	112.8	225534.0
2020-10-06 17:30:00	AAPL	Stock	112.8	112.99	112.7	112.9	149803.0
2020-10-06 18:00:00	AAPL	Stock	112.9	112.92	112.65	112.87	124452.0
2020-10-06 18:30:00	AAPL	Stock	112.86	113.1	112.69	112.8	180175.0
2020-10-06 19:00:00	AAPL	Stock	112.83	112.99	112.79	112.95	104682.0
2020-10-06 19:30:00	AAPL	Stock	112.95	113.25	112.89	113.2	189128.0
2020-10-06 04:00:00	MSFT	Stock	209.6	209.73	209.2	209.4	3945.0
2020-10-06 04:30:00	MSFT	Stock	209.13	209.13	209.03	209.05	304.0
2020-10-06 05:30:00	MSFT	Stock	209.4	209.51	209.4	209.4	2835.0
2020-10-06 06:00:00	MSFT	Stock	209.15	209.4	209.0	209.08	3516.0
2020-10-06 06:30:00	MSFT	Stock	209.35	209.35	208.6	208.7	4748.0
2020-10-06 07:00:00	MSFT	Stock	208.86	209.28	208.8	209.25	18429.0
2020-10-06 07:30:00	MSFT	Stock	209.06	209.3	208.6	208.82	29496.0
2020-10-06 08:00:00	MSFT	Stock	208.856	209.33	208.5	208.81	34050.0
2020-10-06 08:30:00	MSFT	Stock	208.742	209.25	208.7	208.9	37448.0
2020-10-06 09:00:00	MSFT	Stock	209.022	209.2	208.77	208.89	29947.0
2020-10-06 09:30:00	MSFT	Stock	208.83	209.5	208.44	208.73	2466250.0
2020-10-06 10:00:00	MSFT	Stock	208.75	210.18	208.74	209.935	1366698.0
2020-10-06 10:30:00	MSFT	Stock	209.96	209.99	208.75	208.88	1239349.0
2020-10-06 11:00:00	MSFT	Stock	208.87	209.095	207.501	207.88	1401077.0
2020-10-06 11:30:00	MSFT	Stock	207.88	208.36	207.19	207.678	1120137.0
2020-10-06 12:00:00	MSFT	Stock	207.676	208.239	207.58	208.015	709557.0
2020-10-06 12:30:00	MSFT	Stock	208.02	208.43	207.67	208.213	650614.0
2020-10-06 13:00:00	MSFT	Stock	208.22	208.4	207.975	208.28	655593.0

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

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