PREVIEW / stock_30min / 2014-01-28

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-28.parquet
  size:    1.6 MB
  rows:    82,655
  symbols: 3,546

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-01-28 04:00:00	AAPL	Stock	18.2232	18.5714	18.1982	18.3286	267876.0
2014-01-28 04:30:00	AAPL	Stock	18.3393	18.3929	18.3068	18.3357	236432.0
2014-01-28 05:00:00	AAPL	Stock	18.3411	18.3757	18.3411	18.3571	112700.0
2014-01-28 05:30:00	AAPL	Stock	18.3482	18.3482	18.3	18.3214	158900.0
2014-01-28 06:00:00	AAPL	Stock	18.315	18.3189	18.1989	18.2857	829220.0
2014-01-28 06:30:00	AAPL	Stock	18.2964	18.3036	18.2179	18.2696	376180.0
2014-01-28 07:00:00	AAPL	Stock	18.3032	18.355	18.2179	18.3514	1246056.0
2014-01-28 07:30:00	AAPL	Stock	18.3457	18.3504	18.2436	18.3189	2014656.0
2014-01-28 08:00:00	AAPL	Stock	18.3161	18.3489	18.1082	18.1718	7523768.0
2014-01-28 08:30:00	AAPL	Stock	18.1821	18.2582	18.1357	18.25	9028964.0
2014-01-28 09:00:00	AAPL	Stock	18.2536	18.325	18.1429	18.1436	12958820.0
2014-01-28 09:30:00	AAPL	Stock	18.17	18.2586	17.9454	18.0027	223437648.0
2014-01-28 10:00:00	AAPL	Stock	18.0028	18.3632	17.9311	18.2898	133751184.0
2014-01-28 10:30:00	AAPL	Stock	18.2929	18.3929	18.235	18.2475	65125648.0
2014-01-28 11:00:00	AAPL	Stock	18.2407	18.3303	18.1225	18.1489	76613488.0
2014-01-28 11:30:00	AAPL	Stock	18.1489	18.2207	18.1186	18.1911	48358688.0
2014-01-28 12:00:00	AAPL	Stock	18.1979	18.2028	18.1011	18.1675	32569348.0
2014-01-28 12:30:00	AAPL	Stock	18.1682	18.2411	18.1639	18.2287	25610256.0
2014-01-28 13:00:00	AAPL	Stock	18.2264	18.2411	18.15	18.1518	23819852.0
2014-01-28 13:30:00	AAPL	Stock	18.1521	18.1604	18.0718	18.0807	31561152.0
2014-01-28 14:00:00	AAPL	Stock	18.0826	18.2214	18.0732	18.165	25608744.0
2014-01-28 14:30:00	AAPL	Stock	18.1646	18.2011	18.1296	18.1625	26217240.0
2014-01-28 15:00:00	AAPL	Stock	18.1629	18.1631	18.0811	18.1037	34019720.0
2014-01-28 15:30:00	AAPL	Stock	18.1029	18.1232	18.0214	18.1011	66102176.0
2014-01-28 16:00:00	AAPL	Stock	18.1054	19.6607	17.9795	19.6607	23883468.0
2014-01-28 16:30:00	AAPL	Stock	18.0775	19.6607	18.0714	18.0786	11150972.0
2014-01-28 17:00:00	AAPL	Stock	18.08	18.1354	18.08	18.1339	745752.0
2014-01-28 17:30:00	AAPL	Stock	18.1286	18.1404	18.1143	18.1332	374136.0
2014-01-28 18:00:00	AAPL	Stock	18.1257	18.1689	18.1054	18.16	412160.0
2014-01-28 18:30:00	AAPL	Stock	18.1593	18.1636	18.145	18.1454	133756.0
2014-01-28 19:00:00	AAPL	Stock	18.1482	18.1743	18.1468	18.1561	324492.0
2014-01-28 19:30:00	AAPL	Stock	18.1554	18.1654	18.1468	18.1636	239652.0
2014-01-28 04:00:00	MSFT	Stock	36.14	36.14	36.14	36.14	554.0
2014-01-28 07:30:00	MSFT	Stock	36.28	36.28	36.26	36.26	2250.0
2014-01-28 08:00:00	MSFT	Stock	36.29	36.29	36.2	36.29	7766.0
2014-01-28 08:30:00	MSFT	Stock	36.29	36.31	36.12	36.3	16814.0
2014-01-28 09:00:00	MSFT	Stock	36.3	36.3	36.07	36.07	35340.0
2014-01-28 09:30:00	MSFT	Stock	36.1	36.39	36.08	36.21	3689809.0
2014-01-28 10:00:00	MSFT	Stock	36.21	36.27	36.02	36.07	2400761.0
2014-01-28 10:30:00	MSFT	Stock	36.065	36.17	35.99	36.064	2682184.0
2014-01-28 11:00:00	MSFT	Stock	36.067	36.13	35.81	35.82	3192392.0
2014-01-28 11:30:00	MSFT	Stock	35.815	35.915	35.75	35.915	2379049.0
2014-01-28 12:00:00	MSFT	Stock	35.915	35.965	35.86	35.96	1510148.0
2014-01-28 12:30:00	MSFT	Stock	35.96	36.02	35.88	35.98	2460803.0
2014-01-28 13:00:00	MSFT	Stock	35.98	36.082	35.94	36.023	1913862.0
2014-01-28 13:30:00	MSFT	Stock	36.024	36.12	35.905	36.07	1880863.0
2014-01-28 14:00:00	MSFT	Stock	36.07	36.12	36.02	36.064	1492872.0
2014-01-28 14:30:00	MSFT	Stock	36.06	36.21	36.05	36.14	2028991.0
2014-01-28 15:00:00	MSFT	Stock	36.14	36.17	36.09	36.15	1721694.0
2014-01-28 15:30:00	MSFT	Stock	36.16	36.29	36.14	36.27	4861200.0

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

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