PREVIEW / stock_30min / 2020-08-05

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-05.parquet
  size:    2.0 MB
  rows:    99,443
  symbols: 2,438

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-05 04:00:00	AAPL	Stock	110.205	110.41	110.1525	110.245	18220.0
2020-08-05 04:30:00	AAPL	Stock	110.1675	110.325	110.04	110.325	11576.0
2020-08-05 05:00:00	AAPL	Stock	110.325	110.4275	110.3	110.4275	10432.0
2020-08-05 05:30:00	AAPL	Stock	110.3925	110.745	110.25	110.705	25400.0
2020-08-05 06:00:00	AAPL	Stock	110.6325	110.6325	109.1875	109.6575	208824.0
2020-08-05 06:30:00	AAPL	Stock	109.74	109.7575	109.245	109.3075	72060.0
2020-08-05 07:00:00	AAPL	Stock	109.5	109.75	109.3625	109.4	240984.0
2020-08-05 07:30:00	AAPL	Stock	109.4	109.6875	109.375	109.4125	154524.0
2020-08-05 08:00:00	AAPL	Stock	109.4125	109.9375	109.0625	109.295	601804.0
2020-08-05 08:30:00	AAPL	Stock	109.295	109.3675	109.125	109.185	306984.0
2020-08-05 09:00:00	AAPL	Stock	109.2	109.47	109.145	109.4	368820.0
2020-08-05 09:30:00	AAPL	Stock	109.4025	110.3925	108.8975	110.0875	18423280.0
2020-08-05 10:00:00	AAPL	Stock	110.0875	110.2425	109.85	110.1068	8482140.0
2020-08-05 10:30:00	AAPL	Stock	110.1	110.115	109.2325	109.242	8748548.0
2020-08-05 11:00:00	AAPL	Stock	109.2438	109.7475	109.2325	109.4975	5838312.0
2020-08-05 11:30:00	AAPL	Stock	109.4975	109.576	109.325	109.4255	3667832.0
2020-08-05 12:00:00	AAPL	Stock	109.4325	109.6075	109.3325	109.38	3747704.0
2020-08-05 12:30:00	AAPL	Stock	109.3675	109.4375	109.015	109.2232	5038592.0
2020-08-05 13:00:00	AAPL	Stock	109.23	109.475	109.21	109.322	3484680.0
2020-08-05 13:30:00	AAPL	Stock	109.325	109.4638	109.2575	109.2812	2626196.0
2020-08-05 14:00:00	AAPL	Stock	109.28	109.395	109.1525	109.3575	2875316.0
2020-08-05 14:30:00	AAPL	Stock	109.36	109.9175	109.33	109.8425	7072328.0
2020-08-05 15:00:00	AAPL	Stock	109.835	109.8425	109.4425	109.7238	5558788.0
2020-08-05 15:30:00	AAPL	Stock	109.73	110.1225	109.69	110.0848	10415092.0
2020-08-05 16:00:00	AAPL	Stock	110.075	110.075	109.9125	109.9675	7456432.0
2020-08-05 16:30:00	AAPL	Stock	109.9625	110.0	109.9025	110.0	24484.0
2020-08-05 17:00:00	AAPL	Stock	109.9875	109.9875	109.88	109.9125	33680.0
2020-08-05 17:30:00	AAPL	Stock	109.865	109.865	109.8	109.86	20952.0
2020-08-05 18:00:00	AAPL	Stock	109.8375	109.85	109.75	109.85	45992.0
2020-08-05 18:30:00	AAPL	Stock	109.815	109.85	109.8125	109.8175	22104.0
2020-08-05 19:00:00	AAPL	Stock	109.825	109.9375	109.825	109.8275	42272.0
2020-08-05 19:30:00	AAPL	Stock	109.875	109.875	109.8175	109.85	47500.0
2020-08-05 04:00:00	MSFT	Stock	214.02	214.63	214.02	214.1	3952.0
2020-08-05 04:30:00	MSFT	Stock	214.02	214.21	214.02	214.21	500.0
2020-08-05 05:00:00	MSFT	Stock	214.3	214.4	214.21	214.23	4465.0
2020-08-05 05:30:00	MSFT	Stock	214.31	214.48	214.21	214.21	1564.0
2020-08-05 06:00:00	MSFT	Stock	214.34	214.35	214.03	214.14	5815.0
2020-08-05 06:30:00	MSFT	Stock	214.03	214.05	214.0	214.0	1768.0
2020-08-05 07:00:00	MSFT	Stock	213.98	214.26	213.63	214.18	19801.0
2020-08-05 07:30:00	MSFT	Stock	214.14	214.3	214.0	214.05	17972.0
2020-08-05 08:00:00	MSFT	Stock	213.779	214.3	213.16	213.43	77952.0
2020-08-05 08:30:00	MSFT	Stock	213.43	213.59	212.75	212.9	37061.0
2020-08-05 09:00:00	MSFT	Stock	212.92	216.35	212.85	214.89	501714.0
2020-08-05 09:30:00	MSFT	Stock	214.89	215.0	212.075	214.19	4497543.0
2020-08-05 10:00:00	MSFT	Stock	214.21	214.4	212.88	213.81	2218622.0
2020-08-05 10:30:00	MSFT	Stock	213.82	213.848	212.94	213.09	1380425.0
2020-08-05 11:00:00	MSFT	Stock	213.09	213.9	212.65	212.98	1473990.0
2020-08-05 11:30:00	MSFT	Stock	212.972	213.09	212.28	212.4	1307586.0
2020-08-05 12:00:00	MSFT	Stock	212.4	213.04	212.31	212.46	969973.0
2020-08-05 12:30:00	MSFT	Stock	212.455	213.08	212.4	213.03	840420.0

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

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