PREVIEW / stock_30min / 2008-06-24

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-24.parquet
  size:    1.3 MB
  rows:    69,410
  symbols: 3,341

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-06-24 07:00:00	AAPL	Stock	6.15	6.15	6.1164	6.1243	50428.0
2008-06-24 07:30:00	AAPL	Stock	6.1179	6.1389	6.1179	6.1389	107352.0
2008-06-24 08:00:00	AAPL	Stock	6.1336	6.1429	6.1179	6.1357	812812.0
2008-06-24 08:30:00	AAPL	Stock	6.1361	6.1414	6.1286	6.135	356160.0
2008-06-24 09:00:00	AAPL	Stock	6.1375	6.1854	6.1236	6.1536	1448328.0
2008-06-24 09:30:00	AAPL	Stock	6.1536	6.2107	6.1296	6.1946	77095452.0
2008-06-24 10:00:00	AAPL	Stock	6.1964	6.2104	6.1536	6.1811	70949396.0
2008-06-24 10:30:00	AAPL	Stock	6.1811	6.2321	6.1429	6.2155	62462064.0
2008-06-24 11:00:00	AAPL	Stock	6.2182	6.2586	6.2039	6.22	53588500.0
2008-06-24 11:30:00	AAPL	Stock	6.22	6.2764	6.2061	6.2607	42034692.0
2008-06-24 12:00:00	AAPL	Stock	6.2593	6.2779	6.2486	6.2539	26184704.0
2008-06-24 12:30:00	AAPL	Stock	6.2539	6.2618	6.2232	6.2357	23270660.0
2008-06-24 13:00:00	AAPL	Stock	6.235	6.2546	6.2171	6.2318	28795732.0
2008-06-24 13:30:00	AAPL	Stock	6.2314	6.2475	6.2125	6.2357	29170792.0
2008-06-24 14:00:00	AAPL	Stock	6.2357	6.2579	6.2271	6.2375	31709160.0
2008-06-24 14:30:00	AAPL	Stock	6.2379	6.2379	6.1796	6.2039	37429308.0
2008-06-24 15:00:00	AAPL	Stock	6.2037	6.2171	6.1571	6.1653	53396952.0
2008-06-24 15:30:00	AAPL	Stock	6.1654	6.1875	6.1604	6.1875	53563412.0
2008-06-24 16:00:00	AAPL	Stock	6.1875	6.2041	6.1741	6.1875	6591760.0
2008-06-24 16:30:00	AAPL	Stock	6.1882	6.1964	6.1875	6.1964	810124.0
2008-06-24 17:00:00	AAPL	Stock	6.1964	6.1964	6.1929	6.1929	41664.0
2008-06-24 17:30:00	AAPL	Stock	6.1979	6.1979	6.1961	6.1961	12320.0
2008-06-24 18:00:00	AAPL	Stock	6.1961	6.2018	6.1957	6.2018	59388.0
2008-06-24 18:30:00	AAPL	Stock	6.1971	6.2018	6.1964	6.1964	38892.0
2008-06-24 19:00:00	AAPL	Stock	6.1982	6.2018	6.1968	6.1968	17360.0
2008-06-24 19:30:00	AAPL	Stock	6.2	6.2	6.1946	6.1957	36904.0
2008-06-24 07:00:00	MSFT	Stock	27.75	27.75	27.63	27.63	800.0
2008-06-24 07:30:00	MSFT	Stock	27.64	27.64	27.64	27.64	300.0
2008-06-24 08:00:00	MSFT	Stock	27.78	27.79	27.64	27.77	18916.0
2008-06-24 08:30:00	MSFT	Stock	27.75	27.85	27.75	27.79	11150.0
2008-06-24 09:00:00	MSFT	Stock	27.8	27.97	27.8	27.91	392254.0
2008-06-24 09:30:00	MSFT	Stock	27.91	28.0	27.66	27.74	5076313.0
2008-06-24 10:00:00	MSFT	Stock	27.74	27.74	27.55	27.675	5152538.0
2008-06-24 10:30:00	MSFT	Stock	27.68	27.75	27.51	27.74	4109804.0
2008-06-24 11:00:00	MSFT	Stock	27.74	27.89	27.65	27.73	3966647.0
2008-06-24 11:30:00	MSFT	Stock	27.72	27.94	27.67	27.8	3673271.0
2008-06-24 12:00:00	MSFT	Stock	27.79	27.94	27.75	27.89	3272095.0
2008-06-24 12:30:00	MSFT	Stock	27.9	27.95	27.72	27.8	3036389.0
2008-06-24 13:00:00	MSFT	Stock	27.8	27.91	27.73	27.86	4533933.0
2008-06-24 13:30:00	MSFT	Stock	27.86	28.01	27.79	28.0	4620296.0
2008-06-24 14:00:00	MSFT	Stock	27.99	28.0	27.83	27.93	3506274.0
2008-06-24 14:30:00	MSFT	Stock	27.924	27.96	27.74	27.82	3983442.0
2008-06-24 15:00:00	MSFT	Stock	27.82	27.91	27.78	27.82	3260241.0
2008-06-24 15:30:00	MSFT	Stock	27.82	27.82	27.64	27.73	8557223.0
2008-06-24 16:00:00	MSFT	Stock	27.75	27.846	27.66	27.74	3956356.0
2008-06-24 16:30:00	MSFT	Stock	27.75	27.75	27.73	27.73	156148.0
2008-06-24 17:00:00	MSFT	Stock	27.73	27.75	27.73	27.75	3872.0
2008-06-24 17:30:00	MSFT	Stock	27.75	27.76	27.75	27.76	1000.0
2008-06-24 18:00:00	MSFT	Stock	27.77	27.77	27.76	27.76	350.0
2008-06-24 18:30:00	MSFT	Stock	27.78	27.78	27.75	27.75	2188.0

> showing 50 of 69,410 rows — these rows as CSV

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