PREVIEW / stock_30min / 2013-08-16

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-16.parquet
  size:    1.5 MB
  rows:    79,873
  symbols: 3,505

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
2013-08-16 04:30:00	AAPL	Stock	17.8321	17.8682	17.8321	17.8607	31668.0
2013-08-16 05:00:00	AAPL	Stock	17.8671	17.8671	17.8571	17.8571	16800.0
2013-08-16 05:30:00	AAPL	Stock	17.8357	17.8539	17.8036	17.8211	95732.0
2013-08-16 06:00:00	AAPL	Stock	17.8496	17.8496	17.8496	17.8496	2800.0
2013-08-16 06:30:00	AAPL	Stock	17.8471	17.8471	17.8471	17.8471	2800.0
2013-08-16 07:00:00	AAPL	Stock	17.8393	17.8743	17.8232	17.8661	219912.0
2013-08-16 07:30:00	AAPL	Stock	17.8593	17.8882	17.8411	17.8807	257880.0
2013-08-16 08:00:00	AAPL	Stock	17.8761	17.8907	17.8286	17.875	1236424.0
2013-08-16 08:30:00	AAPL	Stock	17.8732	17.8911	17.8661	17.8907	623644.0
2013-08-16 09:00:00	AAPL	Stock	17.8879	17.9286	17.8614	17.8636	2740584.0
2013-08-16 09:30:00	AAPL	Stock	17.8629	17.9186	17.8164	17.8832	74942616.0
2013-08-16 10:00:00	AAPL	Stock	17.8876	17.9357	17.8593	17.9171	33312020.0
2013-08-16 10:30:00	AAPL	Stock	17.9161	17.9621	17.9032	17.9579	25085144.0
2013-08-16 11:00:00	AAPL	Stock	17.9557	17.9593	17.8968	17.9092	21503664.0
2013-08-16 11:30:00	AAPL	Stock	17.9082	17.9286	17.9021	17.9079	8210608.0
2013-08-16 12:00:00	AAPL	Stock	17.9086	17.9129	17.8754	17.9066	12790456.0
2013-08-16 12:30:00	AAPL	Stock	17.906	17.9122	17.8632	17.8907	11176956.0
2013-08-16 13:00:00	AAPL	Stock	17.8889	17.8911	17.8561	17.865	11599756.0
2013-08-16 13:30:00	AAPL	Stock	17.8683	17.8789	17.8486	17.8736	10851428.0
2013-08-16 14:00:00	AAPL	Stock	17.87	17.8893	17.8614	17.8763	11179840.0
2013-08-16 14:30:00	AAPL	Stock	17.8764	17.9079	17.8714	17.9007	14662760.0
2013-08-16 15:00:00	AAPL	Stock	17.9007	17.9046	17.8656	17.8821	15791496.0
2013-08-16 15:30:00	AAPL	Stock	17.8836	17.9489	17.8754	17.9386	47513256.0
2013-08-16 16:00:00	AAPL	Stock	17.9404	17.9429	17.895	17.9404	29473416.0
2013-08-16 16:30:00	AAPL	Stock	17.9404	17.9868	17.9096	17.9761	843332.0
2013-08-16 17:00:00	AAPL	Stock	17.975	17.9889	17.9404	17.9732	1035860.0
2013-08-16 17:30:00	AAPL	Stock	17.9664	17.9739	17.9404	17.9643	589652.0
2013-08-16 18:00:00	AAPL	Stock	17.9668	17.9818	17.9643	17.9732	101388.0
2013-08-16 18:30:00	AAPL	Stock	17.975	17.9804	17.9732	17.9743	66892.0
2013-08-16 19:00:00	AAPL	Stock	17.9732	17.9811	17.9646	17.9657	139720.0
2013-08-16 19:30:00	AAPL	Stock	17.9696	17.9739	17.9671	17.9679	147868.0
2013-08-16 08:00:00	MSFT	Stock	31.87	31.87	31.87	31.87	100.0
2013-08-16 08:30:00	MSFT	Stock	31.84	31.85	31.82	31.84	1400.0
2013-08-16 09:00:00	MSFT	Stock	31.84	31.84	31.75	31.79	21698.0
2013-08-16 09:30:00	MSFT	Stock	31.79	31.88	31.71	31.845	6706969.0
2013-08-16 10:00:00	MSFT	Stock	31.85	31.85	31.735	31.85	1867390.0
2013-08-16 10:30:00	MSFT	Stock	31.85	31.889	31.8	31.855	1946041.0
2013-08-16 11:00:00	MSFT	Stock	31.855	31.99	31.8	31.815	1851063.0
2013-08-16 11:30:00	MSFT	Stock	31.815	31.9	31.79	31.9	1124202.0
2013-08-16 12:00:00	MSFT	Stock	31.9	31.9	31.81	31.825	1281227.0
2013-08-16 12:30:00	MSFT	Stock	31.825	31.9	31.8	31.874	1127387.0
2013-08-16 13:00:00	MSFT	Stock	31.88	31.9	31.76	31.78	1071492.0
2013-08-16 13:30:00	MSFT	Stock	31.79	31.8	31.67	31.711	955373.0
2013-08-16 14:00:00	MSFT	Stock	31.71	31.75	31.66	31.715	1593063.0
2013-08-16 14:30:00	MSFT	Stock	31.715	31.82	31.69	31.811	1566713.0
2013-08-16 15:00:00	MSFT	Stock	31.811	31.86	31.78	31.86	1551226.0
2013-08-16 15:30:00	MSFT	Stock	31.85	31.96	31.78	31.79	5782448.0
2013-08-16 16:00:00	MSFT	Stock	31.8	31.867	31.67	31.67	2801332.0
2013-08-16 16:30:00	MSFT	Stock	31.76	31.8	31.68	31.69	11677.0
2013-08-16 17:00:00	MSFT	Stock	31.8	31.8	31.8	31.8	272623.0

> showing 50 of 79,873 rows — these rows as CSV

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