PREVIEW / stock_30min / 2020-09-11

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-11.parquet
  size:    1.9 MB
  rows:    93,841
  symbols: 2,473

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-11 04:00:00	AAPL	Stock	115.1	116.3	115.1	116.05	48630.0
2020-09-11 04:30:00	AAPL	Stock	116.1	116.35	115.77	115.9	35188.0
2020-09-11 05:00:00	AAPL	Stock	115.88	116.2	115.77	116.2	12535.0
2020-09-11 05:30:00	AAPL	Stock	116.13	116.33	115.9	116.05	14846.0
2020-09-11 06:00:00	AAPL	Stock	116.12	116.12	115.05	115.39	49881.0
2020-09-11 06:30:00	AAPL	Stock	115.36	115.59	114.8	115.15	59898.0
2020-09-11 07:00:00	AAPL	Stock	115.1	115.39	114.56	114.85	349560.0
2020-09-11 07:30:00	AAPL	Stock	114.85	115.46	114.66	115.33	227645.0
2020-09-11 08:00:00	AAPL	Stock	114.858	115.45	114.45	114.56	639753.0
2020-09-11 08:30:00	AAPL	Stock	114.56	114.664	113.96	114.0	580349.0
2020-09-11 09:00:00	AAPL	Stock	114.0	114.9	113.96	114.61	470562.0
2020-09-11 09:30:00	AAPL	Stock	114.58	115.23	112.26	112.72	18749963.0
2020-09-11 10:00:00	AAPL	Stock	112.727	113.18	110.0	112.7	16151364.0
2020-09-11 10:30:00	AAPL	Stock	112.703	113.66	111.86	112.58	11109948.0
2020-09-11 11:00:00	AAPL	Stock	112.57	113.87	112.24	112.43	10004194.0
2020-09-11 11:30:00	AAPL	Stock	112.42	112.44	111.5	111.54	9100996.0
2020-09-11 12:00:00	AAPL	Stock	111.55	112.42	111.44	111.94	7407080.0
2020-09-11 12:30:00	AAPL	Stock	111.93	111.93	110.71	110.748	9614349.0
2020-09-11 13:00:00	AAPL	Stock	110.745	111.12	110.1	110.224	11876575.0
2020-09-11 13:30:00	AAPL	Stock	110.2	111.364	110.03	110.412	10952138.0
2020-09-11 14:00:00	AAPL	Stock	110.42	111.63	110.28	111.045	8392707.0
2020-09-11 14:30:00	AAPL	Stock	111.046	112.22	111.03	111.31	10224323.0
2020-09-11 15:00:00	AAPL	Stock	111.31	112.09	110.7	112.0	10972124.0
2020-09-11 15:30:00	AAPL	Stock	112.0	112.55	111.21	112.01	13661303.0
2020-09-11 16:00:00	AAPL	Stock	112.01	112.23	111.77	112.0	7783157.0
2020-09-11 16:30:00	AAPL	Stock	112.0	112.17	111.98	112.11	148593.0
2020-09-11 17:00:00	AAPL	Stock	112.12	112.2	111.75	111.95	193831.0
2020-09-11 17:30:00	AAPL	Stock	111.98	112.11	111.9	112.08	105779.0
2020-09-11 18:00:00	AAPL	Stock	112.07	112.07	111.96	111.99	61996.0
2020-09-11 18:30:00	AAPL	Stock	112.0	112.0	111.87	111.98	50522.0
2020-09-11 19:00:00	AAPL	Stock	111.98	112.02	111.85	111.88	86624.0
2020-09-11 19:30:00	AAPL	Stock	111.85	112.0	111.85	111.99	107874.0
2020-09-11 04:00:00	MSFT	Stock	207.82	209.24	207.66	209.0	5327.0
2020-09-11 04:30:00	MSFT	Stock	209.16	209.88	209.05	209.05	2900.0
2020-09-11 05:00:00	MSFT	Stock	209.05	209.05	208.65	208.65	1367.0
2020-09-11 05:30:00	MSFT	Stock	208.83	209.0	208.83	208.85	772.0
2020-09-11 06:00:00	MSFT	Stock	208.51	208.51	207.85	208.0	5362.0
2020-09-11 06:30:00	MSFT	Stock	208.1	208.1	207.72	207.8	4880.0
2020-09-11 07:00:00	MSFT	Stock	208.1	208.1	207.3	207.46	21518.0
2020-09-11 07:30:00	MSFT	Stock	207.46	208.5	207.02	208.45	17003.0
2020-09-11 08:00:00	MSFT	Stock	207.3	208.5	207.1	207.43	54546.0
2020-09-11 08:30:00	MSFT	Stock	207.4	207.48	206.06	206.39	40165.0
2020-09-11 09:00:00	MSFT	Stock	206.38	207.6	206.29	207.4	26876.0
2020-09-11 09:30:00	MSFT	Stock	207.4	208.63	205.284	205.595	2644579.0
2020-09-11 10:00:00	MSFT	Stock	205.57	207.18	204.77	206.83	1971769.0
2020-09-11 10:30:00	MSFT	Stock	206.825	208.23	206.12	207.51	1486322.0
2020-09-11 11:00:00	MSFT	Stock	207.51	208.54	205.92	206.415	1213585.0
2020-09-11 11:30:00	MSFT	Stock	206.37	206.39	205.03	205.106	1151337.0
2020-09-11 12:00:00	MSFT	Stock	205.06	205.73	204.75	205.04	1181739.0
2020-09-11 12:30:00	MSFT	Stock	205.0	205.0	202.93	202.97	1741856.0

> showing 50 of 93,841 rows — these rows as CSV

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