PREVIEW / stock_30min / 2020-05-19

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-19.parquet
  size:    1.9 MB
  rows:    93,592
  symbols: 2,388

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-19 04:00:00	AAPL	Stock	79.0025	79.0125	78.5025	78.5025	18360.0
2020-05-19 04:30:00	AAPL	Stock	78.5325	78.6625	78.5325	78.625	5804.0
2020-05-19 05:00:00	AAPL	Stock	78.6375	78.64	78.6175	78.6175	1600.0
2020-05-19 05:30:00	AAPL	Stock	78.625	78.625	78.625	78.625	1488.0
2020-05-19 06:00:00	AAPL	Stock	78.5375	78.5375	78.3875	78.3875	5500.0
2020-05-19 06:30:00	AAPL	Stock	78.425	78.61	78.425	78.575	2600.0
2020-05-19 07:00:00	AAPL	Stock	78.575	78.9725	78.525	78.9625	73928.0
2020-05-19 07:30:00	AAPL	Stock	78.9375	78.9975	78.875	78.875	69004.0
2020-05-19 08:00:00	AAPL	Stock	78.6225	79.0	78.575	78.815	99316.0
2020-05-19 08:30:00	AAPL	Stock	78.8375	78.975	78.8375	78.95	80520.0
2020-05-19 09:00:00	AAPL	Stock	78.9428	78.97	78.75	78.7575	147872.0
2020-05-19 09:30:00	AAPL	Stock	78.7575	79.4	78.6875	79.37	12812016.0
2020-05-19 10:00:00	AAPL	Stock	79.3675	79.63	79.2825	79.445	9888768.0
2020-05-19 10:30:00	AAPL	Stock	79.4475	79.5	79.155	79.46	6190760.0
2020-05-19 11:00:00	AAPL	Stock	79.4525	79.4888	79.235	79.425	5487328.0
2020-05-19 11:30:00	AAPL	Stock	79.42	79.47	79.165	79.3225	4323956.0
2020-05-19 12:00:00	AAPL	Stock	79.3275	79.375	79.07	79.205	3627688.0
2020-05-19 12:30:00	AAPL	Stock	79.21	79.4125	79.16	79.38	3572348.0
2020-05-19 13:00:00	AAPL	Stock	79.38	79.4475	79.285	79.39	2990156.0
2020-05-19 13:30:00	AAPL	Stock	79.39	79.465	79.2772	79.31	2383064.0
2020-05-19 14:00:00	AAPL	Stock	79.3075	79.3975	79.1425	79.145	3626160.0
2020-05-19 14:30:00	AAPL	Stock	79.145	79.3125	78.6425	78.7175	5155428.0
2020-05-19 15:00:00	AAPL	Stock	78.7225	79.245	78.6275	78.9875	7179596.0
2020-05-19 15:30:00	AAPL	Stock	78.985	78.985	78.2525	78.2525	10990836.0
2020-05-19 16:00:00	AAPL	Stock	78.285	78.3625	78.25	78.29	5841944.0
2020-05-19 16:30:00	AAPL	Stock	78.3125	78.35	78.275	78.325	35852.0
2020-05-19 17:00:00	AAPL	Stock	78.3	78.3125	78.275	78.3025	10004.0
2020-05-19 17:30:00	AAPL	Stock	78.29	78.3	78.285	78.295	9352.0
2020-05-19 18:00:00	AAPL	Stock	78.285	78.3875	78.25	78.325	95440.0
2020-05-19 18:30:00	AAPL	Stock	78.345	78.3975	78.175	78.3975	38084.0
2020-05-19 19:00:00	AAPL	Stock	78.4125	78.625	78.375	78.5125	87048.0
2020-05-19 19:30:00	AAPL	Stock	78.5725	78.6475	78.5	78.635	72228.0
2020-05-19 04:00:00	MSFT	Stock	185.45	185.45	185.0	185.0	900.0
2020-05-19 04:30:00	MSFT	Stock	184.9	185.79	184.85	185.61	5426.0
2020-05-19 05:00:00	MSFT	Stock	185.36	185.41	185.3	185.32	762.0
2020-05-19 05:30:00	MSFT	Stock	185.41	185.56	185.41	185.56	719.0
2020-05-19 06:00:00	MSFT	Stock	185.41	185.41	184.8	184.81	3301.0
2020-05-19 06:30:00	MSFT	Stock	185.06	185.06	185.06	185.06	200.0
2020-05-19 07:00:00	MSFT	Stock	185.2	185.68	185.2	185.68	7004.0
2020-05-19 07:30:00	MSFT	Stock	185.65	185.82	185.0	185.32	17422.0
2020-05-19 08:00:00	MSFT	Stock	185.08	185.69	185.01	185.2	11489.0
2020-05-19 08:30:00	MSFT	Stock	185.2	185.55	185.2	185.35	10627.0
2020-05-19 09:00:00	MSFT	Stock	185.35	185.36	185.0	185.0	16167.0
2020-05-19 09:30:00	MSFT	Stock	185.0	186.25	184.59	185.83	3342014.0
2020-05-19 10:00:00	MSFT	Stock	185.8	186.6	185.64	185.99	2171507.0
2020-05-19 10:30:00	MSFT	Stock	186.01	186.19	185.39	186.04	1402455.0
2020-05-19 11:00:00	MSFT	Stock	186.04	186.07	185.6	186.05	1334631.0
2020-05-19 11:30:00	MSFT	Stock	186.05	186.07	185.43	185.865	1228633.0
2020-05-19 12:00:00	MSFT	Stock	185.86	185.96	185.425	185.57	903088.0
2020-05-19 12:30:00	MSFT	Stock	185.57	185.77	185.24	185.617	840185.0

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

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