PREVIEW / stock_30min / 2017-04-12

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-12.parquet
  size:    1.6 MB
  rows:    80,551
  symbols: 3,032

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-04-12 04:00:00	AAPL	Stock	35.4825	35.5625	35.4825	35.5625	15052.0
2017-04-12 04:30:00	AAPL	Stock	35.5275	35.5275	35.425	35.425	12660.0
2017-04-12 06:00:00	AAPL	Stock	35.4075	35.4075	35.3775	35.38	3556.0
2017-04-12 06:30:00	AAPL	Stock	35.405	35.405	35.385	35.385	1944.0
2017-04-12 07:00:00	AAPL	Stock	35.3975	35.3975	35.375	35.375	7360.0
2017-04-12 07:30:00	AAPL	Stock	35.3525	35.3525	35.35	35.35	8104.0
2017-04-12 08:00:00	AAPL	Stock	35.35	35.385	35.35	35.3675	35104.0
2017-04-12 08:30:00	AAPL	Stock	35.3725	35.3725	35.3525	35.3675	11136.0
2017-04-12 09:00:00	AAPL	Stock	35.3625	35.415	35.3625	35.3925	48112.0
2017-04-12 09:30:00	AAPL	Stock	35.4	35.5375	35.3375	35.4452	11609600.0
2017-04-12 10:00:00	AAPL	Stock	35.45	35.48	35.35	35.39	6129032.0
2017-04-12 10:30:00	AAPL	Stock	35.3925	35.425	35.3275	35.3575	4684400.0
2017-04-12 11:00:00	AAPL	Stock	35.3575	35.405	35.3425	35.3812	3384320.0
2017-04-12 11:30:00	AAPL	Stock	35.38	35.39	35.2662	35.3375	4354472.0
2017-04-12 12:00:00	AAPL	Stock	35.34	35.371	35.295	35.345	2732476.0
2017-04-12 12:30:00	AAPL	Stock	35.345	35.355	35.2625	35.2828	3119536.0
2017-04-12 13:00:00	AAPL	Stock	35.285	35.3325	35.2725	35.281	2901660.0
2017-04-12 13:30:00	AAPL	Stock	35.2818	35.425	35.2525	35.415	5105424.0
2017-04-12 14:00:00	AAPL	Stock	35.4138	35.4425	35.3675	35.4025	3883392.0
2017-04-12 14:30:00	AAPL	Stock	35.4025	35.45	35.3025	35.3875	5579268.0
2017-04-12 15:00:00	AAPL	Stock	35.385	35.41	35.3325	35.3775	5376720.0
2017-04-12 15:30:00	AAPL	Stock	35.38	35.4525	35.3425	35.4475	11038192.0
2017-04-12 16:00:00	AAPL	Stock	35.4475	35.4675	35.4275	35.4375	5098356.0
2017-04-12 16:30:00	AAPL	Stock	35.45	35.4575	35.4425	35.4425	2732.0
2017-04-12 17:00:00	AAPL	Stock	35.4425	35.4475	35.4325	35.4325	9800.0
2017-04-12 17:30:00	AAPL	Stock	35.4375	35.44	35.425	35.44	2632.0
2017-04-12 18:00:00	AAPL	Stock	35.4325	35.45	35.4325	35.45	30444.0
2017-04-12 18:30:00	AAPL	Stock	35.4525	35.4525	35.45	35.45	6472.0
2017-04-12 19:00:00	AAPL	Stock	35.4525	35.4725	35.45	35.47	28904.0
2017-04-12 19:30:00	AAPL	Stock	35.4725	35.485	35.4725	35.485	35760.0
2017-04-12 05:00:00	MSFT	Stock	65.6	65.6	65.6	65.6	254.0
2017-04-12 06:00:00	MSFT	Stock	65.6	65.6	65.6	65.6	2151.0
2017-04-12 07:00:00	MSFT	Stock	65.5	65.5	65.5	65.5	499.0
2017-04-12 08:00:00	MSFT	Stock	65.21	65.5	65.21	65.48	3266.0
2017-04-12 08:30:00	MSFT	Stock	65.48	65.48	65.48	65.48	107.0
2017-04-12 09:30:00	MSFT	Stock	65.42	65.51	65.24	65.36	1500054.0
2017-04-12 10:00:00	MSFT	Stock	65.36	65.49	65.25	65.38	1019496.0
2017-04-12 10:30:00	MSFT	Stock	65.39	65.43	65.245	65.25	1160882.0
2017-04-12 11:00:00	MSFT	Stock	65.255	65.37	65.16	65.3	1108996.0
2017-04-12 11:30:00	MSFT	Stock	65.3	65.32	65.115	65.18	1100088.0
2017-04-12 12:00:00	MSFT	Stock	65.18	65.3	65.15	65.28	709959.0
2017-04-12 12:30:00	MSFT	Stock	65.27	65.31	65.13	65.18	740905.0
2017-04-12 13:00:00	MSFT	Stock	65.18	65.305	65.17	65.19	653722.0
2017-04-12 13:30:00	MSFT	Stock	65.185	65.36	65.15	65.335	962005.0
2017-04-12 14:00:00	MSFT	Stock	65.35	65.37	65.17	65.265	903937.0
2017-04-12 14:30:00	MSFT	Stock	65.26	65.33	65.11	65.19	1262730.0
2017-04-12 15:00:00	MSFT	Stock	65.2	65.32	65.17	65.23	1196164.0
2017-04-12 15:30:00	MSFT	Stock	65.25	65.3	65.18	65.22	2023383.0
2017-04-12 16:00:00	MSFT	Stock	65.21	65.31	65.21	65.31	1396049.0
2017-04-12 16:30:00	MSFT	Stock	65.2	65.32	65.2	65.2	3172.0

> showing 50 of 80,551 rows — these rows as CSV

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