PREVIEW / stock_30min / 2020-05-11

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-11.parquet
  size:    1.9 MB
  rows:    97,016
  symbols: 2,381

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-05-11 04:00:00	AAPL	Stock	77.785	77.9125	77.6375	77.645	25184.0
2020-05-11 04:30:00	AAPL	Stock	77.6475	77.65	77.355	77.375	60524.0
2020-05-11 05:00:00	AAPL	Stock	77.375	77.375	77.15	77.2875	31372.0
2020-05-11 05:30:00	AAPL	Stock	77.3325	77.4375	77.3325	77.4025	21316.0
2020-05-11 06:00:00	AAPL	Stock	77.4	77.425	77.1625	77.1625	10224.0
2020-05-11 06:30:00	AAPL	Stock	77.125	77.2	77.0025	77.165	20584.0
2020-05-11 07:00:00	AAPL	Stock	77.1875	77.3225	77.125	77.175	212452.0
2020-05-11 07:30:00	AAPL	Stock	77.175	77.225	76.87	76.95	348536.0
2020-05-11 08:00:00	AAPL	Stock	77.0	77.3125	76.8	76.855	406108.0
2020-05-11 08:30:00	AAPL	Stock	76.855	76.9125	76.7525	76.8375	254996.0
2020-05-11 09:00:00	AAPL	Stock	76.8375	77.1	76.825	77.0325	320280.0
2020-05-11 09:30:00	AAPL	Stock	77.03	77.6225	76.81	77.4625	18107684.0
2020-05-11 10:00:00	AAPL	Stock	77.4525	78.0775	77.43	78.025	13286436.0
2020-05-11 10:30:00	AAPL	Stock	78.0212	78.16	77.8825	77.9818	9575340.0
2020-05-11 11:00:00	AAPL	Stock	77.99	78.359	77.9725	78.3375	7935644.0
2020-05-11 11:30:00	AAPL	Stock	78.335	78.4575	78.2575	78.3188	6132404.0
2020-05-11 12:00:00	AAPL	Stock	78.315	78.41	78.2325	78.3675	4731804.0
2020-05-11 12:30:00	AAPL	Stock	78.37	78.435	78.1725	78.3105	4665664.0
2020-05-11 13:00:00	AAPL	Stock	78.31	78.7	78.235	78.68	7315832.0
2020-05-11 13:30:00	AAPL	Stock	78.68	78.8025	78.645	78.7125	7462504.0
2020-05-11 14:00:00	AAPL	Stock	78.7075	78.87	78.6275	78.77	6149496.0
2020-05-11 14:30:00	AAPL	Stock	78.765	79.0675	78.75	79.0125	6610440.0
2020-05-11 15:00:00	AAPL	Stock	79.015	79.2625	78.9375	79.0	9551744.0
2020-05-11 15:30:00	AAPL	Stock	78.9975	79.09	78.7475	78.7512	10697080.0
2020-05-11 16:00:00	AAPL	Stock	78.7525	78.81	78.675	78.74	4710456.0
2020-05-11 16:30:00	AAPL	Stock	78.7375	78.75	78.6425	78.74	43056.0
2020-05-11 17:00:00	AAPL	Stock	78.7425	78.7575	78.69	78.7325	21828.0
2020-05-11 17:30:00	AAPL	Stock	78.7375	78.7875	78.7375	78.7375	27464.0
2020-05-11 18:00:00	AAPL	Stock	78.7475	78.9625	78.7475	78.95	37324.0
2020-05-11 18:30:00	AAPL	Stock	78.9375	78.9875	78.8125	78.945	89104.0
2020-05-11 19:00:00	AAPL	Stock	78.875	78.95	78.82	78.825	85156.0
2020-05-11 19:30:00	AAPL	Stock	78.825	78.9	78.79	78.8025	54752.0
2020-05-11 04:00:00	MSFT	Stock	185.51	185.51	184.75	184.75	5217.0
2020-05-11 04:30:00	MSFT	Stock	184.99	184.99	184.0	184.27	17482.0
2020-05-11 05:00:00	MSFT	Stock	184.15	184.15	183.91	184.1	3351.0
2020-05-11 05:30:00	MSFT	Stock	184.1	184.57	184.1	184.33	3472.0
2020-05-11 06:00:00	MSFT	Stock	183.82	184.38	183.8	183.82	3136.0
2020-05-11 06:30:00	MSFT	Stock	183.8	183.97	183.78	183.97	3452.0
2020-05-11 07:00:00	MSFT	Stock	183.97	184.2	183.82	183.9	11147.0
2020-05-11 07:30:00	MSFT	Stock	183.85	184.0	183.1	183.14	10708.0
2020-05-11 08:00:00	MSFT	Stock	183.85	184.1	182.75	183.139	63956.0
2020-05-11 08:30:00	MSFT	Stock	182.92	183.135	182.7	183.094	22916.0
2020-05-11 09:00:00	MSFT	Stock	183.14	183.47	183.0	183.1	41317.0
2020-05-11 09:30:00	MSFT	Stock	183.11	185.104	182.85	184.52	3573760.0
2020-05-11 10:00:00	MSFT	Stock	184.52	185.46	184.45	185.085	1905849.0
2020-05-11 10:30:00	MSFT	Stock	185.075	185.48	184.63	185.025	1728184.0
2020-05-11 11:00:00	MSFT	Stock	185.03	185.495	184.95	185.486	1381668.0
2020-05-11 11:30:00	MSFT	Stock	185.49	185.578	185.26	185.45	1034878.0
2020-05-11 12:00:00	MSFT	Stock	185.44	185.69	185.22	185.675	929387.0
2020-05-11 12:30:00	MSFT	Stock	185.675	185.79	185.33	185.78	1233949.0

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

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