PREVIEW / stock_30min / 2017-03-01

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-01.parquet
  size:    1.7 MB
  rows:    84,328
  symbols: 3,101

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-03-01 04:00:00	AAPL	Stock	34.3125	34.4	34.3125	34.4	25412.0
2017-03-01 05:00:00	AAPL	Stock	34.3975	34.3975	34.3975	34.3975	1200.0
2017-03-01 05:30:00	AAPL	Stock	34.3975	34.425	34.3975	34.4	10728.0
2017-03-01 06:00:00	AAPL	Stock	34.4	34.425	34.4	34.4225	13024.0
2017-03-01 06:30:00	AAPL	Stock	34.42	34.43	34.4	34.425	38272.0
2017-03-01 07:00:00	AAPL	Stock	34.425	34.4375	34.38	34.425	64776.0
2017-03-01 07:30:00	AAPL	Stock	34.4275	34.4625	34.4125	34.4475	106256.0
2017-03-01 08:00:00	AAPL	Stock	34.44	34.475	34.4	34.4625	268480.0
2017-03-01 08:30:00	AAPL	Stock	34.4625	34.4975	34.45	34.4875	263764.0
2017-03-01 09:00:00	AAPL	Stock	34.4775	34.5	34.4625	34.4675	211708.0
2017-03-01 09:30:00	AAPL	Stock	34.4725	34.575	34.3988	34.5352	16060316.0
2017-03-01 10:00:00	AAPL	Stock	34.5375	34.6425	34.5325	34.635	9575428.0
2017-03-01 10:30:00	AAPL	Stock	34.635	34.755	34.6075	34.73	10489164.0
2017-03-01 11:00:00	AAPL	Stock	34.73	34.925	34.7175	34.9175	10546704.0
2017-03-01 11:30:00	AAPL	Stock	34.9182	34.935	34.88	34.9175	6991644.0
2017-03-01 12:00:00	AAPL	Stock	34.9175	34.9975	34.9135	34.9425	8726656.0
2017-03-01 12:30:00	AAPL	Stock	34.945	34.9762	34.9425	34.9525	4643108.0
2017-03-01 13:00:00	AAPL	Stock	34.95	35.02	34.94	34.9595	11251692.0
2017-03-01 13:30:00	AAPL	Stock	34.9575	34.99	34.905	34.9425	7715056.0
2017-03-01 14:00:00	AAPL	Stock	34.9425	34.9925	34.88	34.9725	7227172.0
2017-03-01 14:30:00	AAPL	Stock	34.975	35.0375	34.9425	35.0225	8050512.0
2017-03-01 15:00:00	AAPL	Stock	35.0242	35.025	34.975	34.9938	5677880.0
2017-03-01 15:30:00	AAPL	Stock	34.9925	35.025	34.935	34.9475	12936760.0
2017-03-01 16:00:00	AAPL	Stock	34.9475	34.96	34.93	34.94	9769704.0
2017-03-01 16:30:00	AAPL	Stock	34.9375	34.95	34.93	34.9425	118524.0
2017-03-01 17:00:00	AAPL	Stock	34.9425	34.9425	34.915	34.9375	65500.0
2017-03-01 17:30:00	AAPL	Stock	34.9225	34.9375	34.9225	34.9325	7100.0
2017-03-01 18:00:00	AAPL	Stock	34.9375	34.9625	34.9325	34.96	49996.0
2017-03-01 18:30:00	AAPL	Stock	34.96	34.96	34.9475	34.9525	20396.0
2017-03-01 19:00:00	AAPL	Stock	34.9475	34.9525	34.9475	34.95	8788.0
2017-03-01 19:30:00	AAPL	Stock	34.9525	34.9975	34.9525	34.9975	59376.0
2017-03-01 04:00:00	MSFT	Stock	64.19	64.35	64.19	64.25	1128.0
2017-03-01 04:30:00	MSFT	Stock	64.25	64.25	64.25	64.25	930.0
2017-03-01 05:30:00	MSFT	Stock	64.25	64.25	64.25	64.25	148.0
2017-03-01 06:30:00	MSFT	Stock	64.15	64.15	64.15	64.15	2000.0
2017-03-01 07:00:00	MSFT	Stock	64.24	64.24	64.24	64.24	300.0
2017-03-01 07:30:00	MSFT	Stock	64.24	64.24	64.17	64.18	9070.0
2017-03-01 08:00:00	MSFT	Stock	64.24	64.25	63.98	64.24	39720.0
2017-03-01 08:30:00	MSFT	Stock	64.23	64.25	64.22	64.22	10465.0
2017-03-01 09:00:00	MSFT	Stock	64.19	64.25	64.16	64.16	26262.0
2017-03-01 09:30:00	MSFT	Stock	64.16	64.35	64.022	64.23	2593008.0
2017-03-01 10:00:00	MSFT	Stock	64.24	64.58	64.24	64.51	1673590.0
2017-03-01 10:30:00	MSFT	Stock	64.51	64.51	64.35	64.505	1174582.0
2017-03-01 11:00:00	MSFT	Stock	64.504	64.65	64.445	64.635	1268714.0
2017-03-01 11:30:00	MSFT	Stock	64.644	64.849	64.64	64.785	1262209.0
2017-03-01 12:00:00	MSFT	Stock	64.785	64.99	64.77	64.915	1537833.0
2017-03-01 12:30:00	MSFT	Stock	64.913	64.92	64.76	64.78	1242062.0
2017-03-01 13:00:00	MSFT	Stock	64.78	64.87	64.77	64.82	922303.0
2017-03-01 13:30:00	MSFT	Stock	64.82	64.85	64.758	64.83	894191.0
2017-03-01 14:00:00	MSFT	Stock	64.83	64.96	64.76	64.955	1370832.0

> showing 50 of 84,328 rows — these rows as CSV

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