PREVIEW / stock_30min / 2011-06-15

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-06-15.parquet
  size:    1.4 MB
  rows:    77,715
  symbols: 3,558

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-06-15 04:00:00	AAPL	Stock	11.875	11.875	11.875	11.875	2800.0
2011-06-15 04:30:00	AAPL	Stock	11.8432	11.8439	11.8432	11.8439	5600.0
2011-06-15 05:00:00	AAPL	Stock	11.8036	11.8036	11.7896	11.7911	39200.0
2011-06-15 06:00:00	AAPL	Stock	11.8121	11.8121	11.795	11.795	11200.0
2011-06-15 06:30:00	AAPL	Stock	11.8157	11.8157	11.8089	11.8089	18620.0
2011-06-15 07:00:00	AAPL	Stock	11.8057	11.8318	11.8057	11.8261	100800.0
2011-06-15 07:30:00	AAPL	Stock	11.8307	11.8354	11.825	11.8254	92848.0
2011-06-15 08:00:00	AAPL	Stock	11.8254	11.8379	11.8036	11.8186	525784.0
2011-06-15 08:30:00	AAPL	Stock	11.8093	11.8093	11.7632	11.7754	1241352.0
2011-06-15 09:00:00	AAPL	Stock	11.7696	11.7857	11.7604	11.7768	886368.0
2011-06-15 09:30:00	AAPL	Stock	11.7764	11.7804	11.7293	11.7546	47343660.0
2011-06-15 10:00:00	AAPL	Stock	11.7539	11.7964	11.7482	11.7582	24544632.0
2011-06-15 10:30:00	AAPL	Stock	11.7593	11.7751	11.7386	11.7464	21254408.0
2011-06-15 11:00:00	AAPL	Stock	11.7459	11.7564	11.7336	11.7371	14844424.0
2011-06-15 11:30:00	AAPL	Stock	11.7389	11.7404	11.6793	11.6929	38267628.0
2011-06-15 12:00:00	AAPL	Stock	11.6944	11.6982	11.6361	11.6589	30286172.0
2011-06-15 12:30:00	AAPL	Stock	11.6607	11.6821	11.6446	11.6525	17748024.0
2011-06-15 13:00:00	AAPL	Stock	11.6536	11.685	11.6429	11.6821	16586248.0
2011-06-15 13:30:00	AAPL	Stock	11.6821	11.6864	11.6536	11.66	18860156.0
2011-06-15 14:00:00	AAPL	Stock	11.66	11.6836	11.6429	11.6518	18381160.0
2011-06-15 14:30:00	AAPL	Stock	11.6516	11.6843	11.6382	11.6457	22207444.0
2011-06-15 15:00:00	AAPL	Stock	11.6436	11.6625	11.6029	11.6357	47456528.0
2011-06-15 15:30:00	AAPL	Stock	11.6357	11.6786	11.6121	11.6711	50768452.0
2011-06-15 16:00:00	AAPL	Stock	11.6604	11.7453	11.6604	11.6757	9166220.0
2011-06-15 16:30:00	AAPL	Stock	11.6818	11.6825	11.6362	11.6779	613928.0
2011-06-15 17:00:00	AAPL	Stock	11.6775	11.7727	11.6575	11.6696	381472.0
2011-06-15 17:30:00	AAPL	Stock	11.6679	11.6746	11.6675	11.6746	49056.0
2011-06-15 18:00:00	AAPL	Stock	11.675	11.6821	11.6696	11.6821	3331972.0
2011-06-15 18:30:00	AAPL	Stock	11.6821	11.6839	11.6786	11.6786	58800.0
2011-06-15 19:00:00	AAPL	Stock	11.6821	11.6821	11.6782	11.6789	51800.0
2011-06-15 19:30:00	AAPL	Stock	11.6757	11.6804	11.6711	11.6804	74088.0
2011-06-15 05:00:00	MSFT	Stock	24.06	24.06	24.06	24.06	500.0
2011-06-15 07:00:00	MSFT	Stock	24.11	24.11	24.11	24.11	100.0
2011-06-15 08:00:00	MSFT	Stock	24.1	24.15	24.08	24.08	2916.0
2011-06-15 08:30:00	MSFT	Stock	24.06	24.07	24.01	24.04	13274.0
2011-06-15 09:00:00	MSFT	Stock	24.02	24.04	23.98	24.01	28872.0
2011-06-15 09:30:00	MSFT	Stock	24.0	24.01	23.89	23.92	4644001.0
2011-06-15 10:00:00	MSFT	Stock	23.92	23.96	23.88	23.915	2897828.0
2011-06-15 10:30:00	MSFT	Stock	23.913	23.97	23.88	23.88	2348891.0
2011-06-15 11:00:00	MSFT	Stock	23.89	23.94	23.84	23.9	2198456.0
2011-06-15 11:30:00	MSFT	Stock	23.895	23.905	23.74	23.8	3642070.0
2011-06-15 12:00:00	MSFT	Stock	23.8	23.84	23.7	23.8	3023263.0
2011-06-15 12:30:00	MSFT	Stock	23.79	23.85	23.74	23.76	3265403.0
2011-06-15 13:00:00	MSFT	Stock	23.76	23.78	23.7	23.76	2241420.0
2011-06-15 13:30:00	MSFT	Stock	23.75	23.77	23.7	23.755	1974314.0
2011-06-15 14:00:00	MSFT	Stock	23.755	23.82	23.7	23.719	2711824.0
2011-06-15 14:30:00	MSFT	Stock	23.72	23.77	23.69	23.71	3335753.0
2011-06-15 15:00:00	MSFT	Stock	23.71	23.76	23.67	23.74	3479961.0
2011-06-15 15:30:00	MSFT	Stock	23.74	23.78	23.69	23.76	9625807.0
2011-06-15 16:00:00	MSFT	Stock	23.75	23.8	23.74	23.76	2680502.0

> showing 50 of 77,715 rows — these rows as CSV

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