PREVIEW / stock_30min / 2015-04-02

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-02.parquet
  size:    1.6 MB
  rows:    81,853
  symbols: 3,516

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-04-02 04:00:00	AAPL	Stock	31.055	31.055	31.03	31.03	1200.0
2015-04-02 04:30:00	AAPL	Stock	31.035	31.035	30.9975	31.0025	3716.0
2015-04-02 05:00:00	AAPL	Stock	31.0375	31.0375	31.0375	31.0375	400.0
2015-04-02 05:30:00	AAPL	Stock	31.0375	31.0625	31.015	31.0625	9844.0
2015-04-02 06:00:00	AAPL	Stock	31.045	31.06	31.025	31.05	5932.0
2015-04-02 06:30:00	AAPL	Stock	31.06	31.06	31.0375	31.0575	14912.0
2015-04-02 07:00:00	AAPL	Stock	31.055	31.1525	31.0525	31.1425	18380.0
2015-04-02 07:30:00	AAPL	Stock	31.15	31.1625	31.125	31.1525	42660.0
2015-04-02 08:00:00	AAPL	Stock	31.1525	31.235	31.0425	31.215	455204.0
2015-04-02 08:30:00	AAPL	Stock	31.225	31.2375	31.1825	31.225	218548.0
2015-04-02 09:00:00	AAPL	Stock	31.23	31.275	31.2052	31.2425	420944.0
2015-04-02 09:30:00	AAPL	Stock	31.2575	31.2775	31.0775	31.1165	21661132.0
2015-04-02 10:00:00	AAPL	Stock	31.12	31.245	31.1	31.126	11612248.0
2015-04-02 10:30:00	AAPL	Stock	31.125	31.165	31.0475	31.1375	8435780.0
2015-04-02 11:00:00	AAPL	Stock	31.135	31.1612	31.0925	31.1275	6186172.0
2015-04-02 11:30:00	AAPL	Stock	31.13	31.235	31.1275	31.2025	7431320.0
2015-04-02 12:00:00	AAPL	Stock	31.2025	31.2275	31.1475	31.21	6098032.0
2015-04-02 12:30:00	AAPL	Stock	31.2115	31.2625	31.2	31.21	5099672.0
2015-04-02 13:00:00	AAPL	Stock	31.2075	31.25	31.1775	31.2215	4269576.0
2015-04-02 13:30:00	AAPL	Stock	31.2225	31.23	31.18	31.2238	4282412.0
2015-04-02 14:00:00	AAPL	Stock	31.225	31.2625	31.19	31.24	5033544.0
2015-04-02 14:30:00	AAPL	Stock	31.24	31.245	31.18	31.22	5163048.0
2015-04-02 15:00:00	AAPL	Stock	31.22	31.275	31.218	31.2522	6986656.0
2015-04-02 15:30:00	AAPL	Stock	31.25	31.39	31.245	31.3275	19804364.0
2015-04-02 16:00:00	AAPL	Stock	31.3288	31.371	31.1442	31.3225	7548092.0
2015-04-02 16:30:00	AAPL	Stock	31.325	31.355	31.1938	31.335	122640.0
2015-04-02 17:00:00	AAPL	Stock	31.335	31.3425	31.315	31.33	67572.0
2015-04-02 17:30:00	AAPL	Stock	31.335	31.335	31.3175	31.32	52644.0
2015-04-02 18:00:00	AAPL	Stock	31.3225	31.3225	31.3175	31.3225	39928.0
2015-04-02 18:30:00	AAPL	Stock	31.32	31.3225	31.32	31.3225	22260.0
2015-04-02 19:00:00	AAPL	Stock	31.3198	31.32	31.3125	31.315	9844.0
2015-04-02 19:30:00	AAPL	Stock	31.32	31.3275	31.3125	31.3275	55808.0
2015-04-02 04:00:00	MSFT	Stock	40.7	40.7	40.7	40.7	100.0
2015-04-02 07:00:00	MSFT	Stock	40.68	40.68	40.68	40.68	300.0
2015-04-02 07:30:00	MSFT	Stock	40.66	40.66	40.66	40.66	500.0
2015-04-02 08:00:00	MSFT	Stock	40.66	40.67	40.63	40.67	4397.0
2015-04-02 08:30:00	MSFT	Stock	40.67	40.69	40.65	40.68	2543.0
2015-04-02 09:00:00	MSFT	Stock	40.68	40.69	40.64	40.68	3859.0
2015-04-02 09:30:00	MSFT	Stock	40.66	40.74	40.45	40.555	5061518.0
2015-04-02 10:00:00	MSFT	Stock	40.57	40.61	40.45	40.46	2478761.0
2015-04-02 10:30:00	MSFT	Stock	40.46	40.5	40.37	40.397	1859444.0
2015-04-02 11:00:00	MSFT	Stock	40.4	40.41	40.3	40.315	2070828.0
2015-04-02 11:30:00	MSFT	Stock	40.31	40.38	40.3	40.305	1826192.0
2015-04-02 12:00:00	MSFT	Stock	40.31	40.31	40.16	40.19	3226825.0
2015-04-02 12:30:00	MSFT	Stock	40.19	40.21	40.13	40.14	2073285.0
2015-04-02 13:00:00	MSFT	Stock	40.14	40.22	40.12	40.181	2280925.0
2015-04-02 13:30:00	MSFT	Stock	40.19	40.21	40.13	40.19	1531525.0
2015-04-02 14:00:00	MSFT	Stock	40.19	40.28	40.17	40.237	1886808.0
2015-04-02 14:30:00	MSFT	Stock	40.24	40.25	40.18	40.18	1449605.0
2015-04-02 15:00:00	MSFT	Stock	40.19	40.245	40.16	40.21	1946420.0

> showing 50 of 81,853 rows — these rows as CSV

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