PREVIEW / stock_30min / 2018-04-19

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-19.parquet
  size:    1.6 MB
  rows:    81,449
  symbols: 2,847

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-04-19 04:00:00	AAPL	Stock	44.325	44.325	44.2075	44.2075	7600.0
2018-04-19 04:30:00	AAPL	Stock	44.2075	44.2075	44.19	44.19	9200.0
2018-04-19 05:00:00	AAPL	Stock	44.125	44.15	44.0125	44.0725	10336.0
2018-04-19 05:30:00	AAPL	Stock	44.0975	44.0975	44.0975	44.0975	736.0
2018-04-19 06:00:00	AAPL	Stock	44.0875	44.0875	43.875	43.885	26880.0
2018-04-19 06:30:00	AAPL	Stock	43.875	43.9125	43.6375	43.7125	60996.0
2018-04-19 07:00:00	AAPL	Stock	43.7125	44.0125	43.7125	43.8625	375272.0
2018-04-19 07:30:00	AAPL	Stock	43.8525	43.8725	43.825	43.825	161988.0
2018-04-19 08:00:00	AAPL	Stock	43.82	44.0	43.6432	43.66	820168.0
2018-04-19 08:30:00	AAPL	Stock	43.6625	43.8025	43.625	43.7225	528928.0
2018-04-19 09:00:00	AAPL	Stock	43.7225	43.9	43.6875	43.725	739140.0
2018-04-19 09:30:00	AAPL	Stock	43.735	43.8475	43.53	43.635	19652524.0
2018-04-19 10:00:00	AAPL	Stock	43.6325	43.66	43.4775	43.495	10897620.0
2018-04-19 10:30:00	AAPL	Stock	43.4925	43.59	43.413	43.4275	9178468.0
2018-04-19 11:00:00	AAPL	Stock	43.4275	43.4825	43.315	43.475	9434924.0
2018-04-19 11:30:00	AAPL	Stock	43.475	43.5025	43.3425	43.35	4882420.0
2018-04-19 12:00:00	AAPL	Stock	43.3475	43.449	43.29	43.3588	6618060.0
2018-04-19 12:30:00	AAPL	Stock	43.3575	43.4362	43.325	43.3375	4555744.0
2018-04-19 13:00:00	AAPL	Stock	43.335	43.4125	43.3	43.3812	3884364.0
2018-04-19 13:30:00	AAPL	Stock	43.3825	43.495	43.37	43.4688	4418556.0
2018-04-19 14:00:00	AAPL	Stock	43.4675	43.4875	43.195	43.2322	7182636.0
2018-04-19 14:30:00	AAPL	Stock	43.23	43.2875	43.165	43.279	6612320.0
2018-04-19 15:00:00	AAPL	Stock	43.2775	43.3475	43.225	43.2338	5831220.0
2018-04-19 15:30:00	AAPL	Stock	43.2345	43.395	43.1925	43.2	19259040.0
2018-04-19 16:00:00	AAPL	Stock	43.1975	43.205	43.1625	43.195	12205804.0
2018-04-19 16:30:00	AAPL	Stock	43.1925	43.2	43.18	43.18	84736.0
2018-04-19 17:00:00	AAPL	Stock	43.175	43.1875	43.15	43.175	62932.0
2018-04-19 17:30:00	AAPL	Stock	43.185	43.185	43.175	43.18	41408.0
2018-04-19 18:00:00	AAPL	Stock	43.18	43.1875	43.165	43.175	81432.0
2018-04-19 18:30:00	AAPL	Stock	43.175	43.1875	43.175	43.175	26016.0
2018-04-19 19:00:00	AAPL	Stock	43.1825	43.185	43.125	43.14	62832.0
2018-04-19 19:30:00	AAPL	Stock	43.13	43.175	43.13	43.15	23400.0
2018-04-19 04:00:00	MSFT	Stock	96.43	96.6	96.43	96.59	3356.0
2018-04-19 04:30:00	MSFT	Stock	96.67	96.69	96.67	96.69	7863.0
2018-04-19 05:00:00	MSFT	Stock	96.6	96.6	96.6	96.6	2200.0
2018-04-19 06:00:00	MSFT	Stock	96.45	96.46	96.45	96.46	526.0
2018-04-19 06:30:00	MSFT	Stock	96.5	96.51	96.31	96.47	9123.0
2018-04-19 07:00:00	MSFT	Stock	96.46	96.66	96.44	96.66	7459.0
2018-04-19 07:30:00	MSFT	Stock	96.66	96.66	96.65	96.66	1323.0
2018-04-19 08:00:00	MSFT	Stock	96.65	96.66	96.31	96.32	13140.0
2018-04-19 08:30:00	MSFT	Stock	96.35	96.49	96.3	96.3	15910.0
2018-04-19 09:00:00	MSFT	Stock	96.3	96.43	96.23	96.43	8511.0
2018-04-19 09:30:00	MSFT	Stock	96.44	96.67	95.97	96.385	2067733.0
2018-04-19 10:00:00	MSFT	Stock	96.39	97.07	96.32	96.93	1928442.0
2018-04-19 10:30:00	MSFT	Stock	96.93	96.93	96.45	96.68	1355082.0
2018-04-19 11:00:00	MSFT	Stock	96.68	96.7	96.13	96.31	1296110.0
2018-04-19 11:30:00	MSFT	Stock	96.3	96.32	95.6	95.638	1279984.0
2018-04-19 12:00:00	MSFT	Stock	95.62	95.7	95.42	95.515	1797832.0
2018-04-19 12:30:00	MSFT	Stock	95.52	95.889	95.45	95.5	1284440.0
2018-04-19 13:00:00	MSFT	Stock	95.48	95.66	95.34	95.525	828852.0

> showing 50 of 81,449 rows — these rows as CSV

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