PREVIEW / stock_30min / 2011-08-09

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-09.parquet
  size:    1.6 MB
  rows:    84,495
  symbols: 3,566

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
2011-08-09 04:00:00	AAPL	Stock	12.5914	12.6104	12.5046	12.5271	134260.0
2011-08-09 04:30:00	AAPL	Stock	12.5	12.5	12.3643	12.4861	146720.0
2011-08-09 05:00:00	AAPL	Stock	12.4714	12.4714	12.3396	12.3482	112560.0
2011-08-09 05:30:00	AAPL	Stock	12.3775	12.5275	12.3775	12.5	131936.0
2011-08-09 06:00:00	AAPL	Stock	12.5	12.5532	12.4971	12.4971	251440.0
2011-08-09 06:30:00	AAPL	Stock	12.5357	12.6618	12.5179	12.6429	455980.0
2011-08-09 07:00:00	AAPL	Stock	12.6496	12.7593	12.6154	12.7593	2964276.0
2011-08-09 07:30:00	AAPL	Stock	12.7593	12.8232	12.6936	12.7768	2426900.0
2011-08-09 08:00:00	AAPL	Stock	12.7821	12.8036	12.7071	12.7764	3467044.0
2011-08-09 08:30:00	AAPL	Stock	12.775	12.8479	12.7429	12.8243	5705700.0
2011-08-09 09:00:00	AAPL	Stock	12.8225	12.9286	12.7921	12.9129	6559868.0
2011-08-09 09:30:00	AAPL	Stock	12.9125	12.9957	12.7161	12.9782	160190044.0
2011-08-09 10:00:00	AAPL	Stock	12.9793	13.1143	12.978	13.1089	116445644.0
2011-08-09 10:30:00	AAPL	Stock	13.1086	13.1964	13.0754	13.179	81493608.0
2011-08-09 11:00:00	AAPL	Stock	13.179	13.1854	13.06	13.1711	58445072.0
2011-08-09 11:30:00	AAPL	Stock	13.1746	13.1979	13.1214	13.17	35049112.0
2011-08-09 12:00:00	AAPL	Stock	13.1714	13.1975	13.1432	13.1736	33512892.0
2011-08-09 12:30:00	AAPL	Stock	13.1731	13.2104	13.125	13.1268	38416476.0
2011-08-09 13:00:00	AAPL	Stock	13.1254	13.1671	13.1036	13.12	30553964.0
2011-08-09 13:30:00	AAPL	Stock	13.1196	13.133	12.995	13.0711	48154820.0
2011-08-09 14:00:00	AAPL	Stock	13.0711	13.1768	12.8571	13.0821	91077084.0
2011-08-09 14:30:00	AAPL	Stock	13.0839	13.0889	12.6786	12.9236	129520104.0
2011-08-09 15:00:00	AAPL	Stock	12.9218	13.0821	12.8543	13.0686	78688512.0
2011-08-09 15:30:00	AAPL	Stock	13.0714	13.3789	13.0157	13.3721	113595664.0
2011-08-09 16:00:00	AAPL	Stock	13.3721	13.3789	13.0339	13.3171	17032680.0
2011-08-09 16:30:00	AAPL	Stock	13.3107	13.3602	13.069	13.3307	5472712.0
2011-08-09 17:00:00	AAPL	Stock	13.3339	13.3907	13.1236	13.3818	998676.0
2011-08-09 17:30:00	AAPL	Stock	13.3839	13.3993	13.3789	13.3971	999880.0
2011-08-09 18:00:00	AAPL	Stock	13.3936	13.3996	13.3575	13.3929	608132.0
2011-08-09 18:30:00	AAPL	Stock	13.3929	13.3996	13.3807	13.3996	213080.0
2011-08-09 19:00:00	AAPL	Stock	13.3932	13.4018	13.3871	13.3979	149968.0
2011-08-09 19:30:00	AAPL	Stock	13.4018	13.4107	13.3975	13.4093	406000.0
2011-08-09 04:30:00	MSFT	Stock	24.1	24.1	24.1	24.1	200.0
2011-08-09 05:00:00	MSFT	Stock	24.02	24.02	24.0	24.0	700.0
2011-08-09 05:30:00	MSFT	Stock	24.06	24.17	24.06	24.17	900.0
2011-08-09 06:00:00	MSFT	Stock	24.17	24.23	24.17	24.23	5600.0
2011-08-09 06:30:00	MSFT	Stock	24.13	24.51	24.13	24.5	12830.0
2011-08-09 07:00:00	MSFT	Stock	24.47	24.71	24.47	24.69	29790.0
2011-08-09 07:30:00	MSFT	Stock	24.65	24.65	24.44	24.6	26919.0
2011-08-09 08:00:00	MSFT	Stock	24.65	24.72	24.5	24.63	56547.0
2011-08-09 08:30:00	MSFT	Stock	24.63	24.66	24.48	24.65	53276.0
2011-08-09 09:00:00	MSFT	Stock	24.6	24.74	24.57	24.68	36472.0
2011-08-09 09:30:00	MSFT	Stock	24.71	24.98	24.3	24.97	17552413.0
2011-08-09 10:00:00	MSFT	Stock	24.98	25.13	24.72	24.81	9515482.0
2011-08-09 10:30:00	MSFT	Stock	24.81	24.84	24.61	24.64	7843881.0
2011-08-09 11:00:00	MSFT	Stock	24.63	24.71	24.49	24.7	5985436.0
2011-08-09 11:30:00	MSFT	Stock	24.705	24.855	24.61	24.82	5756214.0
2011-08-09 12:00:00	MSFT	Stock	24.82	24.94	24.781	24.885	4512116.0
2011-08-09 12:30:00	MSFT	Stock	24.884	25.0	24.79	24.81	4087426.0
2011-08-09 13:00:00	MSFT	Stock	24.806	24.87	24.73	24.77	3461154.0

> showing 50 of 84,495 rows — these rows as CSV

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