PREVIEW / stock_30min / 2014-11-11

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-11.parquet
  size:    1.6 MB
  rows:    82,312
  symbols: 3,534

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-11-11 04:30:00	AAPL	Stock	27.1875	27.1875	27.1875	27.1875	4840.0
2014-11-11 05:00:00	AAPL	Stock	27.1825	27.1825	27.1825	27.1825	3600.0
2014-11-11 05:30:00	AAPL	Stock	27.175	27.175	27.175	27.175	2000.0
2014-11-11 06:00:00	AAPL	Stock	27.16	27.16	27.1425	27.15	5200.0
2014-11-11 06:30:00	AAPL	Stock	27.15	27.1825	27.1375	27.1825	20376.0
2014-11-11 07:00:00	AAPL	Stock	27.1825	27.1825	27.1775	27.1825	14500.0
2014-11-11 07:30:00	AAPL	Stock	27.1875	27.1975	27.165	27.18	28844.0
2014-11-11 08:00:00	AAPL	Stock	27.18	27.215	26.95	27.195	134528.0
2014-11-11 08:30:00	AAPL	Stock	27.195	27.195	27.18	27.18	79816.0
2014-11-11 09:00:00	AAPL	Stock	27.18	27.21	27.18	27.19	86844.0
2014-11-11 09:30:00	AAPL	Stock	27.175	27.225	27.1	27.13	14935396.0
2014-11-11 10:00:00	AAPL	Stock	27.1325	27.2175	27.125	27.2102	8785796.0
2014-11-11 10:30:00	AAPL	Stock	27.2105	27.26	27.185	27.2375	8002456.0
2014-11-11 11:00:00	AAPL	Stock	27.2358	27.2375	27.195	27.2075	5449208.0
2014-11-11 11:30:00	AAPL	Stock	27.2088	27.2175	27.165	27.2025	4506972.0
2014-11-11 12:00:00	AAPL	Stock	27.2025	27.2175	27.18	27.2075	3774660.0
2014-11-11 12:30:00	AAPL	Stock	27.2088	27.23	27.205	27.2075	3333608.0
2014-11-11 13:00:00	AAPL	Stock	27.2075	27.2325	27.1925	27.22	3269740.0
2014-11-11 13:30:00	AAPL	Stock	27.22	27.275	27.2125	27.2702	5276768.0
2014-11-11 14:00:00	AAPL	Stock	27.2725	27.3125	27.24	27.2825	9093456.0
2014-11-11 14:30:00	AAPL	Stock	27.2825	27.3125	27.255	27.31	4218944.0
2014-11-11 15:00:00	AAPL	Stock	27.3075	27.3725	27.2902	27.36	9316016.0
2014-11-11 15:30:00	AAPL	Stock	27.36	27.4375	27.35	27.425	15631396.0
2014-11-11 16:00:00	AAPL	Stock	27.425	27.45	27.2805	27.44	5705836.0
2014-11-11 16:30:00	AAPL	Stock	27.44	27.4425	27.1875	27.4325	206536.0
2014-11-11 17:00:00	AAPL	Stock	27.44	27.4425	27.2405	27.4275	52284.0
2014-11-11 17:30:00	AAPL	Stock	27.4275	27.4325	27.425	27.4325	189584.0
2014-11-11 18:00:00	AAPL	Stock	27.4325	27.48	27.425	27.44	104740.0
2014-11-11 18:30:00	AAPL	Stock	27.44	27.445	27.425	27.445	43772.0
2014-11-11 19:00:00	AAPL	Stock	27.445	27.4475	27.425	27.4275	67608.0
2014-11-11 19:30:00	AAPL	Stock	27.43	27.43	27.4275	27.4275	25208.0
2014-11-11 07:00:00	MSFT	Stock	48.88	48.88	48.88	48.88	700.0
2014-11-11 07:30:00	MSFT	Stock	48.88	48.88	48.88	48.88	200.0
2014-11-11 08:00:00	MSFT	Stock	48.88	48.88	48.88	48.88	1200.0
2014-11-11 08:30:00	MSFT	Stock	48.89	48.95	48.89	48.94	974.0
2014-11-11 09:00:00	MSFT	Stock	48.91	48.91	48.88	48.88	4209.0
2014-11-11 09:30:00	MSFT	Stock	48.85	48.86	48.645	48.7	2493882.0
2014-11-11 10:00:00	MSFT	Stock	48.71	48.81	48.685	48.78	1662368.0
2014-11-11 10:30:00	MSFT	Stock	48.78	48.93	48.78	48.85	1388143.0
2014-11-11 11:00:00	MSFT	Stock	48.86	48.9	48.81	48.85	1659477.0
2014-11-11 11:30:00	MSFT	Stock	48.85	48.86	48.825	48.835	637234.0
2014-11-11 12:00:00	MSFT	Stock	48.83	48.87	48.785	48.79	807016.0
2014-11-11 12:30:00	MSFT	Stock	48.79	48.84	48.78	48.795	793565.0
2014-11-11 13:00:00	MSFT	Stock	48.798	48.84	48.76	48.8	988071.0
2014-11-11 13:30:00	MSFT	Stock	48.79	48.84	48.745	48.79	833695.0
2014-11-11 14:00:00	MSFT	Stock	48.79	48.835	48.78	48.818	1295970.0
2014-11-11 14:30:00	MSFT	Stock	48.815	48.84	48.78	48.79	1581792.0
2014-11-11 15:00:00	MSFT	Stock	48.79	48.83	48.775	48.78	1942745.0
2014-11-11 15:30:00	MSFT	Stock	48.78	48.87	48.77	48.86	3864187.0
2014-11-11 16:00:00	MSFT	Stock	48.87	48.87	48.817	48.87	1272286.0

> showing 50 of 82,312 rows — these rows as CSV

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