PREVIEW / stock_30min / 2020-08-14

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-14.parquet
  size:    1.9 MB
  rows:    95,961
  symbols: 2,436

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-14 04:00:00	AAPL	Stock	114.8675	114.875	114.415	114.415	12412.0
2020-08-14 04:30:00	AAPL	Stock	114.605	114.605	114.5225	114.5275	3680.0
2020-08-14 05:00:00	AAPL	Stock	114.525	114.525	114.3175	114.465	14408.0
2020-08-14 05:30:00	AAPL	Stock	114.5575	114.65	114.5575	114.65	3280.0
2020-08-14 06:00:00	AAPL	Stock	114.6325	114.6325	114.4175	114.5175	15184.0
2020-08-14 06:30:00	AAPL	Stock	114.625	114.9675	114.625	114.925	31520.0
2020-08-14 07:00:00	AAPL	Stock	114.915	115.3875	114.5	115.2425	267908.0
2020-08-14 07:30:00	AAPL	Stock	115.2275	115.395	115.125	115.2875	222784.0
2020-08-14 08:00:00	AAPL	Stock	114.7932	115.385	114.575	115.1325	331620.0
2020-08-14 08:30:00	AAPL	Stock	115.1	115.3125	114.9875	115.12	194508.0
2020-08-14 09:00:00	AAPL	Stock	115.135	115.1775	114.6375	114.6525	299868.0
2020-08-14 09:30:00	AAPL	Stock	114.7425	114.895	113.4225	113.88	21077908.0
2020-08-14 10:00:00	AAPL	Stock	113.8525	114.0625	113.3275	113.345	9988956.0
2020-08-14 10:30:00	AAPL	Stock	113.36	113.8275	113.226	113.3075	9575464.0
2020-08-14 11:00:00	AAPL	Stock	113.3025	113.695	113.045	113.655	10691516.0
2020-08-14 11:30:00	AAPL	Stock	113.655	114.0575	113.6125	113.945	9588048.0
2020-08-14 12:00:00	AAPL	Stock	113.95	114.4675	113.8862	114.4092	8872184.0
2020-08-14 12:30:00	AAPL	Stock	114.415	114.8675	114.3475	114.586	10051996.0
2020-08-14 13:00:00	AAPL	Stock	114.5825	114.825	114.35	114.785	7603600.0
2020-08-14 13:30:00	AAPL	Stock	114.7775	114.835	114.4275	114.6555	6046320.0
2020-08-14 14:00:00	AAPL	Stock	114.6462	114.6775	114.14	114.3175	5177500.0
2020-08-14 14:30:00	AAPL	Stock	114.3232	114.49	114.2275	114.2882	4559016.0
2020-08-14 15:00:00	AAPL	Stock	114.2818	114.4625	113.9725	114.1665	7106400.0
2020-08-14 15:30:00	AAPL	Stock	114.1688	115.0	114.0525	114.945	11027740.0
2020-08-14 16:00:00	AAPL	Stock	114.9075	114.91	114.78	114.825	5723960.0
2020-08-14 16:30:00	AAPL	Stock	114.825	114.8575	114.78	114.8	73336.0
2020-08-14 17:00:00	AAPL	Stock	114.8	114.85	114.785	114.8125	38348.0
2020-08-14 17:30:00	AAPL	Stock	114.795	114.875	114.75	114.875	48608.0
2020-08-14 18:00:00	AAPL	Stock	114.875	114.875	114.825	114.83	8692.0
2020-08-14 18:30:00	AAPL	Stock	114.8275	114.86	114.8	114.8	15120.0
2020-08-14 19:00:00	AAPL	Stock	114.7875	114.8125	114.7875	114.7875	23528.0
2020-08-14 19:30:00	AAPL	Stock	114.7875	114.825	114.7775	114.8225	62276.0
2020-08-14 04:00:00	MSFT	Stock	209.34	209.34	208.61	208.8	4539.0
2020-08-14 04:30:00	MSFT	Stock	209.0	209.0	209.0	209.0	100.0
2020-08-14 05:00:00	MSFT	Stock	208.86	209.0	208.7	209.0	727.0
2020-08-14 05:30:00	MSFT	Stock	208.8	208.8	208.8	208.8	1253.0
2020-08-14 06:00:00	MSFT	Stock	208.77	208.88	208.11	208.88	5883.0
2020-08-14 06:30:00	MSFT	Stock	208.89	209.3	208.89	209.29	1948.0
2020-08-14 07:00:00	MSFT	Stock	209.2	209.44	208.98	209.32	9010.0
2020-08-14 07:30:00	MSFT	Stock	209.42	209.47	209.12	209.4	5987.0
2020-08-14 08:00:00	MSFT	Stock	209.1	209.64	208.97	209.17	18743.0
2020-08-14 08:30:00	MSFT	Stock	209.06	209.21	208.872	209.21	15266.0
2020-08-14 09:00:00	MSFT	Stock	209.1	209.24	208.5	208.77	35164.0
2020-08-14 09:30:00	MSFT	Stock	208.71	209.59	208.05	208.5	1904591.0
2020-08-14 10:00:00	MSFT	Stock	208.509	208.75	207.59	207.7	1111635.0
2020-08-14 10:30:00	MSFT	Stock	207.695	208.5	207.51	207.815	826560.0
2020-08-14 11:00:00	MSFT	Stock	207.82	208.62	207.69	208.575	917791.0
2020-08-14 11:30:00	MSFT	Stock	208.59	209.05	208.1	208.253	875380.0
2020-08-14 12:00:00	MSFT	Stock	208.31	208.818	208.28	208.48	560604.0
2020-08-14 12:30:00	MSFT	Stock	208.52	209.24	208.488	208.9	652562.0

> showing 50 of 95,961 rows — these rows as CSV

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