PREVIEW / stock_30min / 2015-06-08

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-08.parquet
  size:    1.6 MB
  rows:    82,224
  symbols: 3,503

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
2015-06-08 04:00:00	AAPL	Stock	32.25	32.25	32.17	32.1875	29004.0
2015-06-08 04:30:00	AAPL	Stock	32.19	32.2125	32.19	32.2125	4800.0
2015-06-08 05:00:00	AAPL	Stock	32.205	32.205	32.205	32.205	3220.0
2015-06-08 05:30:00	AAPL	Stock	32.225	32.2375	32.225	32.2375	6592.0
2015-06-08 06:00:00	AAPL	Stock	32.22	32.225	32.19	32.2	7412.0
2015-06-08 06:30:00	AAPL	Stock	32.22	32.23	32.2	32.205	23912.0
2015-06-08 07:00:00	AAPL	Stock	32.2	32.2125	32.195	32.2025	52516.0
2015-06-08 07:30:00	AAPL	Stock	32.21	32.275	32.21	32.255	67120.0
2015-06-08 08:00:00	AAPL	Stock	32.2575	32.275	32.2	32.2375	391632.0
2015-06-08 08:30:00	AAPL	Stock	32.2425	32.2675	32.2075	32.21	243116.0
2015-06-08 09:00:00	AAPL	Stock	32.2075	32.2375	32.19	32.225	378468.0
2015-06-08 09:30:00	AAPL	Stock	32.2175	32.2425	32.0375	32.0925	22988892.0
2015-06-08 10:00:00	AAPL	Stock	32.0925	32.3025	32.0575	32.2775	16328368.0
2015-06-08 10:30:00	AAPL	Stock	32.275	32.3	32.0975	32.11	11475292.0
2015-06-08 11:00:00	AAPL	Stock	32.11	32.1825	32.0862	32.095	9922048.0
2015-06-08 11:30:00	AAPL	Stock	32.095	32.11	31.975	32.03	9366324.0
2015-06-08 12:00:00	AAPL	Stock	32.03	32.03	31.9575	31.975	11561212.0
2015-06-08 12:30:00	AAPL	Stock	31.975	31.98	31.84	31.8425	11748284.0
2015-06-08 13:00:00	AAPL	Stock	31.8425	31.9365	31.7325	31.7538	16586152.0
2015-06-08 13:30:00	AAPL	Stock	31.755	31.9075	31.7075	31.8512	15268816.0
2015-06-08 14:00:00	AAPL	Stock	31.8525	31.895	31.795	31.89	10085980.0
2015-06-08 14:30:00	AAPL	Stock	31.8925	32.135	31.89	32.103	18285776.0
2015-06-08 15:00:00	AAPL	Stock	32.105	32.1125	31.9425	32.0	16274044.0
2015-06-08 15:30:00	AAPL	Stock	32.0	32.04	31.94	31.94	17717072.0
2015-06-08 16:00:00	AAPL	Stock	31.95	31.97	31.9425	31.95	10922804.0
2015-06-08 16:30:00	AAPL	Stock	31.9475	31.955	31.9375	31.955	140800.0
2015-06-08 17:00:00	AAPL	Stock	31.955	31.96	31.95	31.9525	72912.0
2015-06-08 17:30:00	AAPL	Stock	31.9525	31.96	31.9475	31.955	59972.0
2015-06-08 18:00:00	AAPL	Stock	31.955	31.9625	31.95	31.95	45988.0
2015-06-08 18:30:00	AAPL	Stock	31.955	31.9575	31.945	31.9475	26092.0
2015-06-08 19:00:00	AAPL	Stock	31.9425	31.955	31.9375	31.945	42084.0
2015-06-08 19:30:00	AAPL	Stock	31.9475	31.95	31.9375	31.9425	67656.0
2015-06-08 04:00:00	MSFT	Stock	46.15	46.15	46.15	46.15	600.0
2015-06-08 04:30:00	MSFT	Stock	46.17	46.17	46.17	46.17	100.0
2015-06-08 06:00:00	MSFT	Stock	46.17	46.17	46.17	46.17	350.0
2015-06-08 07:30:00	MSFT	Stock	46.16	46.16	46.15	46.15	200.0
2015-06-08 08:00:00	MSFT	Stock	46.19	46.23	46.09	46.2	9400.0
2015-06-08 08:30:00	MSFT	Stock	46.25	46.25	46.16	46.16	6999.0
2015-06-08 09:00:00	MSFT	Stock	46.13	46.3	46.1	46.28	38257.0
2015-06-08 09:30:00	MSFT	Stock	46.29	46.43	46.055	46.19	2742449.0
2015-06-08 10:00:00	MSFT	Stock	46.2	46.24	46.05	46.2	1308093.0
2015-06-08 10:30:00	MSFT	Stock	46.195	46.26	46.115	46.17	1395153.0
2015-06-08 11:00:00	MSFT	Stock	46.18	46.25	46.01	46.037	1312319.0
2015-06-08 11:30:00	MSFT	Stock	46.03	46.08	45.86	45.89	1065114.0
2015-06-08 12:00:00	MSFT	Stock	45.89	45.98	45.855	45.88	787153.0
2015-06-08 12:30:00	MSFT	Stock	45.875	45.91	45.72	45.73	1091500.0
2015-06-08 13:00:00	MSFT	Stock	45.73	45.88	45.71	45.845	1080862.0
2015-06-08 13:30:00	MSFT	Stock	45.849	45.87	45.74	45.76	1131364.0
2015-06-08 14:00:00	MSFT	Stock	45.76	45.85	45.67	45.85	1169077.0
2015-06-08 14:30:00	MSFT	Stock	45.85	45.97	45.845	45.96	1257782.0

> showing 50 of 82,224 rows — these rows as CSV

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