PREVIEW / stock_30min / 2008-03-14

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-03-14.parquet
  size:    1.2 MB
  rows:    68,142
  symbols: 3,259

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-03-14 05:30:00	AAPL	Stock	4.5589	4.5589	4.5589	4.5589	2800.0
2008-03-14 06:00:00	AAPL	Stock	4.5589	4.56	4.5589	4.56	8400.0
2008-03-14 06:30:00	AAPL	Stock	4.5604	4.5679	4.56	4.5679	11200.0
2008-03-14 07:00:00	AAPL	Stock	4.56	4.56	4.5536	4.5536	50400.0
2008-03-14 07:30:00	AAPL	Stock	4.5471	4.5504	4.5471	4.5504	75600.0
2008-03-14 08:00:00	AAPL	Stock	4.5504	4.5875	4.55	4.5696	2545424.0
2008-03-14 08:30:00	AAPL	Stock	4.5725	4.6536	4.5711	4.6357	12290740.0
2008-03-14 09:00:00	AAPL	Stock	4.6364	4.6696	4.6357	4.6382	9797172.0
2008-03-14 09:30:00	AAPL	Stock	4.6357	4.6536	4.5179	4.5182	177327976.0
2008-03-14 10:00:00	AAPL	Stock	4.5189	4.575	4.4357	4.5229	159612236.0
2008-03-14 10:30:00	AAPL	Stock	4.5236	4.5657	4.4929	4.5484	94757684.0
2008-03-14 11:00:00	AAPL	Stock	4.5482	4.5757	4.5025	4.5193	84040852.0
2008-03-14 11:30:00	AAPL	Stock	4.5193	4.5621	4.5089	4.5496	55809096.0
2008-03-14 12:00:00	AAPL	Stock	4.5486	4.5625	4.5257	4.5414	38837904.0
2008-03-14 12:30:00	AAPL	Stock	4.5407	4.5411	4.4929	4.5114	55088124.0
2008-03-14 13:00:00	AAPL	Stock	4.5125	4.5211	4.485	4.5016	54435976.0
2008-03-14 13:30:00	AAPL	Stock	4.5016	4.5189	4.4854	4.4918	45770060.0
2008-03-14 14:00:00	AAPL	Stock	4.4911	4.5014	4.4479	4.4632	67241048.0
2008-03-14 14:30:00	AAPL	Stock	4.4621	4.5064	4.45	4.4917	71291696.0
2008-03-14 15:00:00	AAPL	Stock	4.4911	4.5429	4.4814	4.5286	97004964.0
2008-03-14 15:30:00	AAPL	Stock	4.5279	4.5425	4.4825	4.5343	111769000.0
2008-03-14 16:00:00	AAPL	Stock	4.535	4.5389	4.5196	4.5218	18669728.0
2008-03-14 16:30:00	AAPL	Stock	4.5282	4.5304	4.5218	4.5296	286104.0
2008-03-14 17:00:00	AAPL	Stock	4.5286	4.5304	4.5214	4.5214	193844.0
2008-03-14 17:30:00	AAPL	Stock	4.5261	4.5279	4.5218	4.525	64036.0
2008-03-14 18:00:00	AAPL	Stock	4.525	4.5264	4.5225	4.5264	93716.0
2008-03-14 18:30:00	AAPL	Stock	4.5225	4.5264	4.5221	4.5232	79156.0
2008-03-14 19:00:00	AAPL	Stock	4.525	4.5257	4.5232	4.5232	46900.0
2008-03-14 19:30:00	AAPL	Stock	4.5232	4.5257	4.5218	4.5257	104496.0
2008-03-14 07:30:00	MSFT	Stock	28.5	28.5	28.5	28.5	100.0
2008-03-14 08:00:00	MSFT	Stock	28.62	28.62	28.4	28.4	1798.0
2008-03-14 08:30:00	MSFT	Stock	28.66	28.85	28.66	28.81	40853.0
2008-03-14 09:00:00	MSFT	Stock	28.82	28.85	28.72	28.73	129402.0
2008-03-14 09:30:00	MSFT	Stock	28.7	29.01	28.24	28.26	11918236.0
2008-03-14 10:00:00	MSFT	Stock	28.25	28.51	27.86	28.32	14114093.0
2008-03-14 10:30:00	MSFT	Stock	28.31	28.43	28.1	28.34	7182666.0
2008-03-14 11:00:00	MSFT	Stock	28.34	28.38	28.01	28.09	6062323.0
2008-03-14 11:30:00	MSFT	Stock	28.09	28.26	28.0	28.06	3931882.0
2008-03-14 12:00:00	MSFT	Stock	28.05	28.13	28.01	28.06	2652147.0
2008-03-14 12:30:00	MSFT	Stock	28.06	28.08	27.89	27.98	5112058.0
2008-03-14 13:00:00	MSFT	Stock	27.98	27.98	27.86	27.92	5209311.0
2008-03-14 13:30:00	MSFT	Stock	27.92	27.96	27.87	27.87	4169865.0
2008-03-14 14:00:00	MSFT	Stock	27.87	27.958	27.68	27.72	6472996.0
2008-03-14 14:30:00	MSFT	Stock	27.72	28.03	27.64	27.94	8266961.0
2008-03-14 15:00:00	MSFT	Stock	27.95	28.19	27.87	28.1	9975224.0
2008-03-14 15:30:00	MSFT	Stock	28.09	28.13	27.805	27.97	14769993.0
2008-03-14 16:00:00	MSFT	Stock	27.962	28.121	27.75	27.81	4783945.0
2008-03-14 16:30:00	MSFT	Stock	27.81	27.997	27.8	27.81	261619.0
2008-03-14 17:00:00	MSFT	Stock	27.82	27.83	27.82	27.83	7603.0
2008-03-14 17:30:00	MSFT	Stock	27.83	27.83	27.82	27.82	1700.0

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

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