PREVIEW / stock_30min / 2013-06-20

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-20.parquet
  size:    1.6 MB
  rows:    83,089
  symbols: 3,511

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-06-20 04:00:00	AAPL	Stock	15.0875	15.0875	15.025	15.025	31780.0
2013-06-20 04:30:00	AAPL	Stock	15.0136	15.0186	14.9986	14.9986	22624.0
2013-06-20 05:00:00	AAPL	Stock	15.0036	15.0171	15.0036	15.0171	21476.0
2013-06-20 05:30:00	AAPL	Stock	15.0171	15.02	15.0036	15.0036	67732.0
2013-06-20 06:00:00	AAPL	Stock	15.0036	15.0036	14.9975	14.9975	11200.0
2013-06-20 06:30:00	AAPL	Stock	14.9968	15.0	14.9732	15.0	58800.0
2013-06-20 07:00:00	AAPL	Stock	14.9879	15.0125	14.9807	15.0	338940.0
2013-06-20 07:30:00	AAPL	Stock	15.0	15.0	14.9754	14.9971	615020.0
2013-06-20 08:00:00	AAPL	Stock	14.9996	15.0714	14.9821	15.0643	1178884.0
2013-06-20 08:30:00	AAPL	Stock	15.0607	15.0682	15.0071	15.0136	1282596.0
2013-06-20 09:00:00	AAPL	Stock	15.02	15.0268	14.9679	14.9875	2196068.0
2013-06-20 09:30:00	AAPL	Stock	14.9736	15.1585	14.9304	15.1386	60846828.0
2013-06-20 10:00:00	AAPL	Stock	15.1389	15.2136	15.0714	15.0768	42020692.0
2013-06-20 10:30:00	AAPL	Stock	15.0743	15.1239	15.0582	15.085	25877516.0
2013-06-20 11:00:00	AAPL	Stock	15.0836	15.0964	15.0236	15.0407	20709052.0
2013-06-20 11:30:00	AAPL	Stock	15.0461	15.095	15.0286	15.0486	14995708.0
2013-06-20 12:00:00	AAPL	Stock	15.0486	15.0554	15.0	15.0107	15670144.0
2013-06-20 12:30:00	AAPL	Stock	15.0116	15.0357	14.9679	14.9711	13051864.0
2013-06-20 13:00:00	AAPL	Stock	14.9693	15.0121	14.9571	14.9832	12452132.0
2013-06-20 13:30:00	AAPL	Stock	14.9871	15.0357	14.9667	15.0189	13734364.0
2013-06-20 14:00:00	AAPL	Stock	15.0182	15.0214	14.9321	14.9443	16206008.0
2013-06-20 14:30:00	AAPL	Stock	14.9464	14.9786	14.865	14.8911	25843020.0
2013-06-20 15:00:00	AAPL	Stock	14.8893	14.9118	14.85	14.8621	24963204.0
2013-06-20 15:30:00	AAPL	Stock	14.8621	14.9025	14.8275	14.8732	41007512.0
2013-06-20 16:00:00	AAPL	Stock	14.88	15.0724	14.8578	14.8786	15054984.0
2013-06-20 16:30:00	AAPL	Stock	14.8804	14.8871	14.8621	14.8768	4089988.0
2013-06-20 17:00:00	AAPL	Stock	14.8804	14.8804	14.8689	14.8804	109480.0
2013-06-20 17:30:00	AAPL	Stock	14.875	14.875	14.8714	14.8714	23492.0
2013-06-20 18:00:00	AAPL	Stock	14.8786	14.8875	14.8768	14.8793	53704.0
2013-06-20 18:30:00	AAPL	Stock	14.8871	14.8871	14.8736	14.8736	18256.0
2013-06-20 19:00:00	AAPL	Stock	14.8736	14.8904	14.8736	14.8736	19040.0
2013-06-20 19:30:00	AAPL	Stock	14.8739	14.8886	14.8732	14.8886	98392.0
2013-06-20 05:30:00	MSFT	Stock	34.27	34.27	34.25	34.25	900.0
2013-06-20 06:30:00	MSFT	Stock	34.3	34.3	34.3	34.3	500.0
2013-06-20 07:00:00	MSFT	Stock	34.29	34.4	34.29	34.4	6100.0
2013-06-20 07:30:00	MSFT	Stock	34.3	34.34	34.3	34.34	3900.0
2013-06-20 08:00:00	MSFT	Stock	34.3	34.41	34.25	34.41	10159.0
2013-06-20 08:30:00	MSFT	Stock	34.4	34.47	34.35	34.36	12175.0
2013-06-20 09:00:00	MSFT	Stock	34.32	34.32	34.25	34.26	17655.0
2013-06-20 09:30:00	MSFT	Stock	34.24	34.28	34.02	34.27	6379307.0
2013-06-20 10:00:00	MSFT	Stock	34.26	34.33	34.05	34.06	4660069.0
2013-06-20 10:30:00	MSFT	Stock	34.05	34.15	34.03	34.06	3521363.0
2013-06-20 11:00:00	MSFT	Stock	34.06	34.1	33.93	33.97	4328893.0
2013-06-20 11:30:00	MSFT	Stock	33.975	34.005	33.87	33.875	2353940.0
2013-06-20 12:00:00	MSFT	Stock	33.875	33.9	33.78	33.87	2604406.0
2013-06-20 12:30:00	MSFT	Stock	33.865	33.94	33.68	33.75	2040205.0
2013-06-20 13:00:00	MSFT	Stock	33.75	33.86	33.72	33.76	1883348.0
2013-06-20 13:30:00	MSFT	Stock	33.76	33.81	33.62	33.769	2801386.0
2013-06-20 14:00:00	MSFT	Stock	33.765	33.766	33.545	33.569	2387294.0
2013-06-20 14:30:00	MSFT	Stock	33.569	33.66	33.46	33.46	2862741.0

> showing 50 of 83,089 rows — these rows as CSV

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