PREVIEW / stock_30min / 2017-02-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-27.parquet
  size:    1.6 MB
  rows:    83,190
  symbols: 3,107

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
2017-02-27 04:00:00	AAPL	Stock	34.125	34.125	34.125	34.125	800.0
2017-02-27 06:00:00	AAPL	Stock	34.1525	34.2525	34.15	34.25	41544.0
2017-02-27 06:30:00	AAPL	Stock	34.25	34.3225	34.25	34.3125	64640.0
2017-02-27 07:00:00	AAPL	Stock	34.3125	34.325	34.215	34.275	128404.0
2017-02-27 07:30:00	AAPL	Stock	34.275	34.2875	34.2325	34.25	76380.0
2017-02-27 08:00:00	AAPL	Stock	34.25	34.3125	34.2125	34.2425	189152.0
2017-02-27 08:30:00	AAPL	Stock	34.24	34.285	34.2325	34.2475	128240.0
2017-02-27 09:00:00	AAPL	Stock	34.25	34.325	34.25	34.2525	457116.0
2017-02-27 09:30:00	AAPL	Stock	34.26	34.2875	34.07	34.27	17183292.0
2017-02-27 10:00:00	AAPL	Stock	34.2725	34.3588	34.225	34.3388	8497084.0
2017-02-27 10:30:00	AAPL	Stock	34.3388	34.345	34.2575	34.26	5115584.0
2017-02-27 11:00:00	AAPL	Stock	34.2622	34.2925	34.23	34.2458	4548088.0
2017-02-27 11:30:00	AAPL	Stock	34.2463	34.265	34.1925	34.25	4342476.0
2017-02-27 12:00:00	AAPL	Stock	34.2518	34.2725	34.2262	34.2675	2354564.0
2017-02-27 12:30:00	AAPL	Stock	34.2675	34.275	34.2275	34.2463	2184604.0
2017-02-27 13:00:00	AAPL	Stock	34.2463	34.2975	34.245	34.29	2310492.0
2017-02-27 13:30:00	AAPL	Stock	34.2888	34.31	34.26	34.265	2595580.0
2017-02-27 14:00:00	AAPL	Stock	34.265	34.2778	34.2325	34.2575	2122304.0
2017-02-27 14:30:00	AAPL	Stock	34.259	34.28	34.2425	34.2425	2280548.0
2017-02-27 15:00:00	AAPL	Stock	34.2425	34.2672	34.2325	34.265	2899824.0
2017-02-27 15:30:00	AAPL	Stock	34.2625	34.275	34.2025	34.235	6571936.0
2017-02-27 16:00:00	AAPL	Stock	34.24	34.24	34.205	34.2125	8701208.0
2017-02-27 16:30:00	AAPL	Stock	34.2125	34.2125	34.19	34.19	56072.0
2017-02-27 17:00:00	AAPL	Stock	34.19	34.225	34.1875	34.225	37016.0
2017-02-27 17:30:00	AAPL	Stock	34.23	34.23	34.2025	34.2075	7208.0
2017-02-27 18:00:00	AAPL	Stock	34.2075	34.2275	34.2	34.225	4824.0
2017-02-27 18:30:00	AAPL	Stock	34.225	34.225	34.175	34.175	24264.0
2017-02-27 19:00:00	AAPL	Stock	34.2225	34.2225	34.2	34.2	48040.0
2017-02-27 19:30:00	AAPL	Stock	34.2	34.2	34.18	34.18	25620.0
2017-02-27 08:00:00	MSFT	Stock	64.51	64.51	64.51	64.51	200.0
2017-02-27 08:30:00	MSFT	Stock	64.51	64.57	64.51	64.57	358.0
2017-02-27 09:00:00	MSFT	Stock	64.51	64.51	64.41	64.41	12018.0
2017-02-27 09:30:00	MSFT	Stock	64.54	64.54	64.045	64.185	2615526.0
2017-02-27 10:00:00	MSFT	Stock	64.19	64.24	64.06	64.14	1280200.0
2017-02-27 10:30:00	MSFT	Stock	64.14	64.21	64.1	64.125	1262992.0
2017-02-27 11:00:00	MSFT	Stock	64.13	64.21	64.09	64.155	755663.0
2017-02-27 11:30:00	MSFT	Stock	64.156	64.16	64.05	64.08	569515.0
2017-02-27 12:00:00	MSFT	Stock	64.075	64.12	64.055	64.12	450062.0
2017-02-27 12:30:00	MSFT	Stock	64.115	64.12	64.06	64.09	605388.0
2017-02-27 13:00:00	MSFT	Stock	64.09	64.13	64.08	64.11	620954.0
2017-02-27 13:30:00	MSFT	Stock	64.11	64.19	64.1	64.19	568997.0
2017-02-27 14:00:00	MSFT	Stock	64.18	64.2	64.13	64.15	513099.0
2017-02-27 14:30:00	MSFT	Stock	64.14	64.18	64.09	64.17	749542.0
2017-02-27 15:00:00	MSFT	Stock	64.165	64.26	64.16	64.26	1250805.0
2017-02-27 15:30:00	MSFT	Stock	64.25	64.3	64.17	64.22	2288857.0
2017-02-27 16:00:00	MSFT	Stock	64.23	64.25	64.19	64.25	1208181.0
2017-02-27 16:30:00	MSFT	Stock	64.24	64.24	64.22	64.22	472.0
2017-02-27 17:30:00	MSFT	Stock	64.22	64.22	64.22	64.22	160.0
2017-02-27 18:30:00	MSFT	Stock	64.21	64.22	64.17	64.17	350.0
2017-02-27 19:00:00	MSFT	Stock	64.22	64.22	64.22	64.22	200.0

> showing 50 of 83,190 rows — these rows as CSV

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