PREVIEW / stock_30min / 2010-02-08

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-08.parquet
  size:    1.3 MB
  rows:    71,942
  symbols: 3,408

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
2010-02-08 05:30:00	AAPL	Stock	6.9789	6.9789	6.9789	6.9789	5040.0
2010-02-08 07:00:00	AAPL	Stock	6.9782	6.9782	6.9743	6.9743	8400.0
2010-02-08 07:30:00	AAPL	Stock	6.955	6.9882	6.9311	6.9882	154616.0
2010-02-08 08:00:00	AAPL	Stock	6.9754	6.9993	6.9682	6.9764	891632.0
2010-02-08 08:30:00	AAPL	Stock	6.975	6.975	6.9575	6.9714	701456.0
2010-02-08 09:00:00	AAPL	Stock	6.9711	6.9893	6.9629	6.9893	939400.0
2010-02-08 09:30:00	AAPL	Stock	6.9889	7.0429	6.9643	7.0111	86911440.0
2010-02-08 10:00:00	AAPL	Stock	7.0139	7.0493	7.0	7.0218	52590104.0
2010-02-08 10:30:00	AAPL	Stock	7.0214	7.0393	7.0039	7.0332	27661536.0
2010-02-08 11:00:00	AAPL	Stock	7.0325	7.0671	7.0325	7.0407	35033992.0
2010-02-08 11:30:00	AAPL	Stock	7.0414	7.0514	7.0257	7.035	21437668.0
2010-02-08 12:00:00	AAPL	Stock	7.0374	7.0454	7.0193	7.044	16683828.0
2010-02-08 12:30:00	AAPL	Stock	7.045	7.0461	7.0282	7.0314	15721468.0
2010-02-08 13:00:00	AAPL	Stock	7.0321	7.0371	6.995	7.0064	28054852.0
2010-02-08 13:30:00	AAPL	Stock	7.0068	7.0107	6.975	6.9968	25432624.0
2010-02-08 14:00:00	AAPL	Stock	6.9961	7.0179	6.9961	7.0082	16244060.0
2010-02-08 14:30:00	AAPL	Stock	7.0068	7.0136	6.9861	6.9986	19312188.0
2010-02-08 15:00:00	AAPL	Stock	6.9986	7.0043	6.9646	6.9817	33462604.0
2010-02-08 15:30:00	AAPL	Stock	6.9818	6.9886	6.9286	6.9289	53299512.0
2010-02-08 16:00:00	AAPL	Stock	6.93	7.0127	6.9254	6.935	28790748.0
2010-02-08 16:30:00	AAPL	Stock	6.9824	6.9824	6.9321	6.935	349048.0
2010-02-08 17:00:00	AAPL	Stock	7.0314	7.0314	6.9214	6.9214	680540.0
2010-02-08 17:30:00	AAPL	Stock	6.9214	6.9229	6.9161	6.9189	175420.0
2010-02-08 18:00:00	AAPL	Stock	6.9232	6.9329	6.92	6.9239	273224.0
2010-02-08 18:30:00	AAPL	Stock	6.925	6.9264	6.9232	6.9232	38724.0
2010-02-08 19:00:00	AAPL	Stock	6.925	6.9279	6.9107	6.9229	230832.0
2010-02-08 19:30:00	AAPL	Stock	6.9143	6.9193	6.8936	6.8964	945252.0
2010-02-08 07:00:00	MSFT	Stock	27.82	27.82	27.82	27.82	1200.0
2010-02-08 07:30:00	MSFT	Stock	27.83	27.95	27.78	27.95	6300.0
2010-02-08 08:00:00	MSFT	Stock	27.95	28.03	27.95	28.02	11178.0
2010-02-08 08:30:00	MSFT	Stock	28.0	28.02	27.98	27.98	6415.0
2010-02-08 09:00:00	MSFT	Stock	27.98	28.02	27.98	28.0	4800.0
2010-02-08 09:30:00	MSFT	Stock	28.01	28.01	27.57	27.85	6915161.0
2010-02-08 10:00:00	MSFT	Stock	27.85	28.0	27.8	27.961	4889536.0
2010-02-08 10:30:00	MSFT	Stock	27.97	27.97	27.84	27.86	2590797.0
2010-02-08 11:00:00	MSFT	Stock	27.851	28.03	27.851	28.0	3512896.0
2010-02-08 11:30:00	MSFT	Stock	28.0	28.08	27.95	28.038	3216728.0
2010-02-08 12:00:00	MSFT	Stock	28.04	28.06	27.97	28.05	1938556.0
2010-02-08 12:30:00	MSFT	Stock	28.05	28.07	27.92	27.94	2808883.0
2010-02-08 13:00:00	MSFT	Stock	27.94	27.95	27.75	27.76	3541066.0
2010-02-08 13:30:00	MSFT	Stock	27.77	27.85	27.76	27.84	1941676.0
2010-02-08 14:00:00	MSFT	Stock	27.835	27.92	27.831	27.89	2091055.0
2010-02-08 14:30:00	MSFT	Stock	27.885	27.92	27.82	27.87	2253268.0
2010-02-08 15:00:00	MSFT	Stock	27.865	27.89	27.76	27.8	4326654.0
2010-02-08 15:30:00	MSFT	Stock	27.8	27.86	27.66	27.72	7547085.0
2010-02-08 16:00:00	MSFT	Stock	27.72	27.866	27.57	27.72	3679178.0
2010-02-08 16:30:00	MSFT	Stock	27.803	27.96	27.6	27.78	48896.0
2010-02-08 17:00:00	MSFT	Stock	28.02	28.02	27.6	27.61	393985.0
2010-02-08 17:30:00	MSFT	Stock	27.61	27.61	27.61	27.61	200.0
2010-02-08 18:00:00	MSFT	Stock	27.65	27.72	27.65	27.68	3204.0

> showing 50 of 71,942 rows — these rows as CSV

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