PREVIEW / stock_30min / 2008-04-29

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-29.parquet
  size:    1.2 MB
  rows:    68,362
  symbols: 3,297

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-04-29 07:00:00	AAPL	Stock	6.1179	6.1296	6.1179	6.1296	11200.0
2008-04-29 07:30:00	AAPL	Stock	6.1293	6.1514	6.1268	6.1357	38920.0
2008-04-29 08:00:00	AAPL	Stock	6.1321	6.1464	6.1268	6.1396	1536024.0
2008-04-29 08:30:00	AAPL	Stock	6.1421	6.1461	6.125	6.1311	1268428.0
2008-04-29 09:00:00	AAPL	Stock	6.1321	6.1375	6.1107	6.1107	716212.0
2008-04-29 09:30:00	AAPL	Stock	6.1111	6.1929	6.0804	6.1832	125761692.0
2008-04-29 10:00:00	AAPL	Stock	6.1839	6.2125	6.1375	6.145	101058860.0
2008-04-29 10:30:00	AAPL	Stock	6.145	6.1961	6.1425	6.1843	64298500.0
2008-04-29 11:00:00	AAPL	Stock	6.1843	6.2418	6.1768	6.2369	72177924.0
2008-04-29 11:30:00	AAPL	Stock	6.2371	6.2407	6.2082	6.2107	52199084.0
2008-04-29 12:00:00	AAPL	Stock	6.2107	6.2279	6.1954	6.2232	37184476.0
2008-04-29 12:30:00	AAPL	Stock	6.2236	6.2343	6.2171	6.2251	44359560.0
2008-04-29 13:00:00	AAPL	Stock	6.2257	6.2479	6.2218	6.2446	51043916.0
2008-04-29 13:30:00	AAPL	Stock	6.2448	6.2571	6.225	6.2418	66878756.0
2008-04-29 14:00:00	AAPL	Stock	6.2418	6.2668	6.2304	6.2582	58100336.0
2008-04-29 14:30:00	AAPL	Stock	6.2571	6.2736	6.25	6.2664	62119400.0
2008-04-29 15:00:00	AAPL	Stock	6.2668	6.2736	6.2375	6.2471	63697424.0
2008-04-29 15:30:00	AAPL	Stock	6.2468	6.2543	6.2346	6.2518	83693988.0
2008-04-29 16:00:00	AAPL	Stock	6.2502	6.2557	6.1591	6.1591	11045384.0
2008-04-29 16:30:00	AAPL	Stock	6.25	6.2543	6.2436	6.25	448560.0
2008-04-29 17:00:00	AAPL	Stock	6.2536	6.2554	6.2507	6.2507	72268.0
2008-04-29 17:30:00	AAPL	Stock	6.2243	6.2543	6.2243	6.25	295204.0
2008-04-29 18:00:00	AAPL	Stock	6.2493	6.2589	6.2479	6.2571	398552.0
2008-04-29 18:30:00	AAPL	Stock	6.2571	6.2589	6.2504	6.2589	179452.0
2008-04-29 19:00:00	AAPL	Stock	6.2589	6.2589	6.2536	6.2564	133980.0
2008-04-29 19:30:00	AAPL	Stock	6.2568	6.2607	6.2536	6.2607	151816.0
2008-04-29 08:00:00	MSFT	Stock	29.0	29.0	28.84	28.89	32075.0
2008-04-29 08:30:00	MSFT	Stock	28.91	28.99	28.87	28.99	19828.0
2008-04-29 09:00:00	MSFT	Stock	28.98	28.99	28.8	28.8	213550.0
2008-04-29 09:30:00	MSFT	Stock	28.81	28.9	28.6	28.63	10723750.0
2008-04-29 10:00:00	MSFT	Stock	28.63	28.75	28.45	28.52	10982491.0
2008-04-29 10:30:00	MSFT	Stock	28.525	28.7	28.45	28.54	7189723.0
2008-04-29 11:00:00	MSFT	Stock	28.54	28.6	28.51	28.53	5633068.0
2008-04-29 11:30:00	MSFT	Stock	28.53	28.61	28.5	28.572	3700515.0
2008-04-29 12:00:00	MSFT	Stock	28.57	28.59	28.5	28.58	3863741.0
2008-04-29 12:30:00	MSFT	Stock	28.57	28.62	28.5	28.55	3341972.0
2008-04-29 13:00:00	MSFT	Stock	28.558	28.74	28.49	28.692	5061403.0
2008-04-29 13:30:00	MSFT	Stock	28.69	28.78	28.59	28.668	5047007.0
2008-04-29 14:00:00	MSFT	Stock	28.67	28.76	28.65	28.7	4206318.0
2008-04-29 14:30:00	MSFT	Stock	28.7	28.88	28.67	28.88	5267902.0
2008-04-29 15:00:00	MSFT	Stock	28.88	28.89	28.66	28.701	5762663.0
2008-04-29 15:30:00	MSFT	Stock	28.67	28.74	28.64	28.65	9347493.0
2008-04-29 16:00:00	MSFT	Stock	28.65	28.756	28.558	28.756	1981826.0
2008-04-29 16:30:00	MSFT	Stock	28.66	28.68	28.64	28.67	67494.0
2008-04-29 17:00:00	MSFT	Stock	28.68	28.68	28.64	28.64	8347.0
2008-04-29 17:30:00	MSFT	Stock	28.59	28.65	28.59	28.64	19233.0
2008-04-29 18:00:00	MSFT	Stock	28.64	28.64	28.61	28.62	7364.0
2008-04-29 18:30:00	MSFT	Stock	28.62	28.65	28.6	28.63	5550.0
2008-04-29 19:00:00	MSFT	Stock	28.63	28.64	28.62	28.62	1400.0
2008-04-29 19:30:00	MSFT	Stock	28.62	28.66	28.62	28.66	5349.0

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

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