PREVIEW / stock_30min / 2016-10-12

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-12.parquet
  size:    1.5 MB
  rows:    78,795
  symbols: 3,174

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-12 04:00:00	AAPL	Stock	29.2325	29.2325	29.175	29.2025	6000.0
2016-10-12 04:30:00	AAPL	Stock	29.2475	29.25	29.22	29.22	4848.0
2016-10-12 05:00:00	AAPL	Stock	29.24	29.2525	29.24	29.24	5700.0
2016-10-12 05:30:00	AAPL	Stock	29.2575	29.3075	29.225	29.235	54396.0
2016-10-12 06:00:00	AAPL	Stock	29.235	29.28	29.205	29.25	27320.0
2016-10-12 06:30:00	AAPL	Stock	29.2325	29.25	29.2325	29.2375	40408.0
2016-10-12 07:00:00	AAPL	Stock	29.24	29.265	29.225	29.225	65676.0
2016-10-12 07:30:00	AAPL	Stock	29.2325	29.24	29.1875	29.195	70708.0
2016-10-12 08:00:00	AAPL	Stock	29.1975	29.2725	29.0125	29.17	317716.0
2016-10-12 08:30:00	AAPL	Stock	29.1775	29.3125	29.1475	29.3	545748.0
2016-10-12 09:00:00	AAPL	Stock	29.305	29.3375	29.235	29.3375	509752.0
2016-10-12 09:30:00	AAPL	Stock	29.3375	29.4375	29.195	29.265	25706296.0
2016-10-12 10:00:00	AAPL	Stock	29.2625	29.325	29.1925	29.3242	11312676.0
2016-10-12 10:30:00	AAPL	Stock	29.325	29.3295	29.1975	29.21	8254436.0
2016-10-12 11:00:00	AAPL	Stock	29.2075	29.33	29.1875	29.3028	9274036.0
2016-10-12 11:30:00	AAPL	Stock	29.3038	29.4175	29.2975	29.415	10756740.0
2016-10-12 12:00:00	AAPL	Stock	29.417	29.4325	29.3225	29.3475	7412912.0
2016-10-12 12:30:00	AAPL	Stock	29.3475	29.41	29.3375	29.385	9410880.0
2016-10-12 13:00:00	AAPL	Stock	29.3838	29.4222	29.3725	29.4222	4544392.0
2016-10-12 13:30:00	AAPL	Stock	29.4225	29.4575	29.4125	29.45	6775124.0
2016-10-12 14:00:00	AAPL	Stock	29.45	29.495	29.4125	29.45	9659216.0
2016-10-12 14:30:00	AAPL	Stock	29.45	29.4575	29.3225	29.3272	8497844.0
2016-10-12 15:00:00	AAPL	Stock	29.325	29.3825	29.2975	29.3225	7943128.0
2016-10-12 15:30:00	AAPL	Stock	29.3225	29.4125	29.2775	29.3375	14923164.0
2016-10-12 16:00:00	AAPL	Stock	29.3375	29.3475	29.265	29.335	6221212.0
2016-10-12 16:30:00	AAPL	Stock	29.3375	29.3375	29.315	29.32	19876.0
2016-10-12 17:00:00	AAPL	Stock	29.315	29.335	29.3	29.3	126496.0
2016-10-12 17:30:00	AAPL	Stock	29.3	29.335	29.2925	29.2925	95012.0
2016-10-12 18:00:00	AAPL	Stock	29.295	29.335	29.2925	29.3	54724.0
2016-10-12 18:30:00	AAPL	Stock	29.32	29.32	29.295	29.295	10140.0
2016-10-12 19:00:00	AAPL	Stock	29.3	29.3	29.2975	29.3	3600.0
2016-10-12 19:30:00	AAPL	Stock	29.3	29.32	29.295	29.3075	25364.0
2016-10-12 07:30:00	MSFT	Stock	57.33	57.33	57.3	57.3	1200.0
2016-10-12 08:00:00	MSFT	Stock	57.3	57.3	57.19	57.19	2179.0
2016-10-12 08:30:00	MSFT	Stock	57.29	57.29	57.18	57.19	3930.0
2016-10-12 09:00:00	MSFT	Stock	57.2	57.2	57.12	57.12	4381.0
2016-10-12 09:30:00	MSFT	Stock	57.12	57.12	56.4	56.57	4118473.0
2016-10-12 10:00:00	MSFT	Stock	56.58	56.77	56.51	56.735	2017514.0
2016-10-12 10:30:00	MSFT	Stock	56.74	56.79	56.64	56.7	1366409.0
2016-10-12 11:00:00	MSFT	Stock	56.71	56.91	56.7	56.894	1299394.0
2016-10-12 11:30:00	MSFT	Stock	56.89	57.03	56.89	57.0	1031231.0
2016-10-12 12:00:00	MSFT	Stock	57.01	57.07	57.01	57.015	718102.0
2016-10-12 12:30:00	MSFT	Stock	57.01	57.08	56.98	57.02	754905.0
2016-10-12 13:00:00	MSFT	Stock	57.03	57.06	56.99	57.04	672053.0
2016-10-12 13:30:00	MSFT	Stock	57.044	57.15	56.98	57.135	704623.0
2016-10-12 14:00:00	MSFT	Stock	57.14	57.27	57.01	57.115	1477496.0
2016-10-12 14:30:00	MSFT	Stock	57.115	57.185	57.06	57.09	840579.0
2016-10-12 15:00:00	MSFT	Stock	57.09	57.14	57.03	57.06	1228753.0
2016-10-12 15:30:00	MSFT	Stock	57.06	57.24	57.01	57.11	3507794.0
2016-10-12 16:00:00	MSFT	Stock	57.11	57.12	57.08	57.11	1405452.0

> showing 50 of 78,795 rows — these rows as CSV

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