PREVIEW / stock_30min / 2018-01-04

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-04.parquet
  size:    1.7 MB
  rows:    85,193
  symbols: 2,925

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
2018-01-04 04:00:00	AAPL	Stock	43.1	43.1025	43.1	43.1	4312.0
2018-01-04 05:00:00	AAPL	Stock	43.15	43.2	43.15	43.2	6508.0
2018-01-04 06:00:00	AAPL	Stock	43.1525	43.1525	43.125	43.1525	19460.0
2018-01-04 06:30:00	AAPL	Stock	43.1525	43.17	43.1525	43.17	2000.0
2018-01-04 07:00:00	AAPL	Stock	43.14	43.1725	43.1325	43.1725	27968.0
2018-01-04 07:30:00	AAPL	Stock	43.1625	43.1925	43.1525	43.1525	34368.0
2018-01-04 08:00:00	AAPL	Stock	43.17	43.22	43.14	43.2075	161872.0
2018-01-04 08:30:00	AAPL	Stock	43.2	43.22	43.18	43.2	101120.0
2018-01-04 09:00:00	AAPL	Stock	43.2	43.2175	43.1475	43.1775	92480.0
2018-01-04 09:30:00	AAPL	Stock	43.135	43.29	43.02	43.235	14457120.0
2018-01-04 10:00:00	AAPL	Stock	43.235	43.3525	43.165	43.2925	7369180.0
2018-01-04 10:30:00	AAPL	Stock	43.295	43.3675	43.2175	43.2388	6946124.0
2018-01-04 11:00:00	AAPL	Stock	43.24	43.305	43.1875	43.2975	5735716.0
2018-01-04 11:30:00	AAPL	Stock	43.2975	43.3675	43.254	43.2575	5108432.0
2018-01-04 12:00:00	AAPL	Stock	43.255	43.304	43.165	43.185	3953664.0
2018-01-04 12:30:00	AAPL	Stock	43.185	43.2575	43.1688	43.21	3077060.0
2018-01-04 13:00:00	AAPL	Stock	43.2075	43.23	43.1675	43.1755	2474064.0
2018-01-04 13:30:00	AAPL	Stock	43.175	43.235	43.15	43.235	3046236.0
2018-01-04 14:00:00	AAPL	Stock	43.2325	43.285	43.2125	43.23	3750224.0
2018-01-04 14:30:00	AAPL	Stock	43.2275	43.2975	43.2125	43.2825	2974728.0
2018-01-04 15:00:00	AAPL	Stock	43.2825	43.2975	43.2375	43.2762	3677944.0
2018-01-04 15:30:00	AAPL	Stock	43.2762	43.31	43.24	43.255	8400032.0
2018-01-04 16:00:00	AAPL	Stock	43.2625	43.295	43.25	43.2925	8825796.0
2018-01-04 16:30:00	AAPL	Stock	43.295	43.305	43.2875	43.305	72880.0
2018-01-04 17:00:00	AAPL	Stock	43.3	43.3075	43.3	43.3075	27388.0
2018-01-04 17:30:00	AAPL	Stock	43.31	43.31	43.2925	43.2925	72596.0
2018-01-04 18:00:00	AAPL	Stock	43.2975	43.3	43.2975	43.2975	16084.0
2018-01-04 18:30:00	AAPL	Stock	43.2975	43.3	43.175	43.245	136760.0
2018-01-04 19:00:00	AAPL	Stock	43.25	43.3	43.225	43.275	75600.0
2018-01-04 19:30:00	AAPL	Stock	43.2975	43.3325	43.2875	43.3325	47084.0
2018-01-04 04:00:00	MSFT	Stock	86.6	86.6	86.6	86.6	200.0
2018-01-04 06:30:00	MSFT	Stock	86.6	86.6	86.6	86.6	4946.0
2018-01-04 07:00:00	MSFT	Stock	86.6	86.64	86.6	86.64	300.0
2018-01-04 07:30:00	MSFT	Stock	86.64	86.69	86.64	86.69	2573.0
2018-01-04 08:00:00	MSFT	Stock	86.6	86.77	86.6	86.77	12575.0
2018-01-04 08:30:00	MSFT	Stock	86.75	86.78	86.7	86.7	4275.0
2018-01-04 09:00:00	MSFT	Stock	86.69	86.78	86.6	86.6	21002.0
2018-01-04 09:30:00	MSFT	Stock	86.59	87.06	86.57	87.01	3511023.0
2018-01-04 10:00:00	MSFT	Stock	87.015	87.53	87.006	87.43	2047466.0
2018-01-04 10:30:00	MSFT	Stock	87.42	87.64	87.37	87.605	1152813.0
2018-01-04 11:00:00	MSFT	Stock	87.61	87.66	87.245	87.48	1131351.0
2018-01-04 11:30:00	MSFT	Stock	87.48	87.65	87.47	87.495	1479062.0
2018-01-04 12:00:00	MSFT	Stock	87.5	87.64	87.45	87.49	820388.0
2018-01-04 12:30:00	MSFT	Stock	87.49	87.5	87.28	87.295	927206.0
2018-01-04 13:00:00	MSFT	Stock	87.295	87.36	87.28	87.3	685505.0
2018-01-04 13:30:00	MSFT	Stock	87.295	87.347	87.245	87.347	576805.0
2018-01-04 14:00:00	MSFT	Stock	87.35	87.39	87.2	87.21	744335.0
2018-01-04 14:30:00	MSFT	Stock	87.215	87.29	87.16	87.21	634290.0
2018-01-04 15:00:00	MSFT	Stock	87.205	87.3	87.18	87.27	836077.0
2018-01-04 15:30:00	MSFT	Stock	87.275	87.29	87.02	87.12	2231453.0

> showing 50 of 85,193 rows — these rows as CSV

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