PREVIEW / stock_30min / 2014-10-13

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-13.parquet
  size:    1.6 MB
  rows:    84,480
  symbols: 3,535

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
2014-10-13 04:00:00	AAPL	Stock	25.0975	25.12	25.0	25.1125	15200.0
2014-10-13 04:30:00	AAPL	Stock	25.12	25.1775	25.12	25.17	13920.0
2014-10-13 05:00:00	AAPL	Stock	25.175	25.1875	25.175	25.1875	6000.0
2014-10-13 05:30:00	AAPL	Stock	25.175	25.1925	25.17	25.1725	21496.0
2014-10-13 06:00:00	AAPL	Stock	25.175	25.2625	25.165	25.2625	57848.0
2014-10-13 06:30:00	AAPL	Stock	25.28	25.28	25.2525	25.265	26008.0
2014-10-13 07:00:00	AAPL	Stock	25.2775	25.4125	25.2775	25.35	141172.0
2014-10-13 07:30:00	AAPL	Stock	25.3275	25.365	25.3275	25.3375	107508.0
2014-10-13 08:00:00	AAPL	Stock	25.3375	25.37	25.2625	25.36	660000.0
2014-10-13 08:30:00	AAPL	Stock	25.355	25.425	25.3525	25.4125	672220.0
2014-10-13 09:00:00	AAPL	Stock	25.4125	25.4225	25.3125	25.335	902620.0
2014-10-13 09:30:00	AAPL	Stock	25.345	25.445	25.2225	25.29	26542752.0
2014-10-13 10:00:00	AAPL	Stock	25.29	25.3428	25.125	25.15	17263204.0
2014-10-13 10:30:00	AAPL	Stock	25.1525	25.1965	24.9575	25.1525	24274876.0
2014-10-13 11:00:00	AAPL	Stock	25.1525	25.2125	25.0775	25.11	12228220.0
2014-10-13 11:30:00	AAPL	Stock	25.1125	25.3325	25.105	25.2175	13315224.0
2014-10-13 12:00:00	AAPL	Stock	25.2175	25.35	25.18	25.34	9539852.0
2014-10-13 12:30:00	AAPL	Stock	25.34	25.3975	25.3	25.3375	9262960.0
2014-10-13 13:00:00	AAPL	Stock	25.3375	25.365	25.205	25.3422	7431556.0
2014-10-13 13:30:00	AAPL	Stock	25.34	25.355	25.2575	25.2915	7592040.0
2014-10-13 14:00:00	AAPL	Stock	25.29	25.36	25.2425	25.36	7568016.0
2014-10-13 14:30:00	AAPL	Stock	25.3575	25.3575	25.22	25.2325	8593900.0
2014-10-13 15:00:00	AAPL	Stock	25.2325	25.2725	25.1575	25.2038	10901300.0
2014-10-13 15:30:00	AAPL	Stock	25.2025	25.2025	24.9525	24.9575	33252988.0
2014-10-13 16:00:00	AAPL	Stock	24.9525	25.1445	24.9375	24.9525	10777652.0
2014-10-13 16:30:00	AAPL	Stock	24.975	24.975	24.95	24.9625	411072.0
2014-10-13 17:00:00	AAPL	Stock	24.9525	26.0165	18.0487	24.935	232360.0
2014-10-13 17:30:00	AAPL	Stock	24.935	24.9575	24.925	24.9425	47008.0
2014-10-13 18:00:00	AAPL	Stock	24.95	25.0325	24.95	24.9875	121168.0
2014-10-13 18:30:00	AAPL	Stock	24.9875	25.226	24.9425	24.9575	132880.0
2014-10-13 19:00:00	AAPL	Stock	24.9575	24.9725	24.9575	24.9675	82128.0
2014-10-13 19:30:00	AAPL	Stock	24.97	24.9875	24.965	24.9875	165144.0
2014-10-13 04:00:00	MSFT	Stock	43.84	43.84	43.84	43.84	200.0
2014-10-13 04:30:00	MSFT	Stock	43.77	43.85	43.77	43.85	5064.0
2014-10-13 05:00:00	MSFT	Stock	43.85	43.85	43.85	43.85	2400.0
2014-10-13 05:30:00	MSFT	Stock	43.84	43.85	43.83	43.85	2100.0
2014-10-13 06:00:00	MSFT	Stock	43.85	43.89	43.85	43.89	3862.0
2014-10-13 06:30:00	MSFT	Stock	43.91	43.95	43.91	43.95	4000.0
2014-10-13 07:00:00	MSFT	Stock	43.95	43.95	43.9	43.95	400.0
2014-10-13 07:30:00	MSFT	Stock	43.83	43.83	43.8	43.8	3400.0
2014-10-13 08:00:00	MSFT	Stock	43.82	43.9	43.74	43.74	16222.0
2014-10-13 08:30:00	MSFT	Stock	43.82	43.89	43.76	43.81	6043.0
2014-10-13 09:00:00	MSFT	Stock	43.78	43.91	43.75	43.86	163613.0
2014-10-13 09:30:00	MSFT	Stock	43.83	43.84	43.49	43.805	6117688.0
2014-10-13 10:00:00	MSFT	Stock	43.81	44.0	43.73	43.79	2623008.0
2014-10-13 10:30:00	MSFT	Stock	43.79	44.24	43.735	44.111	2692862.0
2014-10-13 11:00:00	MSFT	Stock	44.12	44.26	43.92	44.005	1699652.0
2014-10-13 11:30:00	MSFT	Stock	44.01	44.32	44.01	44.21	1568339.0
2014-10-13 12:00:00	MSFT	Stock	44.2	44.48	44.17	44.47	1663479.0
2014-10-13 12:30:00	MSFT	Stock	44.47	44.55	44.3	44.3	1269794.0

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

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