PREVIEW / stock_30min / 2019-09-25

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-25.parquet
  size:    1.7 MB
  rows:    84,044
  symbols: 2,529

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
2019-09-25 04:00:00	AAPL	Stock	54.28	54.28	54.2	54.2175	5336.0
2019-09-25 04:30:00	AAPL	Stock	54.2125	54.275	54.175	54.175	15268.0
2019-09-25 05:00:00	AAPL	Stock	54.1375	54.1825	54.1375	54.1825	1600.0
2019-09-25 05:30:00	AAPL	Stock	54.085	54.1875	54.075	54.15	6480.0
2019-09-25 06:00:00	AAPL	Stock	54.225	54.3	54.225	54.255	10788.0
2019-09-25 06:30:00	AAPL	Stock	54.25	54.3	54.25	54.3	17708.0
2019-09-25 07:00:00	AAPL	Stock	54.2825	54.4125	54.25	54.26	103196.0
2019-09-25 07:30:00	AAPL	Stock	54.325	54.325	54.25	54.325	45544.0
2019-09-25 08:00:00	AAPL	Stock	54.4125	54.55	54.255	54.5275	168828.0
2019-09-25 08:30:00	AAPL	Stock	54.545	54.675	54.5125	54.675	159352.0
2019-09-25 09:00:00	AAPL	Stock	54.6975	54.7125	54.54	54.69	199496.0
2019-09-25 09:30:00	AAPL	Stock	54.6875	54.92	54.4388	54.5025	10180592.0
2019-09-25 10:00:00	AAPL	Stock	54.5	54.8475	54.285	54.79	8665052.0
2019-09-25 10:30:00	AAPL	Stock	54.785	55.015	54.7235	54.875	6508036.0
2019-09-25 11:00:00	AAPL	Stock	54.875	55.1375	54.83	55.0025	5327876.0
2019-09-25 11:30:00	AAPL	Stock	55.0012	55.125	54.94	55.0675	3639140.0
2019-09-25 12:00:00	AAPL	Stock	55.0625	55.2325	55.0625	55.1775	3382644.0
2019-09-25 12:30:00	AAPL	Stock	55.1725	55.21	54.985	55.0425	2628520.0
2019-09-25 13:00:00	AAPL	Stock	55.04	55.0925	54.9602	55.0	2430520.0
2019-09-25 13:30:00	AAPL	Stock	55.01	55.1325	54.975	55.1275	2225504.0
2019-09-25 14:00:00	AAPL	Stock	55.13	55.225	55.0525	55.0525	2863100.0
2019-09-25 14:30:00	AAPL	Stock	55.0558	55.1675	55.0	55.1375	2922000.0
2019-09-25 15:00:00	AAPL	Stock	55.1375	55.2925	55.105	55.255	4437876.0
2019-09-25 15:30:00	AAPL	Stock	55.255	55.375	55.2	55.2475	7342564.0
2019-09-25 16:00:00	AAPL	Stock	55.2575	55.305	55.205	55.2325	8247044.0
2019-09-25 16:30:00	AAPL	Stock	55.2175	55.25	55.2175	55.24	10516.0
2019-09-25 17:00:00	AAPL	Stock	55.2575	55.2575	55.2175	55.2275	62456.0
2019-09-25 17:30:00	AAPL	Stock	55.2325	55.2575	55.2125	55.24	10280.0
2019-09-25 18:00:00	AAPL	Stock	55.2275	55.29	55.2275	55.25	18616.0
2019-09-25 18:30:00	AAPL	Stock	55.245	55.25	55.2325	55.25	13684.0
2019-09-25 19:00:00	AAPL	Stock	55.2325	55.2325	55.175	55.175	41440.0
2019-09-25 19:30:00	AAPL	Stock	55.1625	55.2425	55.1625	55.225	30460.0
2019-09-25 04:00:00	MSFT	Stock	137.17	137.38	137.17	137.38	500.0
2019-09-25 04:30:00	MSFT	Stock	137.0	137.0	136.8	136.8	200.0
2019-09-25 05:00:00	MSFT	Stock	136.73	136.73	136.62	136.62	350.0
2019-09-25 05:30:00	MSFT	Stock	136.83	136.83	136.83	136.83	200.0
2019-09-25 06:30:00	MSFT	Stock	136.97	136.97	136.97	136.97	100.0
2019-09-25 07:00:00	MSFT	Stock	137.23	137.23	136.98	136.99	3611.0
2019-09-25 07:30:00	MSFT	Stock	136.99	137.1	136.88	136.95	1686.0
2019-09-25 08:00:00	MSFT	Stock	136.883	137.44	136.883	137.44	19471.0
2019-09-25 08:30:00	MSFT	Stock	137.496	137.5	137.3	137.5	3967.0
2019-09-25 09:00:00	MSFT	Stock	137.42	137.7	137.16	137.59	13026.0
2019-09-25 09:30:00	MSFT	Stock	137.63	137.63	136.27	136.68	2054323.0
2019-09-25 10:00:00	MSFT	Stock	136.7	137.35	136.03	137.34	1631970.0
2019-09-25 10:30:00	MSFT	Stock	137.34	137.73	136.923	137.37	1135483.0
2019-09-25 11:00:00	MSFT	Stock	137.37	138.06	137.35	137.7	1051597.0
2019-09-25 11:30:00	MSFT	Stock	137.7	137.87	137.445	137.765	645885.0
2019-09-25 12:00:00	MSFT	Stock	137.765	138.23	137.76	137.95	919133.0
2019-09-25 12:30:00	MSFT	Stock	137.95	138.156	137.851	138.0	716756.0
2019-09-25 13:00:00	MSFT	Stock	138.0	138.25	137.94	138.07	525112.0

> showing 50 of 84,044 rows — these rows as CSV

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