PREVIEW / stock_30min / 2016-01-06

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-06.parquet
  size:    1.6 MB
  rows:    83,284
  symbols: 3,400

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
2016-01-06 04:00:00	AAPL	Stock	25.56	25.56	25.2225	25.275	38732.0
2016-01-06 04:30:00	AAPL	Stock	25.2675	25.2675	25.1225	25.16	33140.0
2016-01-06 05:00:00	AAPL	Stock	25.1875	25.1875	24.9375	24.975	99804.0
2016-01-06 05:30:00	AAPL	Stock	24.95	25.0	24.915	24.9975	80400.0
2016-01-06 06:00:00	AAPL	Stock	24.9975	25.05	24.955	25.0375	109836.0
2016-01-06 06:30:00	AAPL	Stock	25.05	25.1075	25.05	25.06	191240.0
2016-01-06 07:00:00	AAPL	Stock	25.0625	25.145	25.0275	25.1125	220848.0
2016-01-06 07:30:00	AAPL	Stock	25.1025	25.1875	25.025	25.0525	484628.0
2016-01-06 08:00:00	AAPL	Stock	25.05	25.15	25.0075	25.1	1118336.0
2016-01-06 08:30:00	AAPL	Stock	25.0975	25.17	25.04	25.17	865568.0
2016-01-06 09:00:00	AAPL	Stock	25.1675	25.6902	25.0575	25.1375	1315740.0
2016-01-06 09:30:00	AAPL	Stock	25.14	25.4675	25.055	25.3525	39436692.0
2016-01-06 10:00:00	AAPL	Stock	25.3475	25.5925	25.2475	25.5875	22417556.0
2016-01-06 10:30:00	AAPL	Stock	25.5875	25.5875	25.295	25.3775	14748944.0
2016-01-06 11:00:00	AAPL	Stock	25.3775	25.54	25.365	25.4688	13957408.0
2016-01-06 11:30:00	AAPL	Stock	25.47	25.481	25.2925	25.295	10546976.0
2016-01-06 12:00:00	AAPL	Stock	25.2962	25.329	25.1625	25.1675	17607284.0
2016-01-06 12:30:00	AAPL	Stock	25.1675	25.285	25.089	25.0915	15619616.0
2016-01-06 13:00:00	AAPL	Stock	25.0925	25.19	25.0188	25.1475	16230996.0
2016-01-06 13:30:00	AAPL	Stock	25.1488	25.1725	25.0625	25.074	8471852.0
2016-01-06 14:00:00	AAPL	Stock	25.075	25.2342	25.05	25.1462	13489724.0
2016-01-06 14:30:00	AAPL	Stock	25.1475	25.1675	24.99	25.025	22800116.0
2016-01-06 15:00:00	AAPL	Stock	25.0275	25.0725	24.9675	25.0615	22165444.0
2016-01-06 15:30:00	AAPL	Stock	25.0625	25.185	25.04	25.175	23001688.0
2016-01-06 16:00:00	AAPL	Stock	25.175	25.4545	25.06	25.1975	8818932.0
2016-01-06 16:30:00	AAPL	Stock	25.2	25.2125	25.17	25.2	169968.0
2016-01-06 17:00:00	AAPL	Stock	25.21	25.235	25.1925	25.2	82756.0
2016-01-06 17:30:00	AAPL	Stock	25.195	25.22	25.1925	25.22	42604.0
2016-01-06 18:00:00	AAPL	Stock	25.215	25.235	25.21	25.2125	41896.0
2016-01-06 18:30:00	AAPL	Stock	25.2	25.2225	25.1875	25.2225	66688.0
2016-01-06 19:00:00	AAPL	Stock	25.215	25.2425	25.205	25.2375	28912.0
2016-01-06 19:30:00	AAPL	Stock	25.225	25.2425	25.205	25.24	57568.0
2016-01-06 04:00:00	MSFT	Stock	54.9	54.9	54.9	54.9	1000.0
2016-01-06 05:00:00	MSFT	Stock	54.4	54.4	54.35	54.35	3500.0
2016-01-06 05:30:00	MSFT	Stock	54.38	54.38	54.38	54.38	100.0
2016-01-06 06:00:00	MSFT	Stock	54.38	54.4	54.0	54.4	2127.0
2016-01-06 06:30:00	MSFT	Stock	54.37	54.4	54.37	54.4	2750.0
2016-01-06 07:00:00	MSFT	Stock	54.4	54.4	54.22	54.26	14250.0
2016-01-06 07:30:00	MSFT	Stock	54.25	54.26	54.13	54.13	27378.0
2016-01-06 08:00:00	MSFT	Stock	54.2	54.3	54.01	54.26	25996.0
2016-01-06 08:30:00	MSFT	Stock	54.3	54.35	54.14	54.24	20782.0
2016-01-06 09:00:00	MSFT	Stock	54.26	55.078	54.22	54.26	40188.0
2016-01-06 09:30:00	MSFT	Stock	54.26	54.4	54.14	54.29	4885808.0
2016-01-06 10:00:00	MSFT	Stock	54.28	54.305	54.1	54.265	3304888.0
2016-01-06 10:30:00	MSFT	Stock	54.26	54.28	54.05	54.207	2654160.0
2016-01-06 11:00:00	MSFT	Stock	54.2	54.25	53.77	54.16	3386377.0
2016-01-06 11:30:00	MSFT	Stock	54.16	54.27	54.11	54.14	2208596.0
2016-01-06 12:00:00	MSFT	Stock	54.15	54.23	54.1	54.19	1199546.0
2016-01-06 12:30:00	MSFT	Stock	54.19	54.31	54.14	54.185	1316724.0
2016-01-06 13:00:00	MSFT	Stock	54.18	54.22	54.04	54.075	1194657.0

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

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