PREVIEW / stock_30min / 2016-10-13

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-13.parquet
  size:    1.6 MB
  rows:    80,388
  symbols: 3,200

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-10-13 04:00:00	AAPL	Stock	29.225	29.2325	29.225	29.225	125640.0
2016-10-13 04:30:00	AAPL	Stock	29.2	29.225	29.2	29.22	4228.0
2016-10-13 05:00:00	AAPL	Stock	29.225	29.225	29.2025	29.2125	13828.0
2016-10-13 05:30:00	AAPL	Stock	29.2125	29.225	29.2025	29.2025	5876.0
2016-10-13 06:00:00	AAPL	Stock	29.2025	29.2175	29.2	29.2	36424.0
2016-10-13 06:30:00	AAPL	Stock	29.2	29.22	29.19	29.2125	72960.0
2016-10-13 07:00:00	AAPL	Stock	29.205	29.2275	29.1825	29.1825	76416.0
2016-10-13 07:30:00	AAPL	Stock	29.1825	29.22	29.17	29.22	31032.0
2016-10-13 08:00:00	AAPL	Stock	29.22	29.275	29.1375	29.1625	220124.0
2016-10-13 08:30:00	AAPL	Stock	29.1625	29.175	29.125	29.16	276500.0
2016-10-13 09:00:00	AAPL	Stock	29.1625	29.22	29.15	29.1975	255836.0
2016-10-13 09:30:00	AAPL	Stock	29.1975	29.32	28.995	29.0688	29970724.0
2016-10-13 10:00:00	AAPL	Stock	29.07	29.1125	28.9825	28.9925	13627384.0
2016-10-13 10:30:00	AAPL	Stock	28.9925	29.0462	28.93	29.015	12675036.0
2016-10-13 11:00:00	AAPL	Stock	29.015	29.1475	28.9775	29.115	9450632.0
2016-10-13 11:30:00	AAPL	Stock	29.1138	29.1825	29.111	29.1475	8471484.0
2016-10-13 12:00:00	AAPL	Stock	29.15	29.18	29.1125	29.155	5835080.0
2016-10-13 12:30:00	AAPL	Stock	29.1525	29.2325	29.15	29.1825	6062980.0
2016-10-13 13:00:00	AAPL	Stock	29.186	29.186	29.1278	29.1625	4742204.0
2016-10-13 13:30:00	AAPL	Stock	29.1625	29.255	29.1325	29.2475	5246976.0
2016-10-13 14:00:00	AAPL	Stock	29.2475	29.265	29.2035	29.2612	6984136.0
2016-10-13 14:30:00	AAPL	Stock	29.26	29.305	29.2525	29.3	6534824.0
2016-10-13 15:00:00	AAPL	Stock	29.3	29.36	29.2525	29.2625	7695620.0
2016-10-13 15:30:00	AAPL	Stock	29.2625	29.28	29.175	29.2475	9180000.0
2016-10-13 16:00:00	AAPL	Stock	29.245	29.2675	29.1775	29.225	4256004.0
2016-10-13 16:30:00	AAPL	Stock	29.255	29.255	29.225	29.255	65060.0
2016-10-13 17:00:00	AAPL	Stock	29.2475	29.2475	29.215	29.2375	37960.0
2016-10-13 17:30:00	AAPL	Stock	29.2375	29.26	29.23	29.245	140476.0
2016-10-13 18:00:00	AAPL	Stock	29.2475	29.255	29.245	29.2525	48744.0
2016-10-13 18:30:00	AAPL	Stock	29.2525	29.2575	29.245	29.255	71944.0
2016-10-13 19:00:00	AAPL	Stock	29.2575	29.2575	29.2375	29.255	25152.0
2016-10-13 19:30:00	AAPL	Stock	29.25	29.2575	29.215	29.245	170884.0
2016-10-13 07:00:00	MSFT	Stock	56.8	56.8	56.77	56.77	3400.0
2016-10-13 07:30:00	MSFT	Stock	56.77	56.77	56.77	56.77	100.0
2016-10-13 08:00:00	MSFT	Stock	56.7	56.8	56.7	56.8	2810.0
2016-10-13 08:30:00	MSFT	Stock	56.73	56.89	56.71	56.71	13284.0
2016-10-13 09:00:00	MSFT	Stock	56.72	56.8	56.64	56.7	35300.0
2016-10-13 09:30:00	MSFT	Stock	56.67	56.75	56.42	56.52	3422220.0
2016-10-13 10:00:00	MSFT	Stock	56.525	56.605	56.39	56.395	1962109.0
2016-10-13 10:30:00	MSFT	Stock	56.39	56.55	56.315	56.5	1846749.0
2016-10-13 11:00:00	MSFT	Stock	56.5	56.74	56.435	56.68	1492266.0
2016-10-13 11:30:00	MSFT	Stock	56.68	56.85	56.68	56.845	1424023.0
2016-10-13 12:00:00	MSFT	Stock	56.84	56.91	56.77	56.85	963303.0
2016-10-13 12:30:00	MSFT	Stock	56.86	57.09	56.845	57.09	975559.0
2016-10-13 13:00:00	MSFT	Stock	57.1	57.1	57.01	57.03	866528.0
2016-10-13 13:30:00	MSFT	Stock	57.035	57.21	57.0	57.21	928285.0
2016-10-13 14:00:00	MSFT	Stock	57.21	57.25	57.13	57.165	1369658.0
2016-10-13 14:30:00	MSFT	Stock	57.16	57.3	57.16	57.245	1369714.0
2016-10-13 15:00:00	MSFT	Stock	57.25	57.25	57.05	57.05	1196554.0
2016-10-13 15:30:00	MSFT	Stock	57.06	57.105	56.85	56.92	3008645.0

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

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