PREVIEW / stock_30min / 2013-02-25

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-25.parquet
  size:    1.5 MB
  rows:    78,375
  symbols: 3,496

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-02-25 04:30:00	AAPL	Stock	16.1679	16.1679	16.1679	16.1679	5600.0
2013-02-25 05:30:00	AAPL	Stock	16.2393	16.2429	16.2393	16.2429	5600.0
2013-02-25 06:00:00	AAPL	Stock	16.2429	16.2429	16.2107	16.2107	18200.0
2013-02-25 06:30:00	AAPL	Stock	16.23	16.2321	16.1964	16.2071	70700.0
2013-02-25 07:00:00	AAPL	Stock	16.2179	16.2482	16.2007	16.2482	380016.0
2013-02-25 07:30:00	AAPL	Stock	16.2482	16.2536	16.2339	16.2429	196532.0
2013-02-25 08:00:00	AAPL	Stock	16.2429	16.25	16.0714	16.1607	1013628.0
2013-02-25 08:30:00	AAPL	Stock	16.1607	16.1754	16.1393	16.1518	510692.0
2013-02-25 09:00:00	AAPL	Stock	16.1518	16.2286	16.1443	16.2029	1934772.0
2013-02-25 09:30:00	AAPL	Stock	16.21	16.2432	16.1439	16.2214	50698480.0
2013-02-25 10:00:00	AAPL	Stock	16.2221	16.2543	16.1296	16.1493	42176988.0
2013-02-25 10:30:00	AAPL	Stock	16.1479	16.1771	16.0896	16.1225	32199720.0
2013-02-25 11:00:00	AAPL	Stock	16.1232	16.1282	16.0683	16.0929	25589816.0
2013-02-25 11:30:00	AAPL	Stock	16.0914	16.109	15.9893	16.0154	25997468.0
2013-02-25 12:00:00	AAPL	Stock	16.0132	16.0696	16.0046	16.0543	12446252.0
2013-02-25 12:30:00	AAPL	Stock	16.0546	16.0764	16.0107	16.06	10503500.0
2013-02-25 13:00:00	AAPL	Stock	16.0621	16.0857	16.0271	16.0339	12555256.0
2013-02-25 13:30:00	AAPL	Stock	16.035	16.0429	15.9918	16.0061	13935852.0
2013-02-25 14:00:00	AAPL	Stock	16.005	16.0082	15.9536	15.9845	16758588.0
2013-02-25 14:30:00	AAPL	Stock	15.9875	16.0257	15.98	16.0054	15560300.0
2013-02-25 15:00:00	AAPL	Stock	16.0071	16.01	15.9025	15.9189	24310020.0
2013-02-25 15:30:00	AAPL	Stock	15.9193	15.9221	15.8061	15.8189	57756328.0
2013-02-25 16:00:00	AAPL	Stock	15.8143	16.0878	15.7682	15.7907	14794108.0
2013-02-25 16:30:00	AAPL	Stock	15.7893	16.1327	15.7761	15.8036	1395744.0
2013-02-25 17:00:00	AAPL	Stock	15.8086	15.8143	15.8011	15.8139	655284.0
2013-02-25 17:30:00	AAPL	Stock	15.8157	15.82	15.8125	15.8164	317464.0
2013-02-25 18:00:00	AAPL	Stock	15.8179	15.8382	15.8146	15.8382	180768.0
2013-02-25 18:30:00	AAPL	Stock	15.8389	15.8389	15.8214	15.8304	272328.0
2013-02-25 19:00:00	AAPL	Stock	15.8304	15.8371	15.8304	15.8371	120400.0
2013-02-25 19:30:00	AAPL	Stock	15.8368	15.8621	15.8346	15.8618	405972.0
2013-02-25 08:00:00	MSFT	Stock	27.85	27.89	27.71	27.86	14973.0
2013-02-25 08:30:00	MSFT	Stock	27.86	27.86	27.86	27.86	1000.0
2013-02-25 09:00:00	MSFT	Stock	27.88	27.97	27.86	27.97	24060.0
2013-02-25 09:30:00	MSFT	Stock	27.97	28.05	27.86	27.89	3691826.0
2013-02-25 10:00:00	MSFT	Stock	27.89	27.96	27.85	27.87	3631925.0
2013-02-25 10:30:00	MSFT	Stock	27.86	27.9	27.78	27.82	3226313.0
2013-02-25 11:00:00	MSFT	Stock	27.825	27.84	27.79	27.83	2017700.0
2013-02-25 11:30:00	MSFT	Stock	27.83	27.84	27.66	27.715	4103359.0
2013-02-25 12:00:00	MSFT	Stock	27.71	27.75	27.69	27.734	1428248.0
2013-02-25 12:30:00	MSFT	Stock	27.735	27.81	27.725	27.77	1459295.0
2013-02-25 13:00:00	MSFT	Stock	27.774	27.8	27.72	27.76	1494455.0
2013-02-25 13:30:00	MSFT	Stock	27.76	27.77	27.665	27.69	2843966.0
2013-02-25 14:00:00	MSFT	Stock	27.69	27.69	27.61	27.666	3160635.0
2013-02-25 14:30:00	MSFT	Stock	27.67	27.7	27.64	27.681	1787328.0
2013-02-25 15:00:00	MSFT	Stock	27.68	27.7	27.55	27.576	3955265.0
2013-02-25 15:30:00	MSFT	Stock	27.57	27.6	27.37	27.38	10481189.0
2013-02-25 16:00:00	MSFT	Stock	27.38	27.782	27.342	27.37	4107066.0
2013-02-25 16:30:00	MSFT	Stock	27.38	27.57	27.32	27.34	37239.0
2013-02-25 17:00:00	MSFT	Stock	27.34	27.39	27.34	27.35	14292.0
2013-02-25 17:30:00	MSFT	Stock	27.35	27.78	27.35	27.35	957.0

> showing 50 of 78,375 rows — these rows as CSV

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