PREVIEW / stock_30min / 2008-08-06

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-06.parquet
  size:    1.2 MB
  rows:    68,409
  symbols: 3,322

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
2008-08-06 07:30:00	AAPL	Stock	5.7411	5.7518	5.7411	5.75	40880.0
2008-08-06 08:00:00	AAPL	Stock	5.7171	5.735	5.7171	5.7221	1049664.0
2008-08-06 08:30:00	AAPL	Stock	5.7229	5.7229	5.7107	5.7143	627004.0
2008-08-06 09:00:00	AAPL	Stock	5.7164	5.7268	5.7096	5.7118	937440.0
2008-08-06 09:30:00	AAPL	Stock	5.7132	5.715	5.6668	5.6882	82418896.0
2008-08-06 10:00:00	AAPL	Stock	5.6882	5.7089	5.6429	5.6975	70966056.0
2008-08-06 10:30:00	AAPL	Stock	5.6964	5.7043	5.6668	5.6821	46416328.0
2008-08-06 11:00:00	AAPL	Stock	5.6814	5.7764	5.6621	5.7757	72933056.0
2008-08-06 11:30:00	AAPL	Stock	5.7761	5.8243	5.7546	5.8229	70195356.0
2008-08-06 12:00:00	AAPL	Stock	5.8227	5.8679	5.8161	5.8556	78005256.0
2008-08-06 12:30:00	AAPL	Stock	5.8557	5.8929	5.8254	5.8364	48486648.0
2008-08-06 13:00:00	AAPL	Stock	5.8361	5.8511	5.8193	5.845	34274940.0
2008-08-06 13:30:00	AAPL	Stock	5.8457	5.8679	5.81	5.8296	43203356.0
2008-08-06 14:00:00	AAPL	Stock	5.83	5.8679	5.8196	5.8564	41531924.0
2008-08-06 14:30:00	AAPL	Stock	5.8571	5.8929	5.8568	5.8654	58268728.0
2008-08-06 15:00:00	AAPL	Stock	5.8654	5.8821	5.8396	5.8418	48644372.0
2008-08-06 15:30:00	AAPL	Stock	5.8418	5.8743	5.8304	5.8639	73003952.0
2008-08-06 16:00:00	AAPL	Stock	5.864	5.8821	5.79	5.8686	8884568.0
2008-08-06 16:30:00	AAPL	Stock	5.8675	5.8704	5.7921	5.87	227668.0
2008-08-06 17:00:00	AAPL	Stock	5.8711	5.875	5.8629	5.8629	506128.0
2008-08-06 17:30:00	AAPL	Stock	5.8632	5.8643	5.8575	5.8579	148064.0
2008-08-06 18:00:00	AAPL	Stock	5.8575	5.8575	5.8482	5.8496	35000.0
2008-08-06 18:30:00	AAPL	Stock	5.8489	5.8489	5.8482	5.8482	8120.0
2008-08-06 19:00:00	AAPL	Stock	5.8429	5.8429	5.8429	5.8429	3080.0
2008-08-06 19:30:00	AAPL	Stock	5.8418	5.8464	5.8414	5.8461	42560.0
2008-08-06 07:00:00	MSFT	Stock	26.88	27.0	26.26	26.44	42355.0
2008-08-06 07:30:00	MSFT	Stock	26.55	26.61	26.47	26.61	134610.0
2008-08-06 08:00:00	MSFT	Stock	26.55	26.7	26.21	26.59	378753.0
2008-08-06 08:30:00	MSFT	Stock	26.6	26.66	26.53	26.57	89434.0
2008-08-06 09:00:00	MSFT	Stock	26.57	27.03	26.54	26.72	314006.0
2008-08-06 09:30:00	MSFT	Stock	26.72	26.75	26.38	26.46	11616346.0
2008-08-06 10:00:00	MSFT	Stock	26.46	26.58	26.4	26.53	5431391.0
2008-08-06 10:30:00	MSFT	Stock	26.53	26.54	26.39	26.47	8464518.0
2008-08-06 11:00:00	MSFT	Stock	26.47	26.87	26.45	26.87	8382121.0
2008-08-06 11:30:00	MSFT	Stock	26.87	26.95	26.76	26.811	6303919.0
2008-08-06 12:00:00	MSFT	Stock	26.81	26.95	26.75	26.88	4404982.0
2008-08-06 12:30:00	MSFT	Stock	26.89	26.902	26.66	26.7	4809949.0
2008-08-06 13:00:00	MSFT	Stock	26.7	26.81	26.66	26.81	2727049.0
2008-08-06 13:30:00	MSFT	Stock	26.805	26.82	26.65	26.732	4729392.0
2008-08-06 14:00:00	MSFT	Stock	26.74	26.93	26.73	26.9	4729209.0
2008-08-06 14:30:00	MSFT	Stock	26.89	27.07	26.888	27.05	5608813.0
2008-08-06 15:00:00	MSFT	Stock	27.05	27.16	27.04	27.09	8960631.0
2008-08-06 15:30:00	MSFT	Stock	27.1	27.14	26.99	26.99	12608665.0
2008-08-06 16:00:00	MSFT	Stock	27.01	27.125	26.774	27.01	2839852.0
2008-08-06 16:30:00	MSFT	Stock	27.0	27.02	26.78	26.98	61369.0
2008-08-06 17:00:00	MSFT	Stock	26.98	27.15	26.98	27.09	6597.0
2008-08-06 17:30:00	MSFT	Stock	27.04	27.1	27.0	27.0	1650.0
2008-08-06 18:00:00	MSFT	Stock	26.97	27.09	26.97	27.09	22125.0
2008-08-06 18:30:00	MSFT	Stock	27.0	27.01	26.98	27.01	12055.0
2008-08-06 19:30:00	MSFT	Stock	26.98	26.98	26.98	26.98	200.0

> showing 50 of 68,409 rows — these rows as CSV

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