PREVIEW / stock_30min / 2012-11-06

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-11-06.parquet
  size:    1.4 MB
  rows:    75,111
  symbols: 3,469

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
2012-11-06 05:00:00	AAPL	Stock	20.9786	20.9786	20.9786	20.9786	2800.0
2012-11-06 05:30:00	AAPL	Stock	20.9786	20.9786	20.9786	20.9786	5600.0
2012-11-06 06:00:00	AAPL	Stock	20.9786	21.0107	20.9782	21.0107	23100.0
2012-11-06 06:30:00	AAPL	Stock	21.0107	21.0261	21.0107	21.0261	121884.0
2012-11-06 07:00:00	AAPL	Stock	21.0179	21.0496	21.0179	21.0461	431284.0
2012-11-06 07:30:00	AAPL	Stock	21.0446	21.0632	21.0179	21.0586	493360.0
2012-11-06 08:00:00	AAPL	Stock	21.0586	21.0625	21.025	21.0432	1509340.0
2012-11-06 08:30:00	AAPL	Stock	21.0357	21.0618	21.0357	21.0425	516068.0
2012-11-06 09:00:00	AAPL	Stock	21.0454	21.0807	21.0321	21.0807	1392804.0
2012-11-06 09:30:00	AAPL	Stock	21.0804	21.0979	20.9571	20.9671	50235136.0
2012-11-06 10:00:00	AAPL	Stock	20.9664	20.9939	20.9018	20.9396	25913496.0
2012-11-06 10:30:00	AAPL	Stock	20.9414	20.9461	20.8714	20.9207	22823164.0
2012-11-06 11:00:00	AAPL	Stock	20.9207	20.9229	20.8489	20.8625	15833468.0
2012-11-06 11:30:00	AAPL	Stock	20.8629	20.9714	20.8396	20.9161	27865684.0
2012-11-06 12:00:00	AAPL	Stock	20.915	20.9936	20.9125	20.9379	20069308.0
2012-11-06 12:30:00	AAPL	Stock	20.9379	20.9721	20.9179	20.93	11124204.0
2012-11-06 13:00:00	AAPL	Stock	20.9271	20.9318	20.8579	20.8929	15302700.0
2012-11-06 13:30:00	AAPL	Stock	20.8946	20.9143	20.8643	20.8718	10292688.0
2012-11-06 14:00:00	AAPL	Stock	20.8711	20.885	20.8509	20.8704	13225016.0
2012-11-06 14:30:00	AAPL	Stock	20.8693	20.8929	20.7371	20.7907	28722960.0
2012-11-06 15:00:00	AAPL	Stock	20.7857	20.8189	20.7386	20.7736	27187552.0
2012-11-06 15:30:00	AAPL	Stock	20.7679	20.8489	20.7175	20.8161	50726088.0
2012-11-06 16:00:00	AAPL	Stock	20.8203	20.9098	20.783	20.8161	23873864.0
2012-11-06 16:30:00	AAPL	Stock	20.8161	20.9971	20.7735	20.8254	2040276.0
2012-11-06 17:00:00	AAPL	Stock	20.8257	20.8443	20.8161	20.8389	390376.0
2012-11-06 17:30:00	AAPL	Stock	20.8325	20.8393	20.83	20.83	67900.0
2012-11-06 18:00:00	AAPL	Stock	20.8321	20.8389	20.8321	20.8357	49924.0
2012-11-06 18:30:00	AAPL	Stock	20.8325	20.8393	20.8221	20.8393	236824.0
2012-11-06 19:00:00	AAPL	Stock	20.8339	20.8339	20.8282	20.8304	64064.0
2012-11-06 19:30:00	AAPL	Stock	20.8236	20.83	20.7904	20.7904	152068.0
2012-11-06 07:00:00	MSFT	Stock	29.62	29.62	29.62	29.62	100.0
2012-11-06 08:00:00	MSFT	Stock	29.63	29.72	29.58	29.72	13518.0
2012-11-06 08:30:00	MSFT	Stock	29.75	29.75	29.7	29.7	6200.0
2012-11-06 09:00:00	MSFT	Stock	29.7	29.84	29.7	29.83	28839.0
2012-11-06 09:30:00	MSFT	Stock	29.84	29.95	29.61	29.77	4768109.0
2012-11-06 10:00:00	MSFT	Stock	29.77	29.84	29.71	29.84	2600542.0
2012-11-06 10:30:00	MSFT	Stock	29.839	29.95	29.8	29.89	3647027.0
2012-11-06 11:00:00	MSFT	Stock	29.89	29.92	29.86	29.903	1813088.0
2012-11-06 11:30:00	MSFT	Stock	29.91	30.06	29.89	30.052	4479008.0
2012-11-06 12:00:00	MSFT	Stock	30.06	30.2	30.04	30.12	3722419.0
2012-11-06 12:30:00	MSFT	Stock	30.12	30.15	30.04	30.093	2982376.0
2012-11-06 13:00:00	MSFT	Stock	30.1	30.1	29.95	30.02	2254826.0
2012-11-06 13:30:00	MSFT	Stock	30.02	30.07	29.94	29.96	1870252.0
2012-11-06 14:00:00	MSFT	Stock	29.955	29.98	29.91	29.95	1778709.0
2012-11-06 14:30:00	MSFT	Stock	29.96	29.99	29.84	29.89	1640178.0
2012-11-06 15:00:00	MSFT	Stock	29.89	29.94	29.83	29.843	2953088.0
2012-11-06 15:30:00	MSFT	Stock	29.84	29.92	29.8	29.86	4940234.0
2012-11-06 16:00:00	MSFT	Stock	29.85	29.928	29.85	29.857	2665840.0
2012-11-06 16:30:00	MSFT	Stock	29.85	29.88	29.597	29.88	774044.0
2012-11-06 17:00:00	MSFT	Stock	29.86	29.87	29.86	29.87	300.0

> showing 50 of 75,111 rows — these rows as CSV

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