PREVIEW / stock_30min / 2009-10-30

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-10-30.parquet
  size:    1.4 MB
  rows:    74,750
  symbols: 3,411

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
2009-10-30 05:30:00	AAPL	Stock	7.0407	7.0407	7.0407	7.0407	2800.0
2009-10-30 06:30:00	AAPL	Stock	7.0407	7.0407	7.0407	7.0407	13468.0
2009-10-30 07:00:00	AAPL	Stock	7.0189	7.0189	7.0036	7.0171	96460.0
2009-10-30 07:30:00	AAPL	Stock	7.0089	7.0089	6.9907	7.0004	56000.0
2009-10-30 08:00:00	AAPL	Stock	6.995	7.0214	6.995	7.0125	678972.0
2009-10-30 08:30:00	AAPL	Stock	7.0193	7.0214	6.9893	6.9893	607320.0
2009-10-30 09:00:00	AAPL	Stock	6.9868	7.0107	6.9832	6.9996	753480.0
2009-10-30 09:30:00	AAPL	Stock	6.9996	7.0286	6.9554	6.9839	77291256.0
2009-10-30 10:00:00	AAPL	Stock	6.9854	7.005	6.965	6.9664	33171012.0
2009-10-30 10:30:00	AAPL	Stock	6.9657	6.9768	6.9364	6.9679	37421160.0
2009-10-30 11:00:00	AAPL	Stock	6.9689	6.9689	6.9243	6.9246	29147188.0
2009-10-30 11:30:00	AAPL	Stock	6.925	6.9371	6.8107	6.8393	68336800.0
2009-10-30 12:00:00	AAPL	Stock	6.8393	6.8621	6.7993	6.8132	50569148.0
2009-10-30 12:30:00	AAPL	Stock	6.8146	6.8336	6.7204	6.7517	73889284.0
2009-10-30 13:00:00	AAPL	Stock	6.7511	6.7975	6.7425	6.7794	45938928.0
2009-10-30 13:30:00	AAPL	Stock	6.7811	6.8054	6.7439	6.7775	41027308.0
2009-10-30 14:00:00	AAPL	Stock	6.7793	6.8271	6.7779	6.8025	41001548.0
2009-10-30 14:30:00	AAPL	Stock	6.8018	6.8025	6.7679	6.7811	34309632.0
2009-10-30 15:00:00	AAPL	Stock	6.7793	6.7829	6.7321	6.7629	55900516.0
2009-10-30 15:30:00	AAPL	Stock	6.7629	6.7939	6.6452	6.7321	89930400.0
2009-10-30 16:00:00	AAPL	Stock	6.7321	6.8791	6.7257	6.7286	18974004.0
2009-10-30 16:30:00	AAPL	Stock	6.7286	6.8174	6.725	6.7314	2667756.0
2009-10-30 17:00:00	AAPL	Stock	6.76	6.76	6.7257	6.7314	729260.0
2009-10-30 17:30:00	AAPL	Stock	6.7311	6.7321	6.7268	6.7268	252532.0
2009-10-30 18:00:00	AAPL	Stock	6.7268	6.7321	6.725	6.7304	890512.0
2009-10-30 18:30:00	AAPL	Stock	6.7311	6.7379	6.7286	6.7375	293608.0
2009-10-30 19:00:00	AAPL	Stock	6.7407	6.7411	6.7357	6.7411	111776.0
2009-10-30 19:30:00	AAPL	Stock	6.7357	6.7407	6.7286	6.7332	93744.0
2009-10-30 20:00:00	AAPL	Stock	6.85	6.85	6.85	6.85	3024.0
2009-10-30 07:30:00	MSFT	Stock	28.23	28.23	28.19	28.19	200.0
2009-10-30 08:00:00	MSFT	Stock	28.23	28.23	28.17	28.21	112382.0
2009-10-30 08:30:00	MSFT	Stock	28.17	28.25	28.1	28.15	3100.0
2009-10-30 09:00:00	MSFT	Stock	28.16	28.19	28.03	28.05	33698.0
2009-10-30 09:30:00	MSFT	Stock	28.03	28.25	28.0	28.16	6534675.0
2009-10-30 10:00:00	MSFT	Stock	28.16	28.4	28.1	28.23	4116042.0
2009-10-30 10:30:00	MSFT	Stock	28.23	28.3	28.19	28.27	2665116.0
2009-10-30 11:00:00	MSFT	Stock	28.27	28.28	28.16	28.17	3093593.0
2009-10-30 11:30:00	MSFT	Stock	28.16	28.23	28.0	28.13	4265660.0
2009-10-30 12:00:00	MSFT	Stock	28.13	28.14	27.87	27.93	4223847.0
2009-10-30 12:30:00	MSFT	Stock	27.92	28.09	27.78	27.9	7055721.0
2009-10-30 13:00:00	MSFT	Stock	27.9	27.98	27.82	27.84	4117798.0
2009-10-30 13:30:00	MSFT	Stock	27.85	27.91	27.66	27.82	4854032.0
2009-10-30 14:00:00	MSFT	Stock	27.82	27.95	27.78	27.84	3489501.0
2009-10-30 14:30:00	MSFT	Stock	27.83	27.89	27.69	27.89	3597985.0
2009-10-30 15:00:00	MSFT	Stock	27.88	27.88	27.66	27.74	6629153.0
2009-10-30 15:30:00	MSFT	Stock	27.74	27.87	27.66	27.73	8911544.0
2009-10-30 16:00:00	MSFT	Stock	27.68	27.987	27.65	27.7	5348117.0
2009-10-30 16:30:00	MSFT	Stock	27.7	27.87	27.463	27.83	629407.0
2009-10-30 17:00:00	MSFT	Stock	27.62	27.62	27.53	27.6	900.0
2009-10-30 17:30:00	MSFT	Stock	27.6	27.73	27.6	27.6	3847.0

> showing 50 of 74,750 rows — these rows as CSV

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